How to Show Hidden Cells in Excel 2013

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

Now that you know how to view hidden cells in Microsoft Excel, you can use this option to toggle the display of those cells as needed.

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