Hopefully someone can help me with this problem that came up at work, when I recieved this Excel sheet via e-mail.
Its a list with about 400 rows by the look of it, but the maker of the sheet has somehow hidden most of the rows, so that I’m missing rows 5-164, 166-253, etc, leaving me with only 15 visible rows. So how do I chose to display the hidden rows?
I’ve tried selecting the entire sheet, and do format/row/unhide, but that did nothing.
Any ideas? Thanks!
(of course the guy who made the sheet is now on vacation, so I can’t ask him either) :mad:
Thanks a bunch, but considering I will not be sure I have really erased everything before i send it to you, I don’t think I can do that. The information is a bit sensitive, you see (not that I think you are untrustworthy, but you know how it is with computer security ).
It could be that there’s an active filter, with “Unique records only” enabled. On My version (2007) you get to that via Sort & Filter/Advanced… in the Data tab.
So, if you want to keep the filters but see everything, look for the filter arrow that is turned blue. Click on it and choose “all” and everything should show, assuming that is the only filter applied (blue).