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

 

 

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

birthday t-shirts for boys
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.