Changing The Default Cell Comment FormatIn Microsoft Excel 2010

 

In this article, we will learn how to change the default cell comment format in Microsoft Excel 2010.

 

To change the default cell comment format for Windows 7 Home Premium, Professional, Ultimate, or Enterprise, follow the below mentioned steps:

 

  • Right click on the empty space on the desktop and click on Personalize.
  • Click on the Window Color link at the bottom of the window.

 
img1
 

  • Window Color and Appearance window will be open
  • Click on Item option

 
img2
 

  • Select Tool Tip & change the formatting options of your choice.

 
img3
 

  • Click on the OK button.
  • Select any cell & insert comment. You will notice that there is a considerable change in the size of the cell format.

 
Snapshot of the report before cell formatting
 
img4
 
Snapshot of the report after cell formatting
 
img5
 
 



5 thoughts on “Changing The Default Cell Comment FormatIn Microsoft Excel 2010

  1. it doesn’t work for me – i followed the steps above but the comment text still default to Tahoma font style.
    i don’t see/have the Advance button after step 3.
    please help

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>