How to Unhide All Rows and Columns in Microsoft Excel

PDF download Download Article
Find missing Excel rows and resize them easily
PDF download Download Article

Are there hidden rows or columns in your Excel worksheet that you want to bring back into view? Unhiding them is easy, and you can even unhide all at once. This wikiHow article will show you how to unhide rows and columns in Microsoft Excel using your Windows or Mac computer.

Unhiding All Rows and Columns in Excel

To unhide all columns or rows in Microsoft Excel, click the triangle button to Select All. Click Home > Format > Hide & Unhide > Unhide Rows and/or Unhide Columns .

Method 1
Method 1 of 3:

Unhiding a Specific Row or Column

PDF download Download Article
  1. Watermark wikiHow to Unhide Rows in Excel
    Look at the row numbers on the left side of the document (or columns at the top). If you see a skip in numbers (e.g., row 4 is directly above row 6 ), the row in between the numbers is hidden . [1]
    • You should also see a double line between the two row or column numbers.
    • Keep in mind this will only work on unlocked cells. If the cells are locked, select all the locked cells and right-click them. Click Format Cells > Protection tab > uncheck Locked > OK .
  2. Watermark wikiHow to Unhide Rows in Excel
    Doing so prompts a drop-down menu to appear.
    • For example, if row 5 is hidden, you would right-click the space between 4 and 6 .
    • On a Mac, you can hold down Control while clicking this space to open the drop-down menu.
    Advertisement
  3. Watermark wikiHow to Unhide Rows in Excel
    It's in the drop-down menu. The hidden row or column will appear again.
    • You can save your changes by pressing Ctrl + S (Windows) or Command + S (Mac).
  4. Watermark wikiHow to Unhide Rows in Excel
    If you notice that several rows or columns are missing, you can unhide all of them by doing the following:
    • Hold down Ctrl (Windows) or Command (Mac) while clicking the row number above the hidden rows and the row number below the hidden rows. For columns, select the column on the left and on the right of the hidden column.
    • Right-click one of the selected numbers.
    • Click Unhide in the drop-down menu.
    5. Advertisement
Method 2
Method 2 of 3:

Unhiding All Hidden Rows or Columns

PDF download Download Article
  1. Watermark wikiHow to Unhide Rows in Excel
    This triangular button is in the upper-left corner of the spreadsheet, just above the 1 row and just left of the A column heading. Doing so selects your entire Excel document.
    • You can also click any cell in the document and then press Ctrl + A (Windows) or Command + A (Mac) to select the whole document.
    • Keep in mind this will only work on unlocked cells. If the cells are locked, select all the locked cells and right-click them. Click Format Cells > Protection tab > uncheck Locked > OK .
  2. This tab is just below the green ribbon at the top of the Excel window.
    • If you're already on the Home tab, skip this step.
  3. This option is in the "Cells" section of the toolbar near the top-right of the Excel window. A drop-down menu will appear.
  4. Watermark wikiHow to Unhide Rows in Excel
    You'll find this option in the Format drop-down menu. Selecting it prompts a pop-out menu to appear.</ref>
  5. Watermark wikiHow to Unhide Rows in Excel
    It's in the pop-out menu. Doing so immediately causes any hidden rows or columns to appear in the spreadsheet.
    • You can save your changes by pressing Ctrl + S (Windows) or Command + S (Mac).
    6. Advertisement
Method 3
Method 3 of 3:

Adjusting Row Height

PDF download Download Article
  1. Watermark wikiHow to Unhide Rows in Excel
    This triangular button is in the upper-left corner of the spreadsheet, just above the 1 row and just left of the A column heading. Doing so selects your entire Excel document.
    • One form of hiding rows involves the height of the row(s) in question to be so short that the row effectively disappears. Use this method to reset the height of all spreadsheet rows to "14.4" (the default height) to address this.
  2. Watermark wikiHow to Unhide Rows in Excel
    This tab is just below the green ribbon at the top of the Excel window. [2]
    • If you're already on the Home tab, skip this step.
  3. This option is in the "Cells" section of the toolbar near the top-right of the Excel window. A drop-down menu will appear.
  4. It's in the drop-down menu. This will open a pop-up window with a blank text field in it.
  5. Type 14.4 into the pop-up window's text field.
  6. Doing so will apply your changes to all rows in the spreadsheet, thus unhiding any rows which were "hidden" via their height properties.
    • You can save your changes by pressing Ctrl + S (Windows) or Command + S (Mac).
    7. Advertisement

Community Q&A

Search
Add New Question
  • Question
    The top 7 rows of my Excel worksheet have disappeared. I've tried to "unhide" from the Format menu, but nothing happens. What do I do?
    Community Answer
    You'll have to unlock the cells (via the format pop-up), then hide them all before unhiding them.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 18 Helpful 53
  • Question
    I have the same problem - top 7 rows aren't displaying. I tried to unlock but they weren't locked and the spreadsheet isn't protected. I can see the top 7 rows only in print preview.
    Anuj_Kumar1
    Community Answer
    There is a possibility you did not hide the rows but reduced your rows' height to minimum. Select all rows above and below of your 7 rows and increase rows height from format menu. It will re-adjust the height of rows and your rows will be visible.
    Thanks! We're glad this was helpful.
    Thank you for your feedback.
    If wikiHow has helped you, please consider a small contribution to support us in helping more readers like you. We’re committed to providing the world with free how-to resources, and even $1 helps us in our mission. Support wikiHow
    Yes No
    Not Helpful 20 Helpful 7
Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      • If you don't see Unhide Columns or Unhide Rows pop up, make sure you're right-clicking inside the column or row label.
        Thanks
        Helpful 0 Not Helpful 0

      Tips from our Readers

      The advice in this section is based on the lived experiences of wikiHow readers like you. If you have a helpful tip you’d like to share on wikiHow, please submit it in the field below.
      • If a column is filtered to hide rows, you have to remove that filter first. Otherwise you won't be able to unhide the rows in that column.
      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!
      Advertisement

      Video

      Read Video Transcript

      You Might Also Like

      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      How to
      Link Sheets in Excel
      The Best Ways to Make & Format Lists in Excel
      Advertisement

      References

      1. ↑ https://support.office.com/en-us/article/hide-or-show-rows-or-columns-659c2cad-802e-44ee-a614-dde8443579f8
      2. ↑ https://support.microsoft.com/en-gb/office/change-the-column-width-and-row-height-72f5e3cc-994d-43e8-ae58-9774a0905f46

      About This Article

      Article Summary X

      1. Open your spreadsheet in Microsoft Excel.
      2. Select all data in the worksheet. A quick way to do this is to click the ""Select all"" button at the top-left corner of the worksheet.
      3. Click the ""Home"" tab.
      4. Click the ""Format"" button in the ""Cells"" section of the toolbar. A menu will expand.
      5. Select ""Hide & Unhide"" on the menu.
      6. Click ""Unhide rows"" to make all hidden rows visible.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 748,568 times.

      Is this article up to date?

      Advertisement