Excel: Hide all rows - here's how

You can easily hide and unhide multiple cells, rows and columns within Excel to get a better overview. The hidden rows are indicated in the table by a small marker, but are graphically no longer present and can thus provide more order.

Excel: Hide individual rows

In order to show various rows again, they must of course be hidden beforehand. This works similarly simple and is done in a few clicks.

1. First open the table in which you want to hide individual areas.
2. Now mark the individual columns, rows or cells and make a right click on the selected area.
3. From the context menu, you can use the option "Hide" at the very bottom, so that the area is no longer visible.
4. You now get to see a kind of bookmark at the top left position in the table of the hidden area, so that you can find the hidden place again.

Excel: Show hidden rows again

If you now want to use the initially hidden area again, it's no problem.

1. Mark the area before and after the marker for the hidden cells and right-click again
2. In the context menu, you will now find the "Show" option, making all hidden content visible again.
3. Alternatively, you can simply click on the bookmark itself. This is harder to hit, but does the unhiding in a single step.