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

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen


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.