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.
Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.