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:

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

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

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

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

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

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

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

• 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.