??
 

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

Look in DataValidationInput 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
DataValidation I get a option to remove all data validation which may have
the desired effect for you.

Hope this helps
Rowan

"Caroline" wrote:

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

Rowan - Thank you ever so much for that. Much appreciated!!!!


"Rowan" wrote:

Look in DataValidationInput 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
DataValidation I get a option to remove all data validation which may have
the desired effect for you.

Hope this helps
Rowan

"Caroline" wrote:

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

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

"Caroline" wrote:

Rowan - Thank you ever so much for that. Much appreciated!!!!


"Rowan" wrote:

Look in DataValidationInput 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
DataValidation I get a option to remove all data validation which may have
the desired effect for you.

Hope this helps
Rowan

"Caroline" wrote:

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