Scroll all the way to the right of the sheet (for columns) or to the bottom (for rows). Press and hold Shift on the keyboard, then select the first cell in the column (letter) or row (number) to ...

How to Unhide Columns or Rows in Excel Unhiding rows and columns in Excel is just as simple as hiding them. Depending on whether you want to unhide specific rows or columns, or all of them at once.