ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   click on a cell to expand with more information (https://www.excelbanter.com/new-users-excel/24994-click-cell-expand-more-information.html)

Dodge Lisa

click on a cell to expand with more information
 
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


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.

--
Andy.


"Dodge Lisa" <Dodge wrote in message
...
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





All times are GMT +1. The time now is 07:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com