Annotate a Worksheet

Insert comments

Select the cell to insert comment

Do one of the following:

  • Go to Review tab > Comments group > click Insert Comment

  • Press SHIFT + F2 key

 

Edit comments

  • Select the cell that has a comment inserted

  • Do one of following:

    • Go to Review tab > Comments group > click Edit Comment

    • Right click on the cell > select Edit Comment

    • Press SHIFT + F2

 

Change the shape of the comment

  • Right click on the cell > click Edit Comment

 

  • Click on the border of the comment box

  • Go to Insert tab > Illustration group > click Shape


Insert picture in a comment

  • Select the cell that has a comment inserted

  • Right click on the cell > select Edit Comment

  • Click on the border of the comment box

  • Right click on the cell > click Format Comment

  • In the Format Comment dialog box, do the following:

    • Choose Colors and Lines tab

    • In Fill section, click the Colors arrow down > select Fill Effect

  • In the Fill Effects dialog box, do the following:

    • Choose Picture tab

    • Click Select Picture to browse the pictures to insert in comments


Print comments on the sheet

  • Go to Review tab > Comments group > click on Show All Comments to make all the comments visible

  • Go to File tab > click Print > click Page Setup

    

  • In the Page Setup dialog box, do the following:

    • Choose Sheet tab

    • Under Print section, click the Comments down arrow > select As displayed on sheet check box

    • Click OK