| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to filter cells where are comments... | Excel Discussion (Misc queries) | |||
| Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
| SHow comments on an advance filter | Excel Discussion (Misc queries) | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
| how can we copy cells comments text and paste to cells | Excel Discussion (Misc queries) | |||
Linear Mode
