How to Hide a Row in Excel 2010

Data overload can happen pretty easily in large Excel spreadsheets, especially when all of your cells contain data that looks similar. One way to help alleviate this problem is by making sure that you are only looking at the data that is relevant to your current task. There are several ways to do this, but the easiest one is to simply hide the rows that you don’t need right now. This doesn’t delete the data, it simply hides it from view so that you can concentrate on what is important. So continue reading below to learn how to hide a row in Excel 2010.


How to Hide a Row from View in Excel 2010

Note that this method is used only to hide the rows from view. They are still technically there, and any formulas that use data from the hidden row will still be calculated. The purpose of hiding rows is to filter down visible data so that you are only seeing what you need to see, but keeping the data accessible should you need to return it to view at a later point in time. With that in mind, follow the tutorial below to learn how to hide a row in Excel 2010.


Step 1: Open the spreadsheet containing the row that you want to hide.


Step 2: Click the row number at the left side of the window for the row that you want to hide.

how to hide a row in excel 2010



Step 3: Right-click the selected row number, then click the Hide option.

right-click the row to hide, then click hide



You will notice that the row numbers at the left side of the window will now skip the row that you just hid. You can unhide hidden rows by selecting the rows around the hidden row, then clicking the Unhide option.

select the surrounding rows, then click unhide



This same method will work for multiple rows, as well. Simply select the rows that you want to hide instead of selecting a single row, then perform the steps above.

Are you looking for a new laptop for your home or business? Amazon offers a number of popular models at great prices. Click here to see a list of the most popular laptops under $400.

We have also written about how to hide columns in Excel 2010, which is a very similar process. You can also hide row and column heading in Excel 2010, if you wish. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.