Excel-areas: Unterschied zwischen den Versionen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
Zeile 19: | Zeile 19: | ||
== Name manager == | == Name manager == | ||
=== [[Datei:NameManager_16.png|link=|16px]] Name | === [[Datei:NameManager_16.png|link=|16px]] Name Manager === | ||
Lists all used names in the workbook. Here you can create, edit, delete and search names. | Lists all used names in the workbook. Here you can create, edit, delete and search names. |
Version vom 16. April 2021, 11:57 Uhr
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.
See also
Design an Excel document
The StyleGuide in Excel
Design texts in Excel
Formulas
Views and comments in Excel