Excel-areas

The work with Excel areas is an essential element of firesys, because many functions in interaction with Word can only be used with properly assigned Excel areas.

<imagemap>Image:EN_Menüband_Excel_Gestaltung_Bereiche.jpg|center|1200px desc none </imagemap>

Print area

Define

Select a certain range of the sheet for printing or importing to Word.

Unlock

Deselect the existing print area.

Name manager

Name Manager

Lists all used names in the workbook. Here you can create, edit, delete and search names.

Remove names

If range names exist in your Excel document which have reference errors (the cells to which the range referred were deleted), you can display and delete these range names in a dialog.

X/Y ranges

Hide

Rows

Hides all rows in the worksheet, which start with x or y

Columns

Hides all columns in the worksheet, which start with x or y

Rows and columns

Hides all rows and columns in the worksheet, which start with x or y

Show

Rows

Shows all rows on the worksheet, which start with x or y

Columns

Shows all columns on the worksheet, which start with x or y

Rows and columns

Shows all rows and columns on the worksheet, which start with x or y

Empty areas

Select

Rows

All empty rows in the selection are selected.

Columns

All empty columns in the selection are selected.

Löschen

Delete

All empty rows in the selection are deleted.

Columns

All empty columns in the selection are deleted.

Video: Delete Empty Ranges from Excel Spreadsheet

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.

See also

Design an Excel document
The StyleGuide in Excel
Design texts in Excel
Formulas
Views and comments in Excel

Further contents

→ firesys website
→ Customer area
→ YouTube