Vorlage:Video-Excel Gestaltung Bereiche-XY-Bereiche-English: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
(Die Seite wurde neu angelegt: „center|808px|border <center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; over…“)
 
Keine Bearbeitungszusammenfassung
 
(Eine dazwischenliegende Version von einem anderen Benutzer wird nicht angezeigt)
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">
<ul>
  <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 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">Select the option “Columns” in the drop-down under “Hide”. 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”. The rows marked with “x” and the columns marked with “y” are shown again.</li>  


</ul>
<p align="left"> How to hide individual rows and columns in your Excel spreadsheet: <br><br>
 
<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 option “Rows” in the drop-down under “Hide”.
<br> &rarr;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> &rarr; 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> &rarr; The rows marked with “x” and the columns marked with “y” are shown again.</li>
 
</ol>
</p>
</p>
</center>  
</center>  
 
</div>
</div></div>
</div>

Aktuelle Version vom 8. August 2023, 10:39 Uhr


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.