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.
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
Good to know
| |
---|---|
To show or hide rows and columns, you must select the area in which the rows and columns are located using the mouse pointer. |
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
Video: Hide columns and rows in Excel spreadsheet
How to hide individual rows and columns in your Excel spreadsheet:
-
Write an “x” to the left of the rows that are to be hidden. Write a “y” above the corresponding columns.
-
Select the table in which the rows/columns are to be hidden.
-
In the tab “*Design” in the group “Ranges” click on the button “X/Y areas”.
-
Select the option “Rows” in the drop-down under “Hide”.
→The rows marked with “x” are hidden. -
To hide the columns marked with “y”, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”.
-
Select the option “Columns” in the drop-down under “Hide”.
→ The columns marked with “y” are hidden. -
To show the hidden rows and columns again, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”.
-
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.
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
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.
See also
Design an Excel document
The StyleGuide in Excel
Design texts in Excel
Formulas
Views and comments in Excel