Changing a comment shape

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