Saturday, November 28, 2009

Editing Comments in Excel?

I inherited a spreadsheet from the UK that has comments. But these aren't the standard comments that you can edit when you right-click or go to View %26gt;%26gt; Comments. This comment appears on the screen when it's cell is highlighted, but it is not the standard comment that has the indicator (even though "Comment %26amp; Indicator" is selected in options).



Can someone please help solve this mystery. And yes, I know how to use the standard comments that you add when you right-click and select "Insert Comment" so no need to point me to that.



Thanks!



Editing Comments in Excel?

Check the Input Message on Data Validation.



-Open the spreadsheet



-Data | Validation | Input Message



Editing Comments in Excel?

Check to see if the workbook is Protected.

No comments:

Post a Comment

 
commericial loan