Thread: Unhide rows

Hi there,

I have an Excel file (2007) from which some rows are hidden. I tried to unhide them using normal ways, like highlight them right-click unhide, nothing happens. I can unhide them manually by move mouse to the cell between hidden and unhidden ones and open the hidden ones but I got hundreds of them ... plz help. Thanks in advance.

Maybe rather than being hidden, the row height was set to zero on these rows. If so, highlight the range of rows, then right click to get the floating menu, click row height and set to 15 or a number that is consisent with the row height of other rows in your spreadsheet, then click OK.

I am not sure if they are on filter, (possible. but the total row number are different) or because of the height setting but I tried Ctrl_9 to hide them and then Ctrl_Shift_9 to unhide them, bingo, I got them all. Thanks for the help.