can you filter so that you only see cells that contain comments?
 

I want to see only the cells that have contents as I need to edit those
specific cells in the workbook. I tried Autofilter, haven't tried advanced
filter, because I don't want to copy it anywhere or lose any of the other
data.

can you filter so that you only see cells that contain comments?
 

This might work for you. Its not as though your filtering your data just to
show the cells that have comments. Its keeping all your data together and
displays all comments so that you can see what cells that actually have them.

To do this just highlight ur data then go to the Review TabShow all Comments

"Dani" wrote:

I want to see only the cells that have contents as I need to edit those
specific cells in the workbook. I tried Autofilter, haven't tried advanced
filter, because I don't want to copy it anywhere or lose any of the other
data.