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
- Select the cell with the attached comment.
- Press Shift + F2 to edit the comment.
- 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.
- Click the Draw button on the Drawing toolbar and choose Change AutoShapes.
- Then, select one of the AutoShape categories from the resulting submenu.
- Next, choose one of the shapes from the resulting palette.
- 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.