Searching cells in Excel with comments in them?

Question

I have a huge Excel document which has some comments in some places I am not able to make out. Is there some way i can apply filter on the top most row to filter-in all the cells that contain comments ?
Or is there a macro for this ?

Answer 1

Yes
It is a macro to do it
Excel has no such feature to filter cells with comments, instead, you can:
1- go to Edit > Go To > Special > Comments > Ok
then copy these cells and paste it in another sheet
2- go to Tools > Options > View > Comments > Comment and Indicator > ok
This will show all comments
3- do a macro to do it

Enjoy my profile, I am the VBAXLMan

Answer 2

Try this to make all the comments visible

Sub ShowAllComments()
Dim cell
On Error Resume Next
For Each cell In Selection.Cells
cell.Comment.Visible = True
Next
End Sub