Informative spreadsheets often contain a large amount of data that you can use to answer related questions. But not every situation will require all of the data contained in that spreadsheet, so you may need to remove some unnecessary rows.
But deleting rows from your spreadsheet may not be appealing if you need that information later, so you may need a different alternative. Fortunately you can hide rows in an Excel spreadsheet, even if you need to hide multiple separate rows.
If you would like to see your rows after hiding them in the steps below, then follow these steps to quickly unhide all of the hidden rows in your spreadsheet.
Below is how you can hide multiple rows at once in an Excel 2013 worksheet –
- Open the worksheet in Excel 2013.
- Hold down the Ctrl key on your keyboard, then click each row number that you wish to hide.
- Right-click one of the selected row numbers, then click the Hide option.
These steps are also repeated below with pictures –
Step 1: Open your spreadsheet.
Step 2: Hold the Ctrl key on your keyboard, then click each row number that you wish to hide. Row numbers are displayed at the left side of the spreadsheet, as identified in the image below.
Step 3: Right-click one of the selected row numbers, then click the Hide option.
If you wish to hide a group of contiguous rows, then you can do so by clicking the top row number in the group, holding the Shift key, then clicking the bottom row in the group. You can then right-click one of the selected row numbers and select the Hide option as well.
You can also hide a selection by clicking the Format button in the Cells section of the Home ribbon, click Hide & Unhide, then click the Hide Rows option.
Do you know that you can also choose to print only a selection of rows from your spreadsheet as well? This can be a great way to reduce the amount of ink and paper that you use, while highlighting the most important information in your spreadsheet.
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.