excel2007.Tips.Net Welcome toExcel2007.Tips.Net

Helpful Links

Excel 2007 Home
Tips.Net Home

Ask a Question
Make a Comment

Family Tips
Gardening Tips
Pest Tips
WordTips

Newest Tips

Changing a Link's Source

Using Conditional Formatting to Shade Rows

Editing by Moving and Copying

Making Sure Duplicate Names Aren't Entered

Applying a Conditional Format to a Full Row

Hiding Worksheet Tabs

Making Cells Flash

 

Disabling ScreenTips

Summary: ScreenTips are one of those artifacts of Microsoft trying to make Excel be overly helpful. If the ScreenTips bother you, you can turn them off by following this tip.

ScreenTips are the small yellow boxes that appear as you position the mouse pointer over some elements of your worksheets, such as URLs. They are intended to be helpful reminders of what the element is used for, but some people find these ScreenTips distracting. Fortunately Microsoft provided a way for you to control whether they are displayed or not. To turn off ScreenTips, follow these steps:

  1. Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
  2. Make sure the Popular option is selected at the left of the dialog box. (Click here to see a related figure.)
  3. Using the ScreenTip Style drop-down list, choose Don't Show ScreenTips.
  4. Click OK.

Related Tips:

More Power! For some people, the prospect of creating Word macros can be scary. WordTips: The Macros can help you conquer your fears and you'll discover you're much more confident and productive as you make Word do exactly what you want. This is an invaluable source for learning macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of WordTips. Learn at your own pace, exactly the way you want. Check out WordTips: The Macros today!