How to Insert, Delete, Customize Comments in Excel

This tutorial provides information on the comment feature available in Excel 2013 & Excel 2010. The following will be covered as part of this tutorial.

  • How to insert comment
  • Customize the comment box
  • Navigate between Comments
  • Delete Comment

How to insert comment

Excel allows users to insert comment using the options available as part of the Review menu. But if you want to quickly insert then right click on the cell and select Insert Comment from the listed menus.

image

image

 

Customize Comment

A typical comment box in Excel is as shown below.

image

In order to change the name that appears on the Comment box, click on the File menu then the Option link then in the General tab, navigate to Personalize your copy if Microsoft Office and enter your desired name in the User name box. Click OK button to save the changes. Now the entered name will appear when you Insert new Comments.

image

Similarly if you want to change the Font Style used in Comment box then select then right click on the Comment box and select Format Comment menu option.

image

The Format Comment window allows you change the Comments Font Style.

image

Navigate between Comments

If you have more than one comment inserted in the Excel worksheet and you want to navigate between the comments then you can use the menu options available as part of the Comment section under Review menu. The list option includes Show All Comments, Previous and Next.

image

Delete Comment

A Comment can be quickly deleted are hidden by right clicking on the cell and selecting the required menu option. You can also use the menu option available as part of the Comments section under Review menu.

image

image

By this way you can Insert, customise, navigate and delete comments in Excel 2013 and Excel 2010

In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 8 Comments
  • Guna November 18, 2011, 11:22 am

    gdfgdfgdg

  • Kali Stage January 3, 2012, 8:01 am

    I really enjoy the post.Really looking forward to read more. Cool.

  • S MAHARAJA January 20, 2012, 10:30 am

    How to print the viewed comments?.

  • Scott Ridgeway June 13, 2012, 2:05 am

    Is there a limit to the amount of comments allowed in one document? The file in question has many (hundreds). Now, when I right click and request to edit a comment, the comment box will not appear, however this function works fine in similar files that do not have as many comments. Have I reached my limit? If so, can the limit be raised?

    Thanks for your help.

  • Carolyn Byrnes October 23, 2013, 3:42 am

    How do you get rid of the : after the name in the box. Successfully removed the name!

  • Ravi Shankar October 23, 2013, 1:13 pm

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.