Vorlage:Video-Excel Gestaltung Bereiche Leere Bereiche-English

Aus firesys Hilfe
Version vom 8. August 2023, 10:34 Uhr von I.desalvo (Diskussion | Beiträge)
(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Zur Navigation springen Zur Suche springen


The explanation of the individual steps in detail

To delete empty rows and columns from your Excel spreadsheet:

  1. Select the table in which empty rows and columns are to be marked.

  2. In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button.

  3. Select “Rows” in the drop-down under “Select”.
    → All empty rows in your selection will be marked.

  4. Then select “Columns” in the drop-down under “Select”.
    → All empty columns in your selection will be marked.

  5. Again, select the table in which empty rows are to be deleted.

  6. In the tab “*Design” in the group “Ranges” click on the button “Empty areas”.

  7. Select “Rows” in the drop-down under “Delete”.
    → All empty rows in your selection will be deleted.

  8. Again, select the table in which empty columns are to be deleted.

  9. In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button.

  10. Select “Columns” in the drop-down under “Delete”.
    → All empty columns in your selection will be deleted.