I get a workbook from a colleague at work once a week. For some reason this time, when I go to search for the names, they don't pop up. There should be 10,393 rows, which it actually says there are, but I can only see 187 Rows. There are so many rows hidden in between each cell and for some reason, the only way I can see them is if I manually click and drag on each cell manually. For everything good and holy, I do not want to do this 10,000 times... literally. I have already tried selecting everything (ctrl + A), clicking unhide, or reformating everything to a 15 height. Neither of these worked. The only way I can see a cell is if I MANUALLY click and drag the height of a cell from 0 to 15. I need to get this report out by noon. Does anyone know of anything that can help me? I am happy to provide any information I can, but this is a work document containing information that is best off not shared. Thanks in advance!
Edit: This was actually a simple fix. The person who edited the document last left a filter on the sheet, which was messing with the formatting and not allowing me to unhide rows.
Bookmarks