• Skip to main content
  • Skip to primary sidebar

Excel Tips and Tricks

  • About
  • Privacy Policy

How to unhide comments in Excel

July 25, 2015 by Ravi 1 Comment

Excel 2013 and Excel 2010 generally shows comments in worksheet with the Indicator as shown below.

image

And when you hover over the indicator it will display the added comments.

image

But in case if you are not able see the comments added to your worksheet then try the unhide option available as part of the

  1. Click the File menu and then the Options link
  2. In the Excel Option window, navigate to Advanced Options
  3. 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.
    4. Click Ok to save and confirm the changes.

image

Filed Under: Excel, Excel 2010, Office 2010 Tagged With: comments, Excel 2010, indicator, unhide comments

Reader Interactions

Comments

  1. Md.Shakil Ahmed says

    August 9, 2011 at 11:05 pm

    Thanx for help

    Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Recent Posts

  • How to increase number of worksheets Excel
  • A trick to flip a column upside down in Excel
  • Prevent users from adding new worksheet in Excel
  • Repeat action keyboard shortcut in Microsoft Office
  • How to import text file in Excel

Copyright 2020 © getexceltips.com