Change a Comment Shape in Excel 2007

In earlier versions of Excel you could insert a comment on the worksheet, and then use the Drawing toolbar commands to change the comment’s rectangle to a different shape.¬† It’s not a technique that you’d want to use too often, but it can add impact to a worksheet if used sparingly.
CommentStar
In Excel 2007, the Drawing Tools¬† Format tab doesn’t appear on the Ribbon when you select a comment, so the Change Shape command isn’t available. It’s still possible to change the comment’s shape, but it takes a bit more effort.

Add the Change Shape Command

The first step is to add the Change Shape command to the Quick Access Toolbar (QAT):

  1. Right-click the QAT, and click Customize Quick Access Toolbar
  2. In the Choose commands from drop down list, click Drawing Tools | Format Tab
  3. In the list of commands, click Change Shape, and click Add
    ChangeShapeAdd
  4. Click OK to close the Excel Options window.

Change the Comment Shape

  1. Select the cell that contains the comment
  2. On the Ribbon, click the Review tab, and click Edit Comment
  3. Click the border of the comment, to select the shape.
  4. On the QAT. click Change Shape, and click on the shape that you want to use.

CommentChangeShape

Watch the Video

To see the steps for adding the Change Shape command, and changing the comment shape, please watch this short Excel video tutorial.

______________

0 thoughts on “Change a Comment Shape in Excel 2007”

  1. I followed the video exactly and was able to add change shapes to QAT. However selecting the comment box and then going on change shapes command did not change the shape of the comment box. Rather on a second click it adds a shape to the excel sheet.
    What is it that I am doing wrong.
    Please help.

Leave a Reply to Anonymous Cancel reply

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

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