Vorlage:Video-Excel Gestaltung Bereiche-XY-Bereiche-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 1: | Zeile 1: | ||
[[Datei:Excel-Gestaltung-Bereiche-XY-Bereiche.webm|center|808px|border]] | [[Datei:Excel-Gestaltung-Bereiche-XY-Bereiche.webm|center|808px|border]] | ||
<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | <center> | ||
<div style="font-weight:bolder;line-height:1.8;">The explanation of the individual steps in detail</div> | <div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto> | ||
<div class="mw-collapsible-content"> | <div style="font-weight:bolder;line-height:1.8;">The explanation of the individual steps in detail</div> | ||
<p align="left"> How to hide individual rows and columns in your Excel spreadsheet: <br><br> | <div class="mw-collapsible-content"> | ||
<p align="left"> How to hide individual rows and columns in your Excel spreadsheet: <br><br> | |||
<ol> | <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">Select the table in which the rows/columns are to be hidden. </li> | |||
<li> <p align="left">In the tab “*Design” in the group “Ranges” click on the button “X/Y areas”.</li> | <li> <p align="left">Select the table in which the rows/columns are to be hidden. </li> | ||
<li> <p align="left">Select the option “Rows” in the drop-down under “Hide”. The rows marked with “x” are hidden. </li> | |||
<li> <p align="left">To hide the columns marked with “y”, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”. </li> | <li> <p align="left">In the tab “*Design” in the group “Ranges” click on the button “X/Y areas”.</li> | ||
<li> <p align="left">Select the option “Columns” in the drop-down under “Hide”. The columns marked with “y” are hidden. </li> | |||
<li> <p align="left">Select the option “Rows” in the drop-down under “Hide”. | |||
<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> | <br> →The rows marked with “x” are hidden. </li> | ||
<li> <p align="left">To hide the columns marked with “y”, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”. </li> | |||
<li> <p align="left">Select the option “Columns” in the drop-down under “Hide”. | |||
<br> → The columns marked with “y” are hidden. </li> | |||
<li> <p align="left">To show the hidden rows and columns again, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”. </li> | |||
<li> <p align="left">Select the option “Rows and columns” in the drop-down under “Show”. | |||
<br> → The rows marked with “x” and the columns marked with “y” are shown again.</li> | |||
</ol> | </ol> | ||
</p> | </p> | ||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 8. August 2023, 10:39 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.