"How To Excel" Mini-Tutorials
by TheExcelAddict.com
"Helping Average Spreadsheet Users Become Local Spreadsheet Experts"

An Alternative To Cell Comments

Cell comments (covered in an earlier tip) are great for displaying messages on your worksheets as reminders for yourself and others. You just hover the mouse over the cell containing the comment for a moment and the comment will pop up. But if you move to that cell using the arrow keys, the comment won't display.

Here is an alternative that you can use to display a message when a cell is selected with either the mouse or the keyboard.

  1. Select the cell where you want to see the message.
  2. Click on the Data menu and select Validation.
  3. Select the Input Message tab.
  4. Put a check mark in the 'Show input message when cell is selected' field.
  5. Type a heading for your message in the Title field. This text will appear in bold at the top of your message.
  6. Enter your message in the 'Input message' field.
  7. Click OK
Now, anytime you move to that cell, the message will pop up. If you develop workbooks for other users this is great tool to use to help them know what to do.

Why not print (CTRL+P) this tip and share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict". Subscribe at the www.TheExcelAddict.com/Newsletter.htm.
You'll be amazed how much time you'll save just by learning a few of these tips.

Copyright 2003 All Rights Reserved by Francis Hayes (The Excel Addict)

If you came to this page from my Excel Mini-Tutorials page, click here to close this window,
otherwise click here and you'll find lots more time-saving Excel tutorials like this one.