Forum Discussion
Hidden Rows in Excel Spreadsheet
I have a spreadsheet and somehow a lot of the rows have become minimized or hidden. I can manually go in and click and resize the rows individually but I need to be able to resize or unhide all rows...
Eric Reynolds click the entire row below the rows that are hidden. Then hold shift+up arrow to select the rows that are hidden, example row 4 is not hidden, but rows 1-3 are hidden, select row 4 to highlight the entire row, then use the shift+up arrow to select 3-1. After the selection is made click Format>Hide&Unhide>Hide Rows, which will now hide row 4 in the example. Then immediately click Format>Hide&Unhide>Unhide Rows, which will now unhide row 4 as well as rows 1-3. I hope this helps.