Hiding a unwanted Note

[anandmr]

I am using a existing excel worksheet.

When some cells are activated a note pops up with some instructions
This looks like a comment but I am very sure these are not comment
because, it allows to insert the comments also for those cells .

These notes pops up as soon as the sepcified cells are selected. I a
unable to Hide/Delete or edit this. It can be moved to any place o
worksheet and has no indicating line. As soon as the control moves t
another cell this disappears.

What are these ? How to put a new one ? and how to delete /hide/ edi
the existing note.

Could somebody help me on this.

Thanks in Advance
Anan

 

[Dave Hawley]

Hi Anand

Probably Excel's Validation feature. Select the cell and go to
Data>Validation then click the "Input message" tab.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

 

[anandmr]

Thanks a lot Dave Hawley for hitting the bull's eye...

Problem solve