If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|