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:


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.


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