BookmarkPrint
Contents
Home > Microsoft Office > Excel > Unhide All Rows - Excel


Unhide All Rows - Excel
Larger Excel documents sometimes hide rows or columns in order to display a wider range of data. To redisplay hidden rows or columns follow the instructions below. This article shows Excel 2016, but this process also works in Excel 2013.

Quick links to sections in this article:
Rows  
Columns

Rows

Step 1:In an Excel document, click the select all button. It can be found above the rows and to the left of the columns.


Step 2:The entire worksheet is now selected.
Step 3: Right-click on any row number and choose Unhide.


Be careful not to click a cell in the row, only a cell number.

Columns

Step 1:Follow the first two steps above.Step 2:When you reach Step 3, select a column letter rather than a row number.

Related Articles


helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=unhide_all_rows