Changing a comment shape

Excel 2016 2013 2010 2007 2003
The kind of comments that users of earlier versions of Excel used to work in Excel for Microsoft 365 are called notes. You cannot change the shape of comments because all comments are displayed in the separate pane with threads or in the Comments pane (see How to hide/show note and comment indicators for more details).

When a note is inserted in a cell, the little red triangle is displayed:

Notes indicator in Excel 365

Usually, when you add the note, it has a rectangular shape, but you can give the cell note any form you want:

Example of Note Shape in Excel 365

To change the shape of a cell note, add a command to your Quick Access toolbar (see Adding commands to the Quick Access Toolbar):

   1.   To the right of the Quick Access toolbar, click the tiny arrow button to open the drop-down menu:

Quick Access in Excel 365

   2.   Near the bottom of the menu, click More Commands....

   3.   In the Excel Options dialog box:

  • From the Choose commands from drop-down list, select Drawing Tools | Shape Format Tab.
  • From the list on the left, select Change Shape and then click Add >>:
    Quick Access Excel 365

   4.   Click OK to close the Excel Options dialog box.

After performing these steps, your Quick Access toolbar has a new Change Shape icon:

Change Shape in Quick Access Excel 365

To change the shape of a note, do the following:

  • Ensure that it is visible (for example, by right-clicking the cell and selecting Show/Hide Comments).
  • Click the note's border to select it as a Shape (or, Ctrl-click the note to select it as a Shape).
  • Click the Change Shape button on the Quick Access toolbar and choose a new shape for the note box:
Note Shape in Excel 365

See also this tip in French: Comment changer une forme de commentaire Excel.

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information you’ve provided to them or they’ve collected from your use of their services.

Learn more