??

C

Caroline

I am currently working on a worksheet created by someone else so am not sure
how this is done.

When I click on any cell in the worksheet- the office assistant appears with
comments relating to data that needs to be entered into the cell.

Can someone please tell me how to stop this from appearing. I have tried
turning off the Office Assistant but the comments still appear It seems like
every column in the spreadsheet has a different comment with relevant input
instructions.

I have looked under all the help topics regarding comments...but none of
them apply. Am not really sure where to look now!

Please help
 
R

Rowan

Look in Data>Validation>Input Message.
There is a clear all button but this only seems to work for the selected cell.
If I select a range of cells with different validation messages and go into
Data>Validation I get a option to remove all data validation which may have
the desired effect for you.

Hope this helps
Rowan
 
R

Rowan

You're welcome. It would drive me mad having a comment appear eveytime I
selected a cell.
 
Top