Changing a comment shape

Excel 365
Normally, cell comments are rectangular, but you can give a cell comment any shape you want:
Example of Comment Shape in Excel 2016

To change the shape of a cell comment, 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 Excel 2016

   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 | Format Tab.
  • From the list on the left, select Change Shape and then click Add >>:
    Quick Access Excel 2016

   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 2016

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

  • Make sure that it is visible (right-click the cell and select Show/Hide Comments).
  • Click the comment's border to select it as a Shape (or, Ctrl-click the comment to select it as a Shape).
  • Click the Change Shape button on the Quick Access toolbar and choose a new shape for the comment:
Comment Shape in Excel 2016

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

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.