Excel: Hide rows - this is how quickly it disappears

Excel, along with Word, is probably one of the most popular Office applications. The nimble spreadsheet program lets you perform calculations, create tables, and even do your taxes. However, if you have a row that you don't need at the moment, you can hide it.

How to hide a row in Excel

In Excel, rows can not only be hidden, but also grouped and collapsed. This way, they will no longer be displayed, but they will still be highlighted when you multiselect over them. Hidden rows will no longer be highlighted if you select the rows around them.

1. Select the row number on the left side of the document.
2. Right-click on the selected row and select "Hide". For older Excel versions or online, the button is called "Hide Row".
3. The row should now disappear. Only the number below and above it will be displayed. Next to the numbers are now small, black arrows that indicate that there is a hidden row between the two lines.
4. You can also hide several rows at once. To do this, select all the line numbers by clicking on the top line, then holding down Shift and clicking on the bottom line. Now several lines should be selected and you can hide them again with a right-click.
5. If you do not want to hide the lines anymore, you can show them again by clicking on one of the black arrows above or below.