How to Hide Comments in Excel: 4 Quick Methods

Method 1 – Deselecting Show Comments Button to Hide Comments in Excel Worksheet

Steps:

  • Navigate to the Review tab, click Show Comments.

How to Hide Comments in Excel by Deselect Show Comments

  • A comments tray appears on the right side which shows all the comments present in the worksheet.

Using Deselect Show Comments

  • Click the Show Comments button to deselect it hiding the comments.

How to Hide Comments in Excel by Deselect Show Comments


Method 2 – Using Keyboard Shortcuts for Hiding Comments in Excel

Steps:

  • Press the ALT key on your keyboard; this changes the appearance of Excel.
  • Press R on your keyboard to go to the Review tab.

Using Keyboard Shortcuts

  • Click H followed by the number 1 to display the comments on the righthand side.

Using Keyboard Shortcuts

  • Repeat the same sequence from the start, that is to say, press the ALT key, click R followed by H, and 1.

How to Hide Comments in Excel with Keyboard Shortcuts

  • The comments hide from view.

How to Hide Comments in Excel with Keyboard Shortcuts


Method 3 – Hiding All Comments Through Excel Options

Step 01: Go to the Options Menu

  • Locate the File tab and enter it.

Using Excel Options

  • Click the Options tab to open a new window.

Using Excel Options

Step 02: Select the Correct Option

  • Press the Advanced tab and scroll down to the Display section, where you have to check the following boxes shown in numbered steps.

How to Hide Comments in Excel with Excel Options

  • Click OK to close the window and return to your spreadsheet where you’ll find all the comments are now invisible.

How to Hide Comments in Excel with Excel Options


Method 4 – Applying Excel VBA Code to Hide Comments

Step 01: Launch the VBA Editor

  • Go to the Developer tab and the Visual Basic.

Using VBA Code

  • Insert a Module in your Workbook, the Module is where you’ll enter the VBA code.

Using VBA Code

Step 02: Insert the Module and the VBA Code

  • Insert code you need to right-click on the Module and click View Code, a window appears on the right.

How to Hide Comments in Excel Using VBA Code

  • Copy and paste this VBA code into this window.
Sub HideAllComments()
'This code enables you to hide all comments'
Application.DisplayCommentIndicator = xlNoIndicator
End Sub

How to Hide Comments in Excel Using VBA Code

Step 03: Run the Macro

  • Navigate to Run and click it.

How to Hide Comments in Excel Using VBA Code

  • A Macros dialog box appears where you must press Run to run the macro.

How to Hide Comments in Excel Using VBA Code

  • The comments hide from plain sight.

How to Hide Comments in Excel Using VBA Code


How to Use Resolve Thread Option Instead of Hiding Comments in Excel

Steps:

  • Enter the Review tab and find Show Comments.

Using Resolve Thread

  • On the right side, the comments tray can be seen.
  • Click the three dots on a comment and select Resolve Thread.

How to Hide Comments in Excel with Resolve Thread

  • The comment can be seen grayed out and marked Resolved in the comments tray.

How to Hide Comments in Excel with Resolve Thread


Things to Remember

  • The Comments section in Excel 365 has been redesigned.
  • In older versions of Excel, comments could be hidden by right-clicking the mouse on the cell and choosing the Hide Comments option. However, new versions no longer offer this feature.
  • In addition, the Hide All Comments button in the Review tab has also been removed in the latest edition of Excel.

Download Practice Workbook


How to Hide Comments in Excel: Knowledge Hub


<< Go Back to Comments in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Eshrak Kader
Eshrak Kader

Eshrak Kader is a dedicated professional with a BSc. Degree in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology. He boasts a rich background in Microsoft Office Suite, and over the past year, he has authored over 120 insightful articles for the ExcelDemy. Currently, Eshrak leads a team of 5 in the ExcelDemy Video project and enjoys problem-solving and making videos on Excel. Eshrak’s passion for continuous learning underscores his commitment to excellence in... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo