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.

______________

You may also like...

8 Responses

  1. Bhavi says:

    Thanks for the Tip, I managed to add this to the custom header.

  2. Greg says:

    As I am working very much with excel I find this very useful, Thanks for the great tips!

  3. Momina says:

    thanks, that was awesome!

  4. That’s a great tip! I already knew how to add an image to a comment, but I hadn’t seen this before. Nice post.

  5. SHASHI says:

    Thanks, great experience, I love EXCEL

  6. rejesh says:

    thank you its very use ful

  7. UmmTaaha says:

    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 Greg Cancel reply

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