Vorlage:Video-Excel Gestaltung Bereiche-XY-Bereiche-English

The explanation of the individual steps in detail

How to hide individual rows and columns in your Excel spreadsheet:

1. Write an “x” to the left of the rows that are to be hidden. Write a “y” above the corresponding columns.

2. Select the table in which the rows/columns are to be hidden.

3. In the tab “*Design” in the group “Ranges” click on the button “X/Y areas”.

4. Select the option “Rows” in the drop-down under “Hide”. The rows marked with “x” are hidden.

5. To hide the columns marked with “y”, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”.

6. Select the option “Columns” in the drop-down under “Hide”. The columns marked with “y” are hidden.

7. To show the hidden rows and columns again, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”.

8. Select the option “Rows and columns” in the drop-down under “Show”. The rows marked with “x” and the columns marked with “y” are shown again.