Excel-areas
The work with Excel areas is an elementary element of firesys, because many functions in interaction with Word can only be used with properly assigned Excel areas.
<imagemap>Datei:EN Excel Gestaltung Bereiche.jpg|center|1200px rect 3 75 200 187 The_basic_functions_of_firesys rect 288 77 450 182 Design_texts_in_Excel rect 204 76 285 184 The_StyleGuide_in_Excel rect 464 74 520 180 Design_texts_in_Excel#Highlighting rect 545 73 610 183 Design_texts_in_Excel#Conditional_formatting rect 859 77 1055 186 Formulas rect 1056 75 1500 187 Views_and_comments_in_Excel 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
Namens-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.
See also
Design an Excel document
The StyleGuide in Excel
Design texts in Excel
Formulas
Views and comments in Excel