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.
Step 3: Right-click the selected row number, then click the Hide option.
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.
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.
Matthew Burleigh has been writing tech tutorials since 2008. His writing has appeared on dozens of different websites and been read over 50 million times.
After receiving his Bachelor’s and Master’s degrees in Computer Science he spent several years working in IT management for small businesses. However, he now works full time writing content online and creating websites.
His main writing topics include iPhones, Microsoft Office, Google Apps, Android, and Photoshop, but he has also written about many other tech topics as well.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.