How to Show Hidden Cells in Excel 2013

Last updated on May 2nd, 2023 at 11:56 pm

Excel workbook creators often hide rows or columns that contain irrelevant information, or information that is not important for the task that is currently being performed. This makes the spreadsheet easier to read and prevents mistakes that might occur due to misunderstandings.

But the cells contained in rows or columns might eventually be useful later, or they might contain information that is part of a formula and needs to be updated. In these scenarios, it is essential that the hidden cells be unhidden so that they can be modified. Fortunately you can follow a few simple steps to unhide all of the rows and columns in an Excel 2013 spreadsheet that have previously been hidden.


View All of the Hidden Cells in Microsoft Excel 2013

The steps in this tutorial will show you how to show all of the rows and columns in your Excel spreadsheet that are currently hidden. Individual cells cannot be hidden, so you will need to unhide the row or column that contained the hidden information that you need to view. You can read this article to learn how to selectively unhide just a single row or column instead. Otherwise, continue below.


Step 1: Open your spreadsheet in Excel 2013.


Step 2: Click the cell at the top-left corner of the spreadsheet.

select all of the cells



Step 3: Click the Home tab at the top of the window.

click the home tab



Step 4: Click the Format drop-down menu in the Cells section of the navigational ribbon.

click the format button



Step 5: Click the Hide & Unhide option, then click Unhide Rows.

unhide all of the rows



Step 6: Repeat steps 4 and 5, but click the Unhide Columns option instead.

unhide all of the columns



Are there rows or columns in your spreadsheet that you would like to hide? Read here and learn how.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy

Newest Guides