Vorlage:Video-Excel Gestaltung Bereiche-XY-Bereiche-English: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „center|808px|border <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; over…“) |
Keine Bearbeitungszusammenfassung |
||
| Zeile 7: | Zeile 7: | ||
<p align="left"> How to hide individual rows and columns in your Excel spreadsheet: <br><br> | <p align="left"> How to hide individual rows and columns in your Excel spreadsheet: <br><br> | ||
<p align="left"> | <p align="left"> | ||
< | <ol> | ||
<li> <p align="left">Write an “x” to the left of the rows that are to be hidden. Write a “y” above the corresponding columns. </li> | <li> <p align="left">Write an “x” to the left of the rows that are to be hidden. Write a “y” above the corresponding columns. </li> | ||
<li> <p align="left">Select the table in which the rows/columns are to be hidden. </li> | <li> <p align="left">Select the table in which the rows/columns are to be hidden. </li> | ||
| Zeile 17: | Zeile 17: | ||
<li> <p align="left">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.</li> | <li> <p align="left">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.</li> | ||
</ | </ol> | ||
</p> | </p> | ||
Version vom 30. Juni 2023, 10:52 Uhr
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.