Excel-areas: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(14 dazwischenliegende Versionen von 4 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
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.  
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.  
 
[[Datei:EN_Menüband_Excel_Gestaltung_Bereiche.jpg|center|1200px]]


<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
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
</imagemap>




Zeile 26: Zeile 17:
== Name manager ==
== Name manager ==


=== [[Datei:NameManager_16.png|link=|16px]] Namens-Manager ===
=== [[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.




[[Datei:Excel_Gestaltung_Namens-Manager.jpg|center|500px]]
[[Datei:EN_Excel_Gestaltung_Namens-Manager.jpg|center|500px]]




Zeile 39: Zeile 30:




[[Datei:Excel_Gestaltung_Namen-entfernen.jpg|center|450px]]
[[Datei:EN Excel Gestaltung Namen-entfernen.jpg|center|450px]]




== X/Y ranges ==
== X/Y ranges ==
<div style="margin:0px; padding:0.7em 1em 0.7em 1em; background-color:#f6f4f2;border:1px solid #e67d05;width:50%">
{|
|-
! rowspan="2" |[[Datei:Glühbirne neu.png|left|link=|center|24px|]]
!<div style="text-align:left; font-size:120%;">Good to know</div>
|-
|<div style="font-size:95%;text-align:left;margin-top:10px;">
To show or hide rows and columns, you must select the area in which the rows and columns are located using the mouse pointer.
|}
</div>
</div>


=== Hide ===
=== Hide ===
Zeile 71: Zeile 74:


Shows all rows and columns on the worksheet, which start with x or y
Shows all rows and columns on the worksheet, which start with x or y
== Video: Hide columns and rows in Excel spreadsheet ==
{{Vorlage:Video-Excel Gestaltung Bereiche-XY-Bereiche-English}}


== Empty areas  ==
== Empty areas  ==
Zeile 93: Zeile 100:


All empty columns in the selection are deleted.
All empty columns in the selection are deleted.
== Video: Delete Empty Ranges from Excel Spreadsheet ==
{{Vorlage:Video-Excel Gestaltung Bereiche Leere Bereiche-English}}




== See also  ==
== See also  ==


[[Datei:Navigation_hoch.svg|link=]] [[Excel-Gestaltungs-Funktionen|Die firesys-Gestaltungsfunktionen in Excel]] <br>
[[Datei:Navigation_hoch.svg|link=]] [[Design_an_Excel_document|Design an Excel document]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Übersicht_StyleGuide|Der StyleGuide]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_StyleGuide_in_Excel| The StyleGuide in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Texte_in_Excel_gestalten|Formatierungsfunktionen in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Design_texts_in_Excel|Design texts in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Formeln|Excel-Formeln in firesys verwenden]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Formulas|Formulas]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Ansichten_und_Kommentare_in_Excel|Ansichten und Kommentare in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Views_and_comments_in_Excel|Views and comments in Excel]]  <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Excel Dokument-gestalten-Übersicht]]
[[Kategorie:English-Excel Dokument-gestalten-Übersicht]]
[[en:Excel-Ranges]]
[[en:Excel-Ranges]]

Aktuelle Version vom 7. März 2024, 07:55 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.

EN Menüband Excel Gestaltung Bereiche.jpg


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 Name Manager

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


EN 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.


EN Excel Gestaltung Namen-entfernen.jpg


X/Y ranges

Glühbirne neu.png
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

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

Video: Hide columns and rows in Excel spreadsheet


The explanation of the individual steps in detail

How to hide individual rows and columns in your Excel spreadsheet:

  1. Write an “x” to the left of the rows that are to be hidden. Write a “y” above the corresponding columns.

  2. Select the table in which the rows/columns are to be hidden.

  3. In the tab “*Design” in the group “Ranges” click on the button “X/Y areas”.

  4. Select the option “Rows” in the drop-down under “Hide”.
    →The rows marked with “x” are hidden.

  5. To hide the columns marked with “y”, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”.

  6. Select the option “Columns” in the drop-down under “Hide”.
    → The columns marked with “y” are hidden.

  7. To show the hidden rows and columns again, click on the button “X/Y-Ranges” in the tab “*Design” in the group “Ranges”.

  8. 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

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.


Video: Delete Empty Ranges from Excel Spreadsheet


The explanation of the individual steps in detail

To delete empty rows and columns from your Excel spreadsheet:

  1. Select the table in which empty rows and columns are to be marked.

  2. In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button.

  3. Select “Rows” in the drop-down under “Select”.
    → All empty rows in your selection will be marked.

  4. Then select “Columns” in the drop-down under “Select”.
    → All empty columns in your selection will be marked.

  5. Again, select the table in which empty rows are to be deleted.

  6. In the tab “*Design” in the group “Ranges” click on the button “Empty areas”.

  7. Select “Rows” in the drop-down under “Delete”.
    → All empty rows in your selection will be deleted.

  8. Again, select the table in which empty columns are to be deleted.

  9. In the “*Design” tab in the “Ranges” group, click on the “Empty areas” button.

  10. Select “Columns” in the drop-down under “Delete”.
    → All empty columns in your selection will be deleted.


See also

Navigation hoch.svg Design an Excel document
Navigation rechts.svg The StyleGuide in Excel
Navigation rechts.svg Design texts in Excel
Navigation rechts.svg Formulas
Navigation rechts.svg Views and comments in Excel

Further contents

firesys website
Customer area
YouTube