Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I want to simplify the data entry in a spreadsheet. Currently the user
has to refer to an 11 x 14 sheet with tables front and back to determine what value to enter in a cell. I have used the copy picture function to create a series of tables in Excel and place them into cell comments in the appropriate cells. In an efffort to speed up data entry even more, I was wonderfing if there was a shortcut key to show, then hide again, the comment so the user would not have to reach to the mouse and place it on the current cell in order to see the comment. Since the sheet is full of comments, only the current cell should be affected. Is there a shortcut key to accomplish this by showing/hiding the current comment, or do I need a macro to toggle the current comment on and off? And if so,how? Thanks, and thanks to all who share their time and expertise to help others. Your efforts add so much to the value of Excel! Tonso |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
linking to a cell within a text cell or comment | Excel Worksheet Functions | |||
displaying a comment only when the cell is selected | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) | |||
Highlight Active Cell...With a Diffrence | Excel Discussion (Misc queries) |