Design texts in Excel: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(7 dazwischenliegende Versionen von 3 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
The “Layout” menu ribbon makes working with firesys in Excel easier. There are a number of options which you can use to change your document’s layout quickly and easily according to your requirements.
The “Layout” menu ribbon makes working with firesys in Excel easier. There are a number of options which you can use to change your document’s layout quickly and easily according to your requirements.


<imagemap>Image:EN_Excel_Menüband_Gestaltung_Texte-in-Excel-gestalten.jpg|center|1200px
[[Datei:EN_Menüband_Excel_Gestaltung_Formatierung.jpg|center|1200px]]
desc none
</imagemap>




Zeile 14: Zeile 12:




{{Vorlage:Video - Zeilentyp zuweisenENG}}
{{Vorlage:Video - Zeilentyp zuweisen-English}}




Zeile 25: Zeile 23:




=== [[Datei:rxebRowType_16.png|link=|16px]] Show style ===
=== [[Datei:RxebRowType 32.png|link=|16px]] Show style ===


Indicates which format style is currently in use in the selected cell.
Indicates which format style is currently in use in the selected cell.
Zeile 52: Zeile 50:




{{Vorlage:Video-HervorhebungHervorhebenENG}}
{{Vorlage:Video-HervorhebungHervorheben-English}}




Zeile 60: Zeile 58:




{{Vorlage:Video-HervorhebungZahlenverbergenENG}}
{{Vorlage:Video-HervorhebungZahlenverbergen-English}}




Zeile 68: Zeile 66:




{{Vorlage:Video-HervorhebungZahlenformatIgnorieren}}
{{Vorlage:Video-HervorhebungZahlenformatIgnorieren-English}}




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 [https://www.firesys.de/fileadmin/user_upload/Download-Dateien/Moduluebersicht/Moduluebersicht_-_Einzelseiten_EN/firesys_languagenumbers_EN.pdf language-numbers] is used.
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 languagenumbers is used.


=== [[Datei:rxbtnCellBackground_04.png|link=|16px]] Import brackets ===
=== [[Datei:rxbtnCellBackground_04.png|link=|16px]] Import brackets ===




{{Vorlage:Video-Hervohebungen-Klammern einlesenENG}}
{{Vorlage:Video-Hervohebungen-Klammern einlesen-English}}




Zeile 84: Zeile 82:




{{Vorlage:Video-HervorhebungDurchkreuzenENG}}
{{Vorlage:Video-HervorhebungDurchkreuzen-English}}




Zeile 90: Zeile 88:




== [[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.
=== Case study: Application of a colour scale ===
{{Vorlage:Video-BedingteFormatierungFarbskalaENG}}
=== Case study: Display of arrow symbols ===
{{Vorlage:Video-BedingteFormatierungRichtungenENG}}
=== Case study: The use of conditional formatting with font adaptations ===
{{Vorlage:Video-BedingteFormatierungSchriftfarbe}}





Aktuelle Version vom 23. November 2023, 14:13 Uhr

The “Layout” menu ribbon makes working with firesys in Excel easier. There are a number of options which you can use to change your document’s layout quickly and easily according to your requirements.

EN Menüband Excel Gestaltung Formatierung.jpg


Formatting text

RxmnuApplyFormat 16.png Select line types

Here you can assign a line type to the currently selected cell. Predefined styles are available for the table header and table body.


Vorlage:Video - Zeilentyp zuweisen-English


Glühbirne neu.png
Good to know

It is sufficient to select a cell in a column and assign one of the predefined styles to it - firesys automatically assigns the selected style to the complete table row.


RxebRowType 32.png Show style

Indicates which format style is currently in use in the selected cell.

Bold 16.png Bold

Formats the selected text in bold.

Italic 16.png Italic

Formats the selected text in italics.

16px]/[Datei:IndentIncreaseExcel_16.png Decrease / increase indent

Insert of remove a tab in the selected Excel cell.

MergeCenter 16.png Connect and centre

Connects selected Excel cells and aligns the cell content to the centre.

RxmnuCellBackground 16.png 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, ...).

RxbtnCellBackground 01.png Highlight


A detailed explanation of the individual steps

How to use the highlighting functions of firesys:

  1. Open an Excel workbook and select the cells you want to highlight on the worksheet.

  2. Click on the "Highlighting" button in the "Formatting" group in the "*Design" menu band and select the "Highlighting (yellow)" function.
    →The selected cells are highlighted in yellow.

  3. Now switch to the corresponding Word document and select the appropriate table.

  4. Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".

  5. In the group "Hide numbers" you can activate the function "Transfer highlights from Excel".

  6. Now you can close the firesys settings.

  7. Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
    → The selected table is updated and the highlighted cells are highlighted in yellow.


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.

RxbtnCellBackground 02.png Hide numbers


A detailed explanation of the individual steps

To use the highlighting functions of firesys:

  1. Open an Excel workbook and select the cells you want to highlight on the worksheet.

  2. Click the "Highlighting" button in the "Formatting" group in the "*Design" menu band and select the "Hide numbers (red)" function.


  3. → The selected cells are highlighted in red.
  4. Now switch to the corresponding Word document and select the appropriate table.

  5. Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".

  6. In the "Hide numbers" group, you can activate the function "Hide Excel cells with a red background during import" and then specify the number of X-characters to replace the numbers.

  7. Now you can close the firesys settings.

  8. Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
    → The selected table is updated and the numbers are replaced by X-characters and a magenta highlighting.


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.

RxbtnCellBackground 03.png Ignore number format


A detailed explanation of the individual steps

How to use the highlighting functions of firesys:

  1. Open an Excel workbook and select the cells you want to highlight on the worksheet.

  2. Click on the "Highlighting" button in the "Formatting" group of the "Design" menu band and select the "Ignore number format" function (green).
    → The selected cells are highlighted in red -

  3. Now switch to the corresponding Word document and select the appropriate table.

  4. Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".

  5. In the "Hide numbers" group, you can activate the function "Hide Excel cells with red background when reading in" and then specify the number of X-characters to replace the numbers.

  6. Now you can close the firesys settings.

  7. Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
    → The selected table is updated and the number format is kept as desired and is not replaced by the format defined for the numerical values in Word.


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 languagenumbers is used.

RxbtnCellBackground 04.png Import brackets


A detailed explanation of the individual steps


  1. In Excel, select the appropriate worksheet and cells.

  2. In the "Design" ribbon, in the "Formatting" group, click the "Highlight" button (shown as a bucket icon).

  3. Select the "Import brackets" (blue) option.
    → Select a width for the new table - The selected cells are highlighted in blue in Excel.

  4. Switch to the corresponding Word document in which the Excel table is linked and select the appropriate table.

  5. In the "Contents" menu, in the "Excel Data" group, click on the "Update current Excel object" button.
    → The selected table is updated and the numerical values from Excel are replaced by the numbers in 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.

RxbtnCellBackground 05.png Strikethrough


A detailed explanation of the individual steps

How to use the highlighting functions of firesys:

  1. Open an Excel workbook and select the cells you want to highlight on the worksheet.

  2. Click the "Highlighting" button in the "Formatting" group in the "*Design" menu band and select the "Cross over (light blue)" function.
    →Selected cells are highlighted in light blue.

  3. Now switch to the corresponding Word document and select the appropriate table.

  4. Click on the button "firesys settings" in the group "firesys" and select the tab "Data from Excel".

  5. In the group "Hide numbers" you can activate the function "Transfer highlights from Excel".

  6. Now you can close the firesys settings.

  7. Click on the "*Contents" tab, in the "Excel Data" group on the "Update*" button.
    →The selected table is updated and the cells highlighted in the Excel document are crossed out.


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. This can be used in reports, for example, which are created in accordance with the Solvency II Standard.



See also

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

Further contents

firesys website
Customer area
YouTube