How to Show All the Hidden Lines in an Excel Spreadsheet

Hiding rows or columns in a large Excel spreadsheet makes it much easier to read the content of the spreadsheet. You have the flexibility to view relevant columns right next to each other, hide irrelevant rows of data, or compare column B with column ZZ without scrolling. When you hide rows and columns, Excel's only visual reminder is a very slightly thicker dividing line between the surrounding rows or columns. As long as you know where columns or rows are hiding, you can select the surrounding rows or columns, right-click and choose "Unhide." Otherwise, unhide everything at once to be sure you are seeing every row and column in the spreadsheet.

Things You'll Need

• Computer
• Microsoft Office Excel software

Instructions

1. Open the Excel spreadsheet with hidden rows or columns.

2. Click on the rectangle above row 1 and to the left of column A. This selects every cell in the spreadsheet. Alternatively, press "Ctrl-A" on the keyboard to select all.

3. Right-click on any column header and choose "Unhide."

4. Right-click on any row number and choose "Unhide."

References

• Microsoft Office: Hide or Display Rows and Columns