How to Unhide All Rows in Excel: A Step-by-Step Guide

Hiding rows in Excel can help you manage and view data more effectively, but what happens when you need to unhide those rows? It’s a straightforward process, and I’m here to guide you through it. After reading this quick overview, you’ll be well-equipped to unhide all rows in Excel with ease.

Step by Step Tutorial to Unhide All Rows in Excel

Before we dive into the steps, it’s important to understand what we’re about to do. Unhiding all rows in Excel will reveal any data that was previously hidden, ensuring that you have a complete view of your spreadsheet.

Step 1: Select the Entire Spreadsheet

Click the triangle icon at the top-left corner of your spreadsheet to select all cells.

Selecting the entire spreadsheet is the first step to ensure that no rows are left hidden. This triangle icon is located where the row numbers and column letters intersect.

Step 2: Right-click on Row Numbers

Right-click on any of the row numbers on the left-hand side of your spreadsheet.

After selecting the entire spreadsheet, you need to right-click on the row numbers to access the options for rows. This can be done on any row number as you have already selected all cells.

Step 3: Choose ‘Unhide’

From the right-click menu, choose ‘Unhide’.

When you click on ‘Unhide’, Excel will promptly display any rows that were previously hidden. This is a simple yet effective way to reveal all your data.

After completing these steps, all previously hidden rows in your spreadsheet will now be visible.

Tips for Unhiding Rows in Excel

  • If you’re having trouble unhiding rows, make sure you’ve selected the entire spreadsheet first.
  • Remember that unhiding rows will not affect any of your data—it simply makes it visible again.
  • Use the ‘Undo’ feature (Ctrl + Z) if you accidentally unhide rows you intended to keep hidden.
  • You can also use the ‘Go To’ feature (Ctrl + G) to quickly navigate to specific rows or cells that might be hidden.
  • Keep in mind that if you have a very large spreadsheet, it might take a few moments for all rows to appear after unhiding.

Frequently Asked Questions

Can I unhide specific rows in Excel, instead of all at once?

Yes, you can unhide specific rows by selecting the rows above and below the hidden rows, right-clicking, and choosing ‘Unhide’.

Will unhiding rows disrupt my spreadsheet’s formatting?

No, unhiding rows will not change your spreadsheet’s formatting or the data within it.

Is there a keyboard shortcut to unhide all rows in Excel?

While there isn’t a direct keyboard shortcut to unhide all rows, you can use the keyboard shortcut Ctrl + A to select all cells, then follow the rest of the steps.

What should I do if unhiding rows doesn’t work?

Make sure you’ve selected the entire spreadsheet; if it still doesn’t work, try saving your document, closing Excel, and reopening it.

Can I prevent rows from being hidden by accident in the future?

Yes, you can protect your sheet or workbook to prevent rows from being hidden without your permission.


  1. Select the entire spreadsheet by clicking the triangle icon at the top-left corner.
  2. Right-click on any of the row numbers.
  3. Choose ‘Unhide’ from the right-click menu.


Unhiding all rows in Excel is a task that can greatly improve your data management and analysis. By following the simple steps outlined above, you can ensure that no piece of data goes unnoticed in your spreadsheets. Whether you’re a seasoned Excel user or just getting started, these tips should help you navigate the software with greater ease. And remember, if you ever feel lost or unsure, Excel’s built-in help feature is always there to guide you. With your newfound knowledge on how to unhide all rows in Excel, you’re ready to tackle even the most comprehensive datasets with confidence.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time. Read our Privacy Policy