Design an Excel document: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
Keine Bearbeitungszusammenfassung |
Keine Bearbeitungszusammenfassung |
||
| (16 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt) | |||
| Zeile 1: | Zeile 1: | ||
[[Datei:EN_Menüband_Excel_Gestaltung.jpg|center|1200px]] | |||
{| 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]]--> | |||
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= | <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> | ||
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>'''[[ | <!-- [[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=]] [[ | [[Datei:Navigation_hoch.svg|link=]] [[The_firesys_functions_in_Excel|The firesys functions in Excel]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[Translations_in_Excel|Translations in Excel]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[Datei:Navigation_rechts.svg|link=]] [[The_worksheet_status_in_Excel|The worksheet status in Excel]] <br> | ||
[[Datei:Navigation_rechts.svg|link=]] [[ | [[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
| |||||
|
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
The firesys functions in Excel
Translations in Excel
The worksheet status in Excel
Maintain Excel contents