How To Change The Shape Of Comment Box In Excel

Published on January 31, 2017
image_pdfimage_print

Changing The Shape Of Comment Box In Excel

I don’t like ‘normal’. Anything that is common doesn’t excite me. And that part of my character also reflects in the way I use Excel. I always keep looking for ways in which I can make my worksheets stand out from those of others.

Excel is a very dynamic software, in the sense that you can customize it in almost any way you want to. Also, you can change most of the default settings in excel. Of course, you need to know how you can do this.

Today, let’s discuss one such way in which we can make our worksheets look different.

Did you know that we can actually change the shape of the comment boxes in excel? By default, the comment box is a boring rectangular shaped box. But we always have the option to change that shape.

 

Below are the steps to change the shape of comment box in Excel:

  1. Click the drop-down on the Quick Access Toolbar, and click ‘More Commands…’.

2. In the Excel Options dialog box, go to ‘Choose commands from’ drop-down and select ‘Drawing Tools丨Format Tab’ (see screenshot).

3.Select ‘Change Shape’ in the list of commands, and then click ‘Add>>’ button to add it to the quick access toolbar.

excel options

4. Click ‘OK’ to close the ‘Excel Options’ dialog box. ‘Change Shape’ button will start to show in the Quick Access Toolbar.

5. Select the cell that contains the comment that you want to change the shape of.

6. Go to ‘Review’ tab in the main menu and select ‘Edit Comment’.

review tab

7. Then click the border of the selected comment.

8. Then on the Quick Access Toolbar, click the ‘Change Shape’ button, and select the shape that you want to use. The shape of the comment box will change to whatever shape you chose here.

Isn’t that cool? 

Now you know one way you can make your worksheets look more interesting.

Please note that by using the steps above you can change the shape of only one comment box at a time. To change the shape of multiple comment boxes, you will need to repeat Steps 5 to 8 above for each comment box. I highly recommend watching the video for this tutorial to get more clarity.

If you found the post useful and interesting, please share it with your friends on Facebook, Twitter etc. by using the buttons above and below the post.

To get such cool excel tips in your inbox you can subscribe to our newsletter by entering your name and email id in the subscription box below this post. You can also do the same by unlocking the video for this post by entering your name and email id.

See you soon with another amazing excel tip. Till then HAPPY EXCELLING!!

Get my ULTIMATE EXCEL SHORTCUTS COURSE
worth $40 for FREE!!

Subscribe to our newsletter and get interesting stuff and updates to your email inbox.

Thank you for subscribing.

Something went wrong.

    1. Rahul Gupta February 2, 2017
      • VIKRAM NARSARIA February 2, 2017
Huge Discount on the Best ADVANCED EXCEL Course. GET IT NOW!! CLICK HERE!!
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
BECOME AN EXCEL NINJA COMPLETE REVIEW
Become An Excel Ninja – Course Review
BEST EXCEL COURSES
10 Best Online Courses to Make You an Excel Wizard
HOW TO GET MY $40 COURSE FOR FREE
Get My $40 Excel Course For Free!! COUPON CODE Inside!!
14 Excel tips
14 Excel Tips – Make Yourself Super-Efficient in Excel
DATA CLEANING EXCEL
Ultimate Guide to Data Cleaning in Excel – 11 Super-Powerful Data Cleaning Techniques
RANDOMIZE LIST RANDBETWEEN
Randomize a List in Excel Using RANDBETWEEN Function
HOW TO FIND IF A TEXT STRING CONTAINS SPECIFIC TEXT IN EXCEL
How to Find if a Text String Contains Specific Text in Excel
BEST BOOKS COURSES EXCEL VBA
Best Books and Courses to Learn Excel VBA
How to Sort Excel Worksheet in Alphabetical Order
How to Sort Excel Worksheets in Alphabetical Order
VBAPOST1
How to Add And Name A New Sheet At The Same Time Using Excel VBA
ROUNDING NUMBERS IN EXCEL
Rounding Numbers in Excel – The Complete Guide
number_of_words
How to Find the Number of Words in a Text String in Excel
HOW TO FIND IF A TEXT STRING CONTAINS SPECIFIC TEXT IN EXCEL
How to Find if a Text String Contains Specific Text in Excel
How To Indentify ULP case in a text string
How To Identify If A Text String Is In Upper, Lower Or Proper Case
How To Change Shape of Comment Box in Excel
How To Change The Shape Of Comment Box In Excel
Excel Dumbest Challenge
Excel Dumb Challenge – Do You Have Time To Waste?

Get my ULTIMATE EXCEL SHORTCUTS COURSE
worth $40 for FREE!!

Thank you for subscribing.

Something went wrong.

Share
Tweet
+1
Pin
Share
Stumble
Enjoyed this video?
How To Change Shape of Comment Box in Excel
"No Thanks. Please Close This Box!"