Delete Display Alert tagged to an individual cell

L

Lisa

In Excel 2000 I have a spreadsheet that seems to have a
cell with a display alert (looks like a text box) - I seem
to gather that its some sort of customized Office
Assistant. The text box can not be dragged outside the
computation area (columns and rows area) of the worksheet
unlike Office Assistant - however when I turn on the Office
Assistant and mouse over to it - the text box becomes a
bubble from the Office Assistant.

I do not need this custom feature... I do not know how it
was created and (1) like to modify the text instead to be
more applicable OR (2) DELETE it all together.

PLEASE HELP ASAP! I need to try this spreadsheet in tomorrow.
Thanks
 
T

Tom Ogilvy

If there isn't a red triangle in the upper right corner of the cell (an
indication of a comment although these can be turned off) then it is
probably produced by data=>validation. Select the cell and do
Data=>Validation and select ClearAll or go to the tabs and modify the
message. If clearall is not offered as a button in the lower left corner of
the dialog, then it may be a comment as previously suggested.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Upload Center on Office 2010 when using encrypted area on disk 0
Dialog controls and display settings 1
Missing default cell styles on some large existing spreadsheets 0
Deletion problem 8
Zeros displaying in cell when using = sign 2
rules and alerts 1
Inserting some sort of sorting tag that doesn't display as text 3
What’s the best way to automatically update dimensions on a drawing image imported from a jpg to Exc 1

Top