navigate Archives - Digital Answers

Adding a comment to a cell in Microsoft Excel is very useful feature. You can always locate a comment by red arrow appearing at the top right corner of the cell.

List below are the steps to search, print and unhide comments in Excel 2013 and Excel 2010.

Search comment in Excel 2013 and Excel 2010

But searching and finding inserted comments in a excel worksheet with number of rows spanning across more than a page will be a huge task. This can be simplified using the Search Comments option available as part of the Find feature. To find comments in Excel 2010 and Excel 2013, navigate to Editing section and click the drop down arrow available next to Find & Select option.

This would display the following menu options as part of the Find & Select feature.

Click Comments from the list of available menus. This would locate the comment in your Excel Worksheet. And if you have more than one comment, then press tab to navigate to each comment.

Print cell comment in Excel 2013 and Excel 2010

Excel by default does not print the comments and you can enable this feature using the Page Setup option.

Let us added the following comment for a cell in Excel Worksheet.

Now when you navigate to Print Preview option (File –> Print), Excel will not show the added comments. Click the Page Setup option available under Print Preview Settings page.

In the Page Setup Window, click the Sheet tab and navigate to Print section. For comments drop down, choose “At end of sheet” or “As displayed on sheet” for Comments. Let us go with “At end of sheet”, click Ok button to confirm and save the changes.

Now the print preview screen will display the comments at the end of sheet and the same will get printed while printing the worksheet.

Unhide comment in Excel 2013 and Excel 2010

If you are not able see the comments in worksheet then you can try to use the unhide option available as part of the Excel Advanced Options.

Click the File menu and then the Options link.
In the Excel Option window, navigate to Advanced Options.
Scroll down to display section and For cells with comments radio option select your preferred choice i.e either Indicators only, and comments on hover or Comments and indicators.

Click Ok to save and confirm the changes.

Also See: How to Insert, Delete, Customize Comments in Excel 2010

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.

Customize Comment

A typical comment box in Excel is as shown below.

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.

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.

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

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.

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.

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