Design an Excel document: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(16 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
<imagemap>Datei:Excel Gestaltung Imagemap.jpg|center|1200px
[[Datei:EN_Menüband_Excel_Gestaltung.jpg|center|1200px]]
rect 0 70 69 162 [[Übersicht_Dashboard]]
rect 71 69 175 162 [[Die_Basisfunktionen_von_firesys]]
rect 180 69 247 162 [[Übersicht_StyleGuide]]
rect 251 70 406 163 [[Texte_in_Excel_gestalten]]
rect 400 70 468 162 [[Texte_in_Excel_gestalten#Highlight]]
rect 471 68 562 161 [[Texte_in_Excel_gestalten#Bedingte_Formatierung]]
rect 566 69 645 162 [[Excel-Bereiche#Druckbereich]]
rect 648 70 795 89 [[Excel-Bereiche#Namens-Manager]]
rect 647 93 796 113 [[Excel-Bereiche#X.2FY-Bereiche]]
rect 647 115 796 136 [[Excel-Bereiche#Leere_Bereiche|]]
rect 802 70 964 159 [[Formeln]]
rect 969 71 1093 162 [[Ansichten_und_Kommentare_in_Excel#Ansicht]]
rect 1105 72 1363 161 [[Ansichten_und_Kommentare_in_Excel#Kommentare_in_Excel]]
#<!-- Created by Online Image Map Editor (http://www.maschek.hu/imagemap/index) -->
desc none
</imagemap>


{| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;"
{| class="toptextcells" style="padding: 5px; border:none; background:#FFFFFF; width:100%; border-spacing:10px;"
Zeile 29: Zeile 13:
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:rxtglbtnStyleGuide_32.png|link=The_StyleGuide_in_Excel]] [[The_StyleGuide_in_Excel|The StyleGuide]]</div>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:rxtglbtnStyleGuide_32.png|link=The_StyleGuide_in_Excel]] [[The_StyleGuide_in_Excel|The StyleGuide in Excel]]</div>
 
[[Datei:Beispiel-Teaser1.jpg|left|175px|Testbild|link=The_StyleGuide_in_Excel]]


<!-- [[Datei:Beispiel-Teaser1.jpg|left|175px|Testbild|link=The_StyleGuide_in_Excel]]-->
Makes row types that were developed for your publication according to the current StyleGuide available in a separate task area. You can also configure row types in Excel and remove excess styles.  <small>'''[[The_StyleGuide_in_Excel|more]]'''</small>
Makes row types that were developed for your publication according to the current StyleGuide available in a separate task area. You can also configure row types in Excel and remove excess styles.  <small>'''[[The_StyleGuide_in_Excel|more]]'''</small>
----
----
Zeile 39: Zeile 22:
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:ConditionalFormattingMenu_32.png|link=Design_texts_in_Excel]] [[Design_texts_in_Excel|Design texts in Excel]]</div>
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:ConditionalFormattingMenu_32.png|link=Design_texts_in_Excel]] [[Design_texts_in_Excel|Design texts in Excel]]</div>
[[Datei:Beispiel-Teaser2.jpg|left|175px|Testbild|link=Design_texts_in_Excel]]
<!-- [[Datei:Beispiel-Teaser2.jpg|left|175px|Testbild|link=Design_texts_in_Excel]]-->
Here you will find all formats you need to design your tables. You will also find useful Excel functions, e.g. alignment, tabs, bold or italics. <small>'''[[Design_texts_in_Excel|more]]'''</small>  
Here you will find all formats you need to design your tables. You will also find useful Excel functions, e.g. alignment, tabs, bold or italics. <small>'''[[Design_texts_in_Excel|more]]'''</small>  
-----
-----
</div>
</div>
| style="width: 30%"|<!-- ABS.1: Rechte Spalte ----------------------------------------------------------------------->
| style="width: 30%"|<!-- ABS.1: Rechte Spalte ----------------------------------------------------------------------->
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnShowRowColXY_32.png|link=Excel-areas]] [[Excel-areas|Excel areas]]</div>
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxbtnShowRowColXY_32.png|link=Excel-areas]] [[Excel-areas|Excel-areas]]</div>
[[Datei:Beispiel-Teaser2.jpg|left|175px|Testbil|link=Excel-areas]]
<!-- [[Datei:Beispiel-Teaser2.jpg|left|175px|Testbil|link=Excel-areas]]-->
Table areas in Excel play an important role when firesys is used, because this is how the import of Excel data is controlled in Word. <small>'''[[Excel-areas|more]]'''</small>   
Table areas in Excel play an important role when firesys is used, because this is how the import of Excel data is controlled in Word. <small>'''[[Excel-areas|more]]'''</small>   
-----
-----
Zeile 53: Zeile 36:
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
| style="width: 30%"|<!-- ABSCHNITT 1 ------------------------------------------------------------------------------->
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<!-- ABS.1: Linke Spalte ------------------------------------------------------------------------>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxmnuShowFormulaFormatting_32.png|link=Excel-formulas]] [[Excel-formulas|Formulas]]</div>
<div style="text-align: center; padding: 4px; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;">[[Datei:rxmnuShowFormulaFormatting_32.png|link=Formulas]] [[Formulas|Formulas]]</div>
 
[[Datei:Beispiel-Teaser4.jpg|left|175px|Testbild|link=Excel-formulas]]


So that you can work smoothly with firesys in Excel, the menu buttons for creating total and aggregate functions and the firesys function Format formulas are located in the “*Design” ribbon. <small>'''[[Excel-formulas|more]]'''</small>
<!-- [[Datei:Beispiel-Teaser4.jpg|left|175px|Testbild|link=Formulas]]-->
So that you can work smoothly with firesys in Excel, the menu buttons for creating total and aggregate functions and the firesys function Format formulas are located in the “*Design” ribbon. <small>'''[[Formulas|more]]'''</small>
----
----


Zeile 63: Zeile 45:
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
| style="width: 30%"|<!-- ABS.1: Mittlere Spalte --------------------------------------------------------------------->
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:ReviewNewComment_32.png|link=Views_and_comments_in_Excel]] [[Views_and_comments_in_Excel|Views and comments in Excel]]</div>
<div style="padding: 4px; text-align: center; font-family: sans-serif; font-size:130%; border-top: solid 2px #e67d05; margin-top:5px; border-bottom: solid 2px #e67d05; margin-bottom:5px;"> [[Datei:ReviewNewComment_32.png|link=Views_and_comments_in_Excel]] [[Views_and_comments_in_Excel|Views and comments in Excel]]</div>
[[Datei:Beispiel-Teaser5.jpg|left|175px|Testbild|link=Views_and_comments_in_Excel]]
<!-- [[Datei:Beispiel-Teaser5.jpg|left|175px|Testbild|link=Views_and_comments_in_Excel]]-->
So that you can work smoothly with firesys in Excel, the Excel functions for configuring the view and managing comments are located in the “*Design” ribbon. <small>'''[[Views_and_comments_in_Excel|more]]'''</small>  
So that you can work smoothly with firesys in Excel, the Excel functions for configuring the view and managing comments are located in the “*Design” ribbon. <small>'''[[Views_and_comments_in_Excel|more]]'''</small>  
-----
-----
Zeile 76: Zeile 58:
== See also  ==
== See also  ==


[[Datei:Navigation_hoch.svg|link=]]  [[Die_firesys-Funktionen_in_Excel|The firesys functions in Excel]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[The_firesys_functions_in_Excel|The firesys functions in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Übersetzungen_in_Excel|Translations in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Translations_in_Excel|Translations in Excel]] <br>
[[Datei:Navigation_rechts.svg|link=]] [[Der_Blatt-Status_in_Excel|The worksheet status]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_status_in_Excel|The worksheet status in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Validierungen_in_Excel|Validations in Excel]]  <br>
[[Datei:Navigation_rechts.svg|link=]] [[Maintain Excel contents|Maintain Excel contents]]  <br>


{{MoreContent}}
{{MoreContent}}
[[Kategorie:Excel Dokument-gestalten]]
[[Kategorie:English-Excel Dokument-gestalten]]

Aktuelle Version vom 19. November 2021, 11:59 Uhr

EN Menüband Excel Gestaltung.jpg

Excel Funktionen 64.png
Design an Excel document

You can find everything you need for formatting your tables predefined in the “*Design” menu ribbon.

Excel Funktionen 64.png

Makes row types that were developed for your publication according to the current StyleGuide available in a separate task area. You can also configure row types in Excel and remove excess styles. more



Here you will find all formats you need to design your tables. You will also find useful Excel functions, e.g. alignment, tabs, bold or italics. more


Table areas in Excel play an important role when firesys is used, because this is how the import of Excel data is controlled in Word. more



So that you can work smoothly with firesys in Excel, the menu buttons for creating total and aggregate functions and the firesys function Format formulas are located in the “*Design” ribbon. more



So that you can work smoothly with firesys in Excel, the Excel functions for configuring the view and managing comments are located in the “*Design” ribbon. more




See also

Navigation hoch.svg The firesys functions in Excel
Navigation rechts.svg Translations in Excel
Navigation rechts.svg The worksheet status in Excel
Navigation rechts.svg Maintain Excel contents

Further contents

firesys website
Customer area
YouTube