Design texts in Excel: Unterschied zwischen den Versionen
(Die Seite wurde neu angelegt: „TBD TBD Grafik == Formatting text == === link=|16px Zeilentypen auswählen TBD === Hier können Sie der aktuell ausgewählten Zelle einen…“) |
Keine Bearbeitungszusammenfassung |
||
| Zeile 97: | Zeile 97: | ||
Colours selected cells red or removes this highlighting so that the cells can be replaced with Xs in Word. This function is useful if you want to transfer your confidential data to external parties, e.g. your translator. | Colours selected cells red or removes this highlighting so that the cells can be replaced with Xs in Word. This function is useful if you want to transfer your confidential data to external parties, e.g. your translator. | ||
=== | == [[Datei:rxbtnCellBackground_03.png|link=|16px]] Do not apply number format == | ||
Highlights the selected cells in green or removes the highlight. The contents of the cells highlight-ed in green (e.g. the term “Chapter 2.1”) are ignored when the number format of language-numbers is used. | |||
=== | == [[Datei:rxbtnCellBackground_04.png|link=|16px]] Import brackets == | ||
In the past, numbers in brackets were shown as negative numbers in Word. When you apply the “import brackets” function to Excel cells, numbers in brackets (e.g. information from the notes) are transferred to Word when updating. When the number format of languagenumbers is used, they are not recognized as negative numbers and therefore remain in the table as numbers in brackets. This is particularly useful if you want to display information from the notes with brack-ets in your tables. | |||
=== | == [[Datei:rxbtnCellBackground_05.png|link=|16px]] Strikethrough== | ||
Highlights the selected cells in light blue or removes this highlight again. With cells that are high-lighted in light blue, two diagonal lines are set when they are imported into Word. This can be used in reports, for example, which are created in accordance with the Solvency II Standard. | |||
== [[Datei:rxbtnHighlightOnOff_16.png|link=|16px]] Highlight == | == [[Datei:rxbtnHighlightOnOff_16.png|link=|16px]] Highlight == | ||
Allocates a highlighting to the selected cells and applies this when updating the table in Word. | |||
=== [[Datei:rxbtnHighlightOnOff_16.png|link=|16px]] Highlight === | === [[Datei:rxbtnHighlightOnOff_16.png|link=|16px]] Highlight === | ||
Shows all highlighting in your layout. | |||
== [[Datei:ConditionalFormattingMenu_16.png|link=|16px]] Conditional formatting == | |||
Find trends and patterns in your data easily with the aid of bars. Colours and symbols visually highlight important values. The conditional formatting can be transferred to Word. | |||
The transfer of the background and font colours of an Excel cell is available to you in all firesys documents. The relevant option must be activated in Word for the transfer. In the firesys layout, you can also integrate icon sets in tables. | |||
== Siehe auch == | == Siehe auch == | ||
Version vom 29. November 2019, 11:47 Uhr
TBD
TBD Grafik
Formatting text
Zeilentypen auswählen TBD
Hier können Sie der aktuell ausgewählten Zelle einen Zeilentypen zuweisen. Es gibt vordefinierte Formatvorlagen für den Tabellenkopf und den Tabellenkörper. TBD
So können Sie in Excel einer Tabelle Bereiche zuweisen:
-
Um eine Tabelle in Word einfügen zu können, benötigt diese einen zugewiesenen Namen oder Druckbereich. Wählen Sie hierzu den kompletten Bereich der Tabelle in Ihrem Excel-Dokument aus.
-
Im Menüband „*Gestaltung“ können Sie in der Gruppe „Bereiche“ für die zuvor festgelegte Auswahl mit der Funktion „Druckbereich“ den gewünschten Druckbereich automatisch festlegen,
-
Um einen Zeilentypen zuweisen zukönnen, müssen Sie die entsprechende Zeile, bzw. eine Zelle aus dieser Zeile markieren.
-
Im Menüband „*Gestaltung“ in der Gruppe „Formatierung“ können Sie mit der Funktion „Zeilentypen“ die verschiedenen Zeilentypen zuweisen – z.B. „Tabellenkopf einzelne“ für die Tabellenkopfzeile.
-
Um eine der von firesys vordefinierten Spaltenhervorhebungen zu verwenden, wählen Sie die hervorzuhebende Spalte aus.
-
Klicken Sie im Menüband „*Gestaltung“ in der Gruppe „Formatierung“ auf das Menü „Highlight“ und wählen Sie ein Highlight aus dem Dropdown-Menü aus.
Einen Zeilentyp zuweisen:
Eine Spaltenhervorhebung zuweisen:
Gut zu wissen Datei:Glühbirne.png Es ist ausreichend, eine Zelle in einer Spalte zu markieren und dieser eine der vordefinierten Formatvorlagen zuzuweisen - firesys weist automatisch der komplette Tabellenzeile die gewählte Formatvorlage zu.
Datei:RxebRowType 16.png Show style
Indicates which format style is currently in use in the selected cell.
Bold
Formats the selected text in bold.
Italic
Formats the selected text in italics.
![16px]/[Datei:IndentIncreaseExcel_16.png](/mediawiki/images/8/81/IndentDecreaseExcel_16.png "16px]/[Datei:IndentIncreaseExcel_16.png")
Decrease / increase indent
Insert of remove a tab in the selected Excel cell.
Connect and centre
Connects selected Excel cells and aligns the cell content to the centre.
Highlighting
Highlight
Highlights the selected cells in yellow or removes the highlight. Yellow highlights can be transferred to Word.
Hide numbers
Highlights the selected cells in red or removes the highlight. Contents of the cell highlighted in red can be hidden with Xs in Word.
Ignore number format
Highlights the selected cells in green or removes the highlight. The contents of the cells highlighted in green are ignored by languagenumbers when the number format is used in Word.
Import brackets
Highlights the selected cells in blue or removes the highlight. Brackets in cells highlighted in blue are imported to Word. They are not recognized as negative numbers when the number format of languagenumbers is used.
Strikethrough
Highlights the selected cells in light blue or removes this highlight again. With cells that are highlighted in light blue, two diagonal lines are set when they are imported into Word.
Highlighting
Highlight entire columns or individual cells in Excel with a defined background colour or remove the highlighting. In Excel, a pattern is set across the selected cells so the background and font colours are easily recognizable. Depending on the layout, various highlights are available (e.g.: previous year, current year, ...).
Highlight
Colours cells in Excel yellow or removes this highlighting so that this can be transferred to Word. This way, numbers or texts in tables, that have not been defined yet, can be highlighted sustain-ably.
Hide numbers
Colours selected cells red or removes this highlighting so that the cells can be replaced with Xs in Word. This function is useful if you want to transfer your confidential data to external parties, e.g. your translator.
Do not apply number format
Highlights the selected cells in green or removes the highlight. The contents of the cells highlight-ed in green (e.g. the term “Chapter 2.1”) are ignored when the number format of language-numbers is used.
Import brackets
In the past, numbers in brackets were shown as negative numbers in Word. When you apply the “import brackets” function to Excel cells, numbers in brackets (e.g. information from the notes) are transferred to Word when updating. When the number format of languagenumbers is used, they are not recognized as negative numbers and therefore remain in the table as numbers in brackets. This is particularly useful if you want to display information from the notes with brack-ets in your tables.
Strikethrough
Highlights the selected cells in light blue or removes this highlight again. With cells that are high-lighted in light blue, two diagonal lines are set when they are imported into Word. This can be used in reports, for example, which are created in accordance with the Solvency II Standard.
Datei:RxbtnHighlightOnOff 16.png Highlight
Allocates a highlighting to the selected cells and applies this when updating the table in Word.
Datei:RxbtnHighlightOnOff 16.png Highlight
Shows all highlighting in your layout.
Conditional formatting
Find trends and patterns in your data easily with the aid of bars. Colours and symbols visually highlight important values. The conditional formatting can be transferred to Word.
The transfer of the background and font colours of an Excel cell is available to you in all firesys documents. The relevant option must be activated in Word for the transfer. In the firesys layout, you can also integrate icon sets in tables.