click on a cell to expand with more information

D

Dodge Lisa

I am making a phone contact record for work. How can I make a cell (with a
customers name in it) expose more details or information about that customer,
when hovered over with the pointer? I also need to know how to enter the
information to be viewed.

2nd question - How do I create a line between multiple entries for the same
customer and the next customer?
example:

John Doe 05/05/05 123-456-7891 9:00 left message
John Doe 05/08/05 123-456-7891 9:30 left message
John Doe 05/08/05 123-456-7891 10:00 returned call
_________________________________________________________
Jane Smith 05/05/05 123-789-4561 9:05 left message
_________________________________________________________
Scott Davis 05/05/05 123-963-8521 9:10 contact made
_________________________________________________________

I hope that I have been easy to understand. I am trying to learn how to use
excel.
Thank you for any help.
Lisa
 
G

Guest

Hi
Try right-clicking on the cell and selecting 'Insert Comment'. This will
open a text box for you to type into. Once you've finished typing, click
outside the box to close it. A small red triangle shows in the top-right
corner of the cell to let you know that there is a comment in there. When
you hover over the cell, the information will display.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top