How to Set the Defaults for an Excel Comments Box

Written by tricia goss Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Set the Defaults for an Excel Comments Box
Comments can clarify your spreadsheet (woman working on a laptop image by Julia Britvich from Fotolia.com)

When you want to provide extra information about the contents of a cell in your Excel worksheet, you can insert a comment. Comments are small notes you attach to a cell. A cell with a comment displays a small indicator in the upper corner, but the comment itself stays hidden until the user clicks on or points to the cell. Like many Excel features, you can customise the default comment box. To do so, however, you must customise the Windows tooltips, which will change the way all system pop-ups appear.

Skill level:
Moderately Easy

Other People Are Reading

Things you need

  • Windows XP, Vista or 7

Show MoreHide

Instructions

    Set Excel Comment Defaults in Windows XP

  1. 1

    Right-click the desktop, avoiding any icons. Select "Properties" to open the "Display Properties" dialogue box.

  2. 2

    Go to the "Appearances" tab. Click the "Advanced" button to open the "Advanced Appearance" dialogue box.

  3. 3

    Select "Tooltip" from the "Item" list near the bottom of the dialogue box.

  4. 4

    Select the new default colour for Excel comments in the "Color1" box. Choose a default font in the "Font" box, a font size in the "Size" box and a font colour in the "Color" box.

  5. 5

    Click "OK" to apply the changes. Close any open dialogue boxes.

    Set Excel Comment Defaults in Windows Vista

  1. 1

    Right-click the desktop, avoiding any icons. Select "Personalize" to open the "Personalize" window.

  2. 2

    Select "Windows Color and Appearance."

  3. 3

    Click "Open Classic Appearance Properties for More Color Options" at the bottom of the "Windows Color and Appearance" window to open the "Appearance Setting" window.

  4. 4

    Click the "Advanced" button to open the "Advanced Appearance" dialogue box. Select "Tooltip" from the "Item" list near the bottom of the dialogue box.

  5. 5

    Select the new default colour for Excel comments in the "Color1" box. Choose a default font in the "Font" box, a font size in the "Size" box and a font colour in the "Color" box. Click "OK" to apply the changes. Close any open dialogue boxes or windows.

    Set Excel Comment Defaults in Windows 7

  1. 1

    Click the "Start" button. Type "Window Colors" into the "Instant Search" box at the bottom of the Start menu and press "Enter." The "Windows Color and Appearance" window will open.

  2. 2

    Click "Advanced Appearance Settings" at the bottom of the window.

  3. 3

    Select "Tooltip" from the "Item" list near the bottom of the dialogue box.

  4. 4

    Select the new default colour for Excel comments in the "Color1" box. Choose a default font in the "Font" box, a font size in the "Size" box and a font colour in the "Color" box.

  5. 5

    Click "OK" to apply the changes. Close any open dialogue boxes or windows.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.