Changing The Default Shape Of Excel’s Comment Box


You can change the shape of comments using Excel’s AutoShapes quite easily to make your worksheets more interesting especially if your figures are showing good news

  1. Select the cell with the attached comment.
  2. Press Shift + F2 to edit the comment.
  3. Click the comment’s border — the border appears to be a series of diagonal slashes. When you click the border, it changes to a bunch of small dots.
  4. Click the Draw button on the Drawing toolbar and choose Change AutoShapes.
  5. Then, select one of the AutoShape categories from the resulting submenu.
  6. Next, choose one of the shapes from the resulting palette.
  7. If the new AutoShape isn’t large enough, use the handles to resize it.

At first, this might seem like a neat visual trick, but it’s limited:

  • As yet, I’ve not found a way to reset the comment shape. Ctrl + Z will undo the change, if you do so immediately. Otherwise, you must repeat the process and specify a square AutoShape.
  • You can’t change multiple comments at the same time.
  • This technique doesn’t change the shape of subsequent or existing comments — only the selected comment changes.
  • The comment’s text doesn’t automatically adjust to the new shape, so be careful which shape you choose.

Despite its limitations its a neat trick.

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts