Afia Kona
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.
How to Read Full Comment in Excel: 6 Methods
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.
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:
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.
Next, we want to read all the notes in Excel.
Finally, we can see all the notes in the Excel sheet.
Read More: How to Find Comments in Excel
Similar Readings
- How to Add Comment in Excel Formula
- How to Insert Picture in Excel Comment
- Vlookup to Copy Comments in Excel
- How to Filter Cells with Comments in Excel
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.
- 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.
Read More: How to Add Floating Comment in Excel
Similar Readings
- How to Extract Comments in Excel
- [Fixed!] Comments in Excel Far Away from Cell
- How to Reference Comments in Excel
- How to Add Comment in Excel
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.
Read More: Creating and Editing Excel Comments to Cells
Similar Readings
- Anchoring Comment Boxes in Excel
- How to Reply to a Comment in Excel
- Difference Between Threaded Comments and Notes in Excel
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.
Read More: How to Make Flashcards in Excel
Similar Readings
- How to Copy Comments in Excel
- [Solved!] Comments Are Not Displaying Properly in Excel
- [Fixed!] Excel Comment Only Showing Arrow
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, on page 2 of the Print Preview, we can see all the comments.
Now, we can print the page to read full comment in Excel.
Read More: How to Remove Comments in Excel
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.
Similar Readings
Download Practice Workbook
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.
