How to Show Hidden Rows in Excel: A Step-by-Step Guide

  • Home
  • / How to Show Hidden Rows in Excel: A Step-by-Step Guide

Microsoft Excel is a powerful spreadsheet application that allows users to organize, analyze, and visualize data. One of the features that Excel offers is the ability to hide rows or columns to make the spreadsheet more visually appealing and easier to work with. However, there may come a time when you need to reveal these hidden rows for various reasons, such as data verification, analysis, or editing. In this article, we’ll walk you through a step-by-step process on how to show hidden rows in Excel.

Step 1: Open your Excel Spreadsheet

Begin by opening the Excel spreadsheet from which you want to reveal hidden rows. If you haven’t already, launch Excel and select the file you wish to work on.

Step 2: Identify Hidden Rows                  

Before you can show hidden rows, you need to identify which rows are hidden. In Excel, hidden rows are not deleted or removed but are simply made invisible. To check for hidden rows, you can do the following:

  • Manually scroll through the spreadsheet: If you have a small dataset or a good idea of where the hidden rows are, you can scroll through the spreadsheet and visually identify any gaps in row numbers.
  • Use the Find & Select Feature: You can also use Excel’s Find & Select feature to locate hidden rows. To do this, press Ctrl + F to open the Find and Replace dialog box, go to the ‘Options’ button, and choose ‘Format.’ Under ‘Format,’ select ‘Row Height.’ Here, you can specify a row height that is typical for hidden rows. Excel will then find and select all rows with that specific row height, which are most likely the hidden rows.

Step 3: Highlight the Hidden Rows

Once you’ve identified the hidden rows, you can highlight them. To do this, click and drag your cursor over the row numbers of the hidden rows. This will select and highlight those rows.

Step 4: Right-Click and Unhide

With the hidden rows selected, right-click on any of the highlighted row numbers. A context menu will appear. From the menu, select ‘Unhide.’

Step 5: Hidden Rows are Revealed

Once you click ‘Unhide,’ Excel will reveal the hidden rows, and they will become visible within your spreadsheet. You should now be able to see the data that was previously hidden.

Additional Tips:

  • Unhiding Multiple Rows: If you need to unhide multiple sets of hidden rows, you can repeat the process above for each set. Simply select the hidden rows, right-click, and choose ‘Unhide’ for each group of hidden rows.
  • Unhiding Columns: The process for unhiding columns is similar to that of rows. Instead of row numbers, you’ll select column letters, right-click, and choose ‘Unhide’ to reveal hidden columns.
  • Custom Row Heights: In some cases, row heights may have been customized, making it challenging to identify hidden rows by their row height. If this is the case, you may need to use the ‘Custom Heights’ feature, which allows you to specify custom row heights for multiple rows. You can access this feature by selecting the rows you want to unhide, right-clicking, and choosing ‘Row Height’ from the context menu. Then, enter the desired row height, and click ‘OK’ to unhide the selected rows.
  • Protecting Hidden Rows: If you want to prevent others from accidentally unhiding rows in your spreadsheet, you can protect the worksheet. To do this, go to the ‘Review’ tab and click ‘Protect Sheet.’ You can then set a password to prevent unauthorized changes. However, be sure to remember the password if you choose this option, as it will be required to unprotect the sheet in the future.
  • Grouping Rows: Excel also provides a feature called ‘Grouping,’ which allows you to collapse and expand rows for better organization. Rows can be grouped and hidden by using the Group feature, and this is different from simply hiding rows. To show grouped rows, you can click the plus or minus sign that appears beside the group symbol. This will expand or collapse the grouped rows.


Hiding and unhiding rows in Excel is a simple but valuable feature that helps users manage and present data more effectively. Whether you’re working with a large dataset or simply want to clean up your spreadsheet, knowing how to show hidden rows can be a time-saving and organizational tool.

Remember, hidden rows are not permanently removed but rather temporarily made invisible. So, if you ever need to access or work with data in these rows, follow the step-by-step guide outlined in this article, and you’ll have those hidden rows revealed in no time.

Excel offers a wide range of powerful features, and learning how to use them effectively can significantly enhance your productivity and data management skills. The ability to hide and show rows is just one of many tools at your disposal in this versatile software, so be sure to explore and master other features to become an Excel pro. With practice, you’ll be able to manipulate and present your data in a way that best suits your needs.

Write your comment Here