2 Quick Methods to Create an Attractive Comment with Custom Shape in Excel

If you are bored with the default comment shape, you can also change it according to your own preference.

The default shape of comment is the same as the image below shows.Default Comment Shape

But today, you can also change the shape. There are two different methods to change the comment shape. But actually you will use two different objects in Excel. Let’s see how the two different methods work and find out their difference.

Method 1: Make the Shape Serve as Comment

Shape is a very common feature in Excel. And you can add words into shapes. Therefore, here you can also make it serve as comment.

  1. Click the tab “Insert” in the ribbon.
  2. And then click the button “Shapes”.
  3. In the drop-down list, you can see that there are many different shapes for you to choose. Here we choose one shape in the category of “Callouts”.Choose a Shape
  4. Now drag your mouse in the worksheet and draw a shape.Drag the Shape
  5. Now click the tab “Format” in the ribbon.
  6. In the “Shape Style”, change the style as you like. And then in the “WordArt Styles”, modify the text style that you like.Change Shape Style
  7. Now, move the shape to the certain place.
  8. And drag the yellow point to make it point at the target cell or area.The Yellow Point
  9. Right click the shape.Edit Text
  10. In the menu, choose the option “Edit Text”. Therefore, you can add the comments into the shape.The Result

Except for the rectangular shape, you can also use other shapes. For example, you can add the cloud shape into the worksheet. And this will make your worksheet different from others’.

Cloud Shape

Modify the Comment Shape

Instead of using the shape, you can also change the comment shape through the following steps.

  1. Click the small arrow in the quick access toolbar.
  2. And then choose the option “More Commands”.More Commands
  3. In the “Choose commands from” part, choose the option “All Commands”.
  4. Then drag the scrollbar until you see the option “Change Shape”.
  5. Now choose the option “Change Shape”.
  6. And then click the button “Add”.
  7. After that, click “OK”. Thus, the button of “Shape” will appear in the quick access toolbar.Add Shapes
  8. Now you will come back to the worksheet. Click the border of the comment.
  9. And then click the button “Change Shape” that you have add to the quick access toolbar.
  10. In the drop-down menu, choose a shape that you want to apply.Change Comment Shape

Therefore, the comment shape will change according to your setting.The New Shape

On the other hand, you can also use this feature to change the shape of the “Callouts” that you insert in the previous method.

A Comparison of the two Methods

Here we list the advantages and disadvantages of the two methods.

Comparison Make Shape Serve as Comment Modify Comment Shape
Advantages 1.      You can choose many different shapes and modify the style.

2.      When you create it, you can determine the shape. Thus, you don’t need to change the shape the next time.

1.      The comment is connected with the cell, thus it will always point to the target cell.

2.      All the shapes in Excel are available for comment.

Disadvantages It cannot always point to the target cell if the size of cell changes, or if you need to move the shape. There are many steps to change the comment shapes.

Hence, the next time if you need to add a comment, you can choose the most suitable method.

Choose the Best Way for Excel Corruption

There exist many different reasons that will cause corruption to Excel. Before you take any actions, you need to fine the reason behind the data disaster. Thus, you can choose the best solution. Our potent Excel recovery software has the world leading technology, and it is capable of solving almost all the errors in Excel. Therefore, it is also a good choice for you.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including word recovery and outlook repair software products. For more information visit www.datanumen.com

7 responses to “2 Quick Methods to Create an Attractive Comment with Custom Shape in Excel”

  1. I appreciate, cause I found exactly what I used to be having a look for. You’ve ended my 4 day lengthy hunt! God Bless you man. Have a nice day. Bye

  2. This website was… how do I say it? Relevant!! Finally I have found something which helped me. Appreciate it!

Leave a Reply

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