Vorlage:Video-Excel Gestaltung Bereiche Leere Bereiche-English

The explanation of the individual steps in detail

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.