Excel

Change the Shape/Color of Cell Comments in Excel

Almost all of us use Excel everyday. We use comment in a particular cell in Excel to provide some extra information. But the default shape of the comment is rectangular and sometimes it does not solve our purpose. In the earlier version of MS Excel i.e Excel 2003, it was bit easy to change the shape of the comment. But in 2007 although it is easy, it is hidden. Today I am going to tell you how to change the shape and color of comments in 2007 Excel.1. Adding Change Shape button in Quick Access Toolbar

  • Right click on Quick Access Toolbar–>Click on Customize Quick Access Toolbar. It will open another window.
Customize Quick Access Toolbar...
  • You can see there a dropdown called Choose command from. Select All command from the list and search for Change shape in the list. Click on Add and click OK.
Select All Commands
  • Now a Change shape button will appear in your Quick Access Toolbar.

2. Changing the shape of the cell comments

  • Now Right click on the cell where you have inserted the comment–>Click on Edit Comment
  • A rectangular box will appear with the comment, click on the border of the box.
  • Now go to the Change shape button which you have just added to the Quick Access Toolbar and choose a shape of your choice.
Choose any shape

3. Changing the background colors and border 

  •  To change the background color, right click on the cell where you have inserted the comment–>Click on Edit Comment
  •  A rectangular box will appear with the comment, right click on the border of the box–>Click on Format comment…
  • Now you can change the color, margin, border etc.
Comments with different shapes

Also read 10 advanced formatting tricks for Excel users


Courtesy: funbutlearn.com

Comments

  1. Pingback: 4 trucos interesantes de Excel que debes conocer | creatiabusiness

Leave a Reply

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

10 + fifteen =

This site uses Akismet to reduce spam. Learn how your comment data is processed.