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

  • Thread starter Thread starter Dani
  • Start date Start date
D

Dani

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.
 
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 Tab>Show all Comments
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter to filter out non-numeric rows 3
Filter 1
EXCEL FILTERS AND CHARTS 2
Check to see if Autofilter is Engaged 7
EXCEL FILTER OF COMMENT CONTENT 6
I can only delete an entire row not a cell in excel 2013? 1
Dynamic Filtering 2
SUBTOTAL not refreshing when using advanced filter 2

Back
Top