Excel: Change the Comment Shape to a Star

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


Problem: I would like to jazz up a comment by changing it to a starburst or some other shape.

Strategy: This trick has become more difficult since Excel 2003, but it is possible with a little customization of the Quick Access toolbar. The command you need is the Change Shape command. It appears on many contextual ribbon tabs, but because Microsoft puts away the tabs when you unselect an object, the command is not available to change the shape of a comment.

Instead, you have to add the icon to the Quick Access toolbar. Follow these steps:

  1. Right-click the Quick Access toolbar and choose Customize Quick Access Toolbar.
  2. In the top-left dropdown, choose All Commands.
  3. Scroll down to the Change Shape icon. Select this item and click the Add button.
  4. Click OK to close the Excel Options dialog.

When the Change Shape icon is on the Quick Access toolbar, follow these instructions to change the comment shape:

  1. Add a regular comment to a cell.
  2. Select the cell that contains the comment.
  3. Choose Review, Edit Comment. The comment will appear, surrounded by diagonal lines.
  4. Left-click the diagonal lines to change them to dots.
  5. Select a new shape from the Change Shapes icon on the QAT.

  1. Select a new shape.

    The comment will change from a rectangle to a starburst. However, the comment is not large enough to show the entire comment.

  2. The shape changes, but the size is wrong.
    1. Grab a corner resize handle and drag to make the shape larger.
    2. On the Home tab, choose Middle Align from the vertical alignment icons. Choose Align Center from the horizontal alignment icons. Increase the font size to 10.

    Results: The comment will appear as a starburst.

  3. The new comment shape.

    Additional Details: You can grab the green rotate handle and rotate until you have the shape that best fits the text.