Skip to content

How to Unhide All Rows in Excel

    Inserting, removing, hiding, and unhiding rows or columns are all useful functions in Excel spreadsheets. Hide rows in Excel reduces the quantity of data or blank rows on your screen, allowing you to concentrate on the data you need to work with. Knowing how to unhide all rows in Excel is essential to keep track of your data and accessing it when necessary. We’ll go through why you need to unhide all rows in Excel and how to do so in different ways, how to unhide particular rows, and unhide top rows, in this particular article.

    Why Should We Unhide all Rows in Excel?

    When working in groups, you can update, share, and double-check data by sending Excel files to one another. Your teammates may have unhidden rows to optimize their view of the data by hiding unnecessary rows, calculations, or information that could make the file less readable while they were working on it. Hidden rows can be found by inspecting the space between rows for small blank segments or using Excel’s various tools. You can get the data you need to finish your project by unhiding the hidden rows.

    4 Methods Ways to Unhide All Rows in Excel

    Select all rows in a spreadsheet before starting to unhide all hidden rows. You have two options here:

    One thing to keep in mind is that this shortcut in Microsoft Excel behaves differently depending on the situation. This shortcut will select the entire spreadsheet if you place the cursor in a blank cell. When the cursor is in one of the adjacent data-filled cells, however, it will only choose the dataset. Ctrl + A are the keys together to select the entire worksheet once again.

    Let’s learn the process to unhide all the rows using the ribbon. Perform the steps-discussed below:

    Total Time: 20 minutes

    Unhide All Rows Using Ribbon

    To choose all rows from the worksheet, first click the Select All button
    Go to the Cells group on the Home tab after you’ve selected all of the rows
    Now, select Format from the drop-down menu
    Then, select Hide & Unhide from the drop-down menu
    After that, select Unhide Rows from the drop-down menu
    Finally, it will unhide all of the rows in the Excel file.

    Unhide All Rows by Context Menu in Excel

    After right-clicking the mouse, you can also unhide all rows from the context menu. Unhiding all of the unhide rows or columns is very straightforward.
    To choose all rows from the worksheet, first click on the Select All button
    Using your mouse, do a right-click
    Now, select Unhide from the menu
    Finally, this procedure will unhide all of the Excel worksheet’s hidden rows.

    Unhide All Rows in Excel Using Keyboard Shortcut

    Using the keyboard shortcut is another effective approach to reveal all rows. This is a technique that is rarely used. However, I strongly advise you to learn and use this strategy as well. In the future, it will be useful.
    To choose all rows from the worksheet, first click on the Select All button
    Press Ctrl + Shift + 9 keys altogether at the same time once you’ve selected all rows
    The shortcut will then show all of the worksheet’s hidden rows.

    Unhide All Rows Using VBA Macros

    If you utilise VBA, you may now use VBA codes to unhide all of the unhidden rows. The main benefit of utilising VBA code is that it allows you to unhide all rows across the entire workbook. This implies you can see all hidden rows from all of your workbook’s worksheets.
    To access the VBA editor, press Alt + F11 on your keyboard
    After that, go to Insert >>> Module
    Type the following code to show all rows in a worksheet:
    Sub Display_all_hidden_rows()
    Rows.EntireRow.Hidden = False
    End Sub
    If you want to unhide all rows from numerous worksheets in your workbook, type the following code:
    Sub Display_all_rows_in_Workbook()
    Dim sheet As Worksheet
    For Each sheet In Worksheets
    Sheet.Rows.EntireRow.Hidden = False
    Next sheet
    End Sub
    Then, save the document
    Then, on your keyboard, click Alt + F8 to access the Macro dialogue box
    Select Show all hidden rows / Show all rows in Workbook next
    Then select the Run button
    Finally, these VBA codes will unhide all of the hidden rows in your Excel worksheet or workbook.

    ௹ How to Unhide Particular Rows in Excel?

    Here’s how to unhide all hidden rows in your Excel spreadsheet in the preceding sections. You won’t be able to unhide all of the rows at this time. However, you’d like to make some rows visible. All of the processes listed above can be completed by you. Let’s check out some basic methods.

    Show Hidden Rows by Double-Clicking

    ⇒ This is a very straightforward way. Let’s see how:

    Hover the mouse over the interaction of the rows once you’ve discovered the hidden rows
    A two-headed split arrow will appear
    That arrow must be double-clicked
    The unseen rows will then be unhidden
    This method has the advantage of not requiring you to highlight the rows
    All of them can be unhidden with a double click.

    Show Hidden Rows by Highlighting Rows

    ⇒ Another method for unhiding specific rows from a worksheet is to highlight them. This method is similar to the methods that are discussed above:

    To begin, select the rows on either side of the row you wish to unhide
    Then, using any of the methods discussed before, unhide the rows
    Make sure that read them first if you haven’t already
    To unhide rows, we’re utilising the context menu
    Make a right-click with your mouse
    The context menu will appear after done with the above steps
    Now, click on the Unhide button.

    ⇒ It will successfully unhide rows in the appropriate order. To unhide individual rows, use any of these methods.

    Unhide Top Rows in Excel

    Type “A1” in the Name Box and click Enter to unhide it
    Next, you’re supposed to select Cell A1
    Use any of the approaches that are discussed earlier during this time
    The keyboard shortcut is being used
    Press Ctrl + Shift + 9 keys once you’ve picked Cell A1
    It will bring that row back to the top of the list.

    For Free Consultation With QuickBooks Experts: Just Call or Chat with US

    See Also:

    QuickBooks Crashes When Exporting to Excel


    To sum up, we hope this article has given some useful information on how to unhide all rows in Excel. All of these procedures are suggested by Expertise. Also, feel free to connect with the Team of Experts via QuickBooks Helpdesk Team, if you still have any queries or concerns associated with unhiding rows in Microsoft Excel.

    $ FAQs $

    What are the Important Pointers We Need to Consider to Unhide all Rows in Excel?

    The below are few pointers must be taken into considerations to unhide all rows in Microsoft Excel:
    If you’re having problems unhiding the top rows or columns, select them altogether and use a keyboard shortcut to do it.
    If the row height is less than 0.08, you can use these methods to unhide them without having to alter the height.
    Using the Select All button, try to select the entire worksheet.

    Why Unhide all Rows Not Working in Excel?

    Unhiding the hidden rows in your Excel worksheet can be difficult at times. There could be three reasons for this.
    Your sheet is secure.
    The heights of the rows are too short.
    A few rows have been filtered out.

    How Do I Locate the Hidden Rows in Excel? 

    You must first discover all hidden rows in Excel before you can begin unhiding all rows. Following that, you can unhide all rows from the entire spreadsheet.

    Take a look at the following dataset:
    You can look for them on your own. However, if you have a large dataset, it may be difficult.

    To find all hidden rows in Excel, take these simple steps:-
    To begin, go to the Home page and select the Editing group
    After that, select Find & Select from the drop-down menu
    Now, select Go To Special from the drop-down menu
    Select Visible cells only from the Go To Special dialogue box
    Once done with that, click on the Ok tab
    Following that, you’ll notice that Excel has selected all of the cells
    Also, make a note of the rows that were adjacent to the rows not visible with a white border.

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    fifteen + 8 =