How to Unhide a Row in an Excel Spreadsheet

Make hidden rows visible again.

Excel spreadsheets can get quite large, so Excel provides the option to hide rows and columns that you may not need at the moment. This makes it easier for you to analyze the more important data on the spreadsheet. However, you may need to review this hidden data at a later date. In order to do this, you must "unhide" the hidden rows.

Instructions

1. Click on "Edit," and select "Go To" from the drop-down menu.

2. Enter the letter "A," followed by the number of the row that you want to unhide in the "Go To" window. For example, if you want to unhide row 1, you would enter "A1." Click on "OK."

3. Click on "Format," "Row" and then select "Unhide." You will now see the row that was hidden.

References

• Microsoft Office Excel 2007: Hide or Unhide Rows and Columns
• The Excel Addict: Unhide a Particular Column