Why isnt Excel showing all rows?

Just as you can quickly hide and unhide columns, you can hide or reveal hidden rows in your Excel spreadsheet as well.

In addition to freezing rows, you may find it helpful to conceal rows you are no longer using without permanently deleting the data from your spreadsheet. To later reveal the hidden cells, you can right-click to unhide individual rows.

You can also navigate to the "Format" option to unhide all hidden rows. This feature is especially helpful if you've hidden multiple rows throughout a large spreadsheet.

Here's how to do both.

Check out the products mentioned in this article:

Microsoft Office (From $139.99 at Best Buy)

MacBook Pro (From $1,299.99 at Best Buy)

Microsoft Surface Pro X (From $999 at Best Buy)

How to hide individual rows in Excel

1. Open Excel.

2. Select the row(s) you wish to hide. Select an entire row by clicking on its number on the left hand side of the spreadsheet. Select multiple rows by clicking on the row number, holding the "Shift" key on your Mac or PC keyboard, and selecting another.

3. Right-click anywhere in the selected row.

4. Click "Hide."

How to unhide rows in Excel

Right-click to hide rows.Marissa Perino/Business Insider

How to unhide individual rows in Excel

1. Highlight the row on either side of the row you wish to unhide.

2. Right-click anywhere within these selected rows.

3. Click "Unhide."

How to unhide rows in Excel

Highlight adjacent cells to unhide a hidden row.Marissa Perino/Business Insider

4. You can also manually click or drag to expand a hidden row. Hidden rows are indicated by a thicker border line. Move your cursor over this line until it turns into a double bar with arrows. Double click to reveal or click and drag to manually expand the hidden row or rows. (If you've hidden multiple rows, you may have to do this multiple times.)

How to unhide all rows in Excel

1. To unhide all hidden rows in Excel, navigate to the "Home" tab.

2. Click "Format," which is located towards the right hand side of the toolbar.

3. Navigate to the "Visibility" section. You'll find options to hide and unhide both rows and columns.

4. Hover over "Hide & Unhide."

5. Select "Unhide Rows" from the list. This will reveal all hidden rows, a feature especially helpful if you've hidden multiple rows throughout a large spreadsheet.

How to unhide rows in Excel

Unhide all rows.Marissa Perino/Business Insider

  • How to make a line graph in Microsoft Excel in 4 simple steps using data in your spreadsheet

  • How to add a column in Microsoft Excel in 2 different ways

  • How to hide and unhide columns in Excel to optimize your work in a spreadsheet

  • How to search for terms or values in an Excel spreadsheet, and use Find and Replace

Marissa Perino

Marissa Perino is a former editorial intern covering executive lifestyle. She previously worked at Cold Lips in London and Creative Nonfiction in Pittsburgh. She studied journalism and communications at the University of Pittsburgh, along with creative writing. Find her on Twitter: @mlperino.

Over the course of a long night, you prepared your spreadsheet. However, when you looked at it the next morning, you find that you cannot see several columns. Do not worry -- Excel did not spontaneously erase data from your spreadsheet. It just means that you accidentally used the "Hide" feature on the missing columns. Fortunately, you can use the "Unhide" command to make individual or all hidden columns visible again.

Individual Columns

  1. 1.

    Open your Excel spreadsheet.

  2. 2.

    Select both columns on either side of the hidden column. To select the columns, place your cursor in the first column, drag it into the second column while holding down the mouse button and then drag the cursor down the second row. This will select both the visible and hidden columns.

  3. 3.

    Click "Format" in the Cells group of the Home tab.

  4. 4.

    Select "Visibility" followed by "Hide & Unhide" and "Unhide Columns" to make the missing column visible.

  5. 5.

    Repeat for the other missing columns in the spreadsheet.

All Hidden Rows

  1. 1.

    Open your Excel spreadsheet.

  2. 2.

    Click the "Select All" button, which is the button in the top left corner of the spreadsheet. You can also click "Ctrl-A" to select the entire spreadsheet.

  3. 3.

    Click "Format" in the Cells group of the Home tab.

  4. 4.

    Select "Visibility," and then select "Hide & Unhide" and "Unhide Columns" to make all missing columns visible.

    Why is my Excel not showing all the rows?

    To unhide all rows and columns, select the whole sheet as explained above, and then press Ctrl + Shift + 9 to show hidden rows and Ctrl + Shift + 0 to show hidden columns.

    Why won't all my rows unhide in Excel?

    Go to the VIEW and FREEZE PANES buttons. If it says 'Unfreeze Panes' then this is the problem. Once you unfreeze them you will be able to scroll upwards and see the hidden rows.