Vorlage:Video-Excel Gestaltung Bereiche Leere Bereiche-English: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| Zeile 2: | Zeile 2: | ||
<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"> To delete empty rows and columns from your Excel spreadsheet: <br><br> | <div class="mw-collapsible-content"> | ||
<p align="left"> To delete empty rows and columns from your Excel spreadsheet: <br><br> | |||
<ol> | <ol> | ||
<li> <p align="left">Select the table in which empty rows and columns are to be marked. </li> | |||
<li> <p align="left">In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button. </li> | |||
<li> <p align="left">Select “Rows” in the drop-down under “Select”. All empty rows in your selection will be marked.</li> | <li> <p align="left">In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button. </li> | ||
<li> <p align="left">Select “Rows” in the drop-down under “Select”. | |||
<li> <p align="left">In the tab “*Design” in the group “Ranges” click on the button “Empty areas”. </li> | <br> → All empty rows in your selection will be marked.</li> | ||
<li> <p align="left">Select “Rows” in the drop-down under “Delete”. All empty rows in your selection will be deleted. </li> | |||
<li> <p align="left">Then select “Columns” in the drop-down under “Select”. | |||
<li> <p align="left">In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button. </li> | <br> → All empty columns in your selection will be marked. </li> | ||
<li> <p align="left">Select “Columns” in the drop-down under “Delete”. All empty columns in your selection will be deleted. </li> | |||
<li> <p align="left">Again, select the table in which empty rows are to be deleted. </li> | |||
<li> <p align="left">In the tab “*Design” in the group “Ranges” click on the button “Empty areas”. </li> | |||
<li> <p align="left">Select “Rows” in the drop-down under “Delete”. | |||
<br> → All empty rows in your selection will be deleted. </li> | |||
<li> <p align="left">Again, select the table in which empty columns are to be deleted.</li> | |||
<li> <p align="left">In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button. </li> | |||
<li> <p align="left">Select “Columns” in the drop-down under “Delete”. | |||
<br> → All empty columns in your selection will be deleted. </li> | |||
</ol> | </ol> | ||
</center> | </center> | ||
</div> | |||
</div></div> | </div> | ||
Aktuelle Version vom 8. August 2023, 10:34 Uhr
To delete empty rows and columns from your Excel spreadsheet:
-
Select the table in which empty rows and columns are to be marked.
-
In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button.
-
Select “Rows” in the drop-down under “Select”.
→ All empty rows in your selection will be marked. -
Then select “Columns” in the drop-down under “Select”.
→ All empty columns in your selection will be marked. -
Again, select the table in which empty rows are to be deleted.
-
In the tab “*Design” in the group “Ranges” click on the button “Empty areas”.
-
Select “Rows” in the drop-down under “Delete”.
→ All empty rows in your selection will be deleted. -
Again, select the table in which empty columns are to be deleted.
-
In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button.
-
Select “Columns” in the drop-down under “Delete”.
→ All empty columns in your selection will be deleted.