How to change Template Comments/Tips?

G

Guest

I am using Excel 2003. I am using the Expense Statement Template which comes
with Excel. This template contains comments or some sort of tips when you
click on certain cells. On this particular template there is a section
called "Offical Use Only". When I click on one of the cells in this area, I
receive a pop-up or comment/tip which explains the use of these cells. How
can I change, delete, or modifiy the contents of these comments/tip?
Respectfully, Scott Loga
 
G

Gord Dibben

Scott

Those pop-ups are Data Validation messages.

First go to Tools>Protection and Unprotect Sheet.

Next, click on the cell and Data>Validation. Change the input message.

OR just "Clear All" to delete.


Gord Dibben MS Excel MVP
 

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

Top