Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments Without Indicators; Displayed when Cells are Clicked
I am interested in creating comments that do not have indicators, and that
appear when the cell is clicked. These comments can be moved around, but cannot actually be edited by someone using the worksheet. I've noticed this in a spreadsheet that I have that needs to be edited. I need to recreate some of these comments with the proper information inside. Any ideas? (Excel 03) Thanks- |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments Without Indicators; Displayed when Cells are Clicked
Nevermind I found it!
It's a validation rule. "katzy" wrote: I am interested in creating comments that do not have indicators, and that appear when the cell is clicked. These comments can be moved around, but cannot actually be edited by someone using the worksheet. I've noticed this in a spreadsheet that I have that needs to be edited. I need to recreate some of these comments with the proper information inside. Any ideas? (Excel 03) Thanks- |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments Without Indicators; Displayed when Cells are Clicked
Try going to
Date--Validation Leave it at Any Value Then go to Input Message and type in a comment that you would like the user to see. This eliminates the indicator but still shows a comment when clicked. "katzy" wrote: I am interested in creating comments that do not have indicators, and that appear when the cell is clicked. These comments can be moved around, but cannot actually be edited by someone using the worksheet. I've noticed this in a spreadsheet that I have that needs to be edited. I need to recreate some of these comments with the proper information inside. Any ideas? (Excel 03) Thanks- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show comments, but not the indicators | Excel Discussion (Misc queries) | |||
auto highlighting of cells when clicked on | Excel Discussion (Misc queries) | |||
How Do I turn off indicators and comments? | Excel Discussion (Misc queries) | |||
why is the chart displayed only when the chart area is clicked on? | Charts and Charting in Excel | |||
set up a macro in Excel to color cells when clicked | Excel Worksheet Functions |