Excel-areas

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen

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

PrintAreaSetPrintArea 16.png Define

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

PrintAreaClearPrintArea 16.png Unlock

Deselect the existing print area.

Name manager

NameManager 16.png Namens-Manager

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


Excel Gestaltung Namens-Manager.jpg


PrintAreaClearPrintArea 16.png 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.


Excel Gestaltung Namen-entfernen.jpg


X/Y ranges

Hide

RxbtnHideRowXY 16.png Rows

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

RxbtnHideColXY 16.png Columns

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

RxbtnHideRowColXY 16.png Rows and columns

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

Show

RxbtnShowRowXY 16.png Rows

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

RxbtnShowColXY 16.png Columns

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

RxbtnShowRowColXY 16.png Rows and columns

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

Empty areas

Select

RxbtnShowEmptyRow 16.png Rows

All empty rows in the selection are selected.

RxbtnShowEmptyCol 16.png Columns

All empty columns in the selection are selected.

Löschen

RxbtnDeleteEmptyRow 16.png Delete

All empty rows in the selection are deleted.

RxbtnDeleteEmptyCol 16.png Columns

All empty columns in the selection are deleted.


See also

Navigation hoch.svg Die firesys-Gestaltungsfunktionen in Excel
Navigation rechts.svg Der StyleGuide
Navigation rechts.svg Formatierungsfunktionen in Excel
Navigation rechts.svg Excel-Formeln in firesys verwenden
Navigation rechts.svg Ansichten und Kommentare in Excel

Further contents

firesys website
Customer area
YouTube