How to Read Full Comment in Excel (6 Handy Methods)

If you are searching for how to read full comment in Excel, this article is for you. Here, we will walk you through 6 effective methods to do the task smoothly.

Download Practice Workbook


6 Methods to Read Full Comment in Excel

The following table contains the Name, Subject, and Marks columns. This table has comments and notes in several cells. We will use 6 methods to read full comment of this table. Here, we used Excel 365. You can use any available Excel version.

How to Read Full Comment in Excel


1. Using Review Tab to Read Full Comment in Excel

This is a very quick and effective method to read full comment and notes in Excel.

Steps:

  • First, we will go to the Review tab >> select the Show Comments option.

Now, we can see the comments at the right of the Excel sheet. We can see every comment includes a cell number, that is the cell where the comment belongs.

How to Read Full Comment in Excel

Next, we want to read all the notes in Excel.

  • First, we will go to the Review tab >> select Notes >> select Show All Notes.

Finally, we can see all the notes in the Excel sheet.

How to Read Full Comment in Excel

Read More: How to Find Comments in Excel (4 Easy Methods)


2. Use of Data Validation Feature to Read Full Comment in Excel

Here, we have a dataset that is expanded to column 38. The C4 and D4 column header of the dataset contains a comment and note respectively. In this dataset, we will apply Freeze Panes to freeze the column header, and after that, we will apply Data Validation to read full comment.

Steps:

  • First, we will follow the steps of Methods-1 to view the comments and notes in the dataset.

  • After that, select row 5 >> go to the View tab >> select Freeze Panes.

Now, the column header has been frozen.

  • After that, if we hover our mouse down, we will see the full comment, however, we will not see the full note of cell D4.

To see the full note, we will use the Data Validation feature.

How to Read Full Comment in Excel

  • Afterward, we will select cell D4>> go to the Data tab > select Data Tools >> select Data Validation option >> select Data Validation.

A Data Validation dialog box will appear.

  • After that, select Input Message.
  • Then, in the Input Message box, write the content that is in the note of cell D4.

You can also copy the note content from the note of cell D4 before freezing the column header, and paste it into the Input Message box.

  • Afterward, click OK.

  • After that, when we drag down the mouse, we have to click on cell D4 to see the full note.

Finally, we can see the full note.

How to Read Full Comment in Excel


Similar Readings


3. Employing Go To Special Feature

This is a very effective method to highlight the cells with notes in Excel. However, in Excel 365 we can only highlight the cells with notes by using the Go To Special Feature. If you have any lower Excel versions, like Excel 2013 or Excel 2016, you can highlight the cells with comments only.

Steps:

  • First, we will go to the Data tab >> select the Editing option.
  • After that, we will select Find & Select >> select Go To Special.

A Go To Special dialog box will appear.

  • Then, select Notes >> click OK.

Now, we can see that cells B12 and D10 get highlighted as they have notes.

  • After that, we will hover our mouse on the highlighted cells, and we will see the notes.

Here, we hover our mouse on cell D10, and we can see the note.

How to Read Full Comment in Excel

Read More: Creating and Editing Excel Comments to Cells – [An Ultimate Guide]!


4. Use of Excel Options to Read Full Comment in Excel

Here, we will use the Advanced Excel option to read full comment in Excel.

Steps:

  • First, we will go to the File tab.

  • Afterward, we will select Options.

An Excel Options window will appear.

  • Then, we will select Advanced >> we will hover our mouse down unless we find the Display option.
  • After that, we will mark Indicators and notes, and comments on hover >> click OK.

Now, we can see the notes in the Excel sheet.

Next, we will hover our mouse on the cells that have comments.

  • After that, we hover our mouse on cell C12, and we can read full comment.

How to Read Full Comment in Excel


Similar Readings


5. Printing Comments to Read Full Comment/Notes in Excel

Printing comments is a great way to read full comment in Excel.

Steps:

  • First, we will go to the Page Layout tab >> select Page Setup, which is at the right bottom corner and marked with a red color box.

A Page Setup dialog box will appear.

  • Afterward, we will select Sheet >> in the Comments and notes box we will select At end of sheet.
  • Then, click on Print Preview.

Finally, in page 2 of the Print Preview, we can see all the comments.

Now, we can print the page to read full comment in Excel.

How to Read Full Comment in Excel

Read More: How to Print Worksheet with Comments in Excel (5 Easy Ways)


6. Applying Format Comment Option

In many cases, the comments or notes format is set in a way that is difficult to read. In that case, we can apply the Format Comment option to make the comments and notes more readable.

Excel 365 is an updated Excel version, therefore, we can apply the Format Comment in the notes only. If you have any lower Excel versions, like Excel 2013 or Excel 2016, you can apply the Format Comment in the comments only.

Here, we’ll apply the Format Comment option to format the note of cell B12.

Steps:

  • First, we will follow the steps from Method-1 to make the notes visible.

  • Afterward, we will select the entire note content and right-click.
  • After that, we will select Format Comment from the Context Menu.

A Format Comment window will appear.

  • After that, we selected Font as Calibri >> Font Style as Bold >> Size as 14 >> Color as Red.

Next, we will see the Preview.

  • After that, click OK

Finally, we can see that the note is now more readable.

How to Read Full Comment in Excel


Conclusion

Here, we tried to show you 6 methods to read full comment in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section. Please visit our website Exceldemy to explore more.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo