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 Die Basisfunktionen von firesys rect 288 77 450 182 Texte_in_Excel_gestalten rect 204 76 285 184 Übersicht_StyleGuide rect 464 74 520 180 Texte_in_Excel_gestalten#Highlight rect 545 73 610 183 Texte_in_Excel_gestalten#Bedingte_Formatierung rect 859 77 1055 186 Formeln rect 1056 75 1500 187 Ansichten_und_Kommentare_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
Die firesys-Gestaltungsfunktionen in Excel
Der StyleGuide
Formatierungsfunktionen in Excel
Excel-Formeln in firesys verwenden
Ansichten und Kommentare in Excel