Forum Discussion
Unable to show rows in excel
I'm working on a spreadsheet with a large number of rows. I hid rows 23-117 to work more efficiently arranging the data. Now I can't get these rows to unhide. I have tried highlighting the cells, ...
Select row 22 by clicking on its row number.
Hold down Shift while clicking on the row number of row 118, to select all rows from 22 to 118.
On the Home tab ribbon, in the Cells group, select Format > Hide & Unhide > Unhide Rows.
Alternatively, right-click anywhere in the selection and select Unhide from the context menu.