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
 
 

Comments

  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 *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.