The Premium Layout in Excel

Adjust graphics

To simplify the transfer of graphics from Excel to Word, there is the "Adjust graphic width" function. Using this function, it is possible to adapt graphics to the table widths or type area in your Word document in Excel. This saves you work when finalising your Word document later. At the touch of a button, you select the appropriate width.

If you are unsure which graphic width you should select, you have two possible orientation options:

• You can display which type area your document has in the Layout functions.
• You can check in Table assistant in Word which width you have selected here for tables.

To adjust the width of a graphic, proceed as follows:

1. Click on the graphic you want to adjust.

2. Click on the " Adjust graphic width" button in the "Premium Layout" group on the "*Premium Layout" tab.
   → A dialogue opens in which you can choose between different settings for the graphic.

3. Click on the settings you want for your graphic.
   → The selected settings are applied to the graphic. The graphic settings are applied when transferring from Excel to Word.

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.

Video: Application of a colour scale

A detailed explanation of the individual steps

To assign a colored conditional formatting to table cells:

1. Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.

2. Click on the "Conditional Formatting" button in the "*Premium Layout" ribbon.

3. Select the "Color Scales" submenu from the drop-down menu - and select the desired color scale.
   → The selected cells are now highlighted, depending on the selected formatting scale.

Video: Display of arrow symbols

A detailed explanation of the individual steps

To assign a colored conditional formatting to table cells:

1. Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.

2. Click on the "Conditional Formatting" button in the "Design" ribbon.

3. Select the "Directions" submenu from the drop-down menu - and select the desired arrow constellation.
   → The selected cells are now provided with colored arrows, depending on the selected formatting direction.

4. Switch to the Word document in which the linked table was included.

5. Open the firesys settings and check that the function "Set highlighting" is selected in the group "Table layout and structure" in the tab "Data from Excel".

6. Select the desired table - and execute the function "Update selected object" in the menu band "Contents" in the group "Excel data".
   → The table is now updated and the corresponding conditional formatting with is applied to the table.

Video: The use of conditional formatting with font adaptations

A detailed explanation of the individual steps

To assign a colored conditional formatting to table cells:

1. Open the worksheet in Excel and select the cells to which you want to apply conditional formatting.

2. Click on the "Conditional Formatting" button in the "Design" ribbon.

3. Select the "Cell highlighting rules" submenu from the drop-down menu - and select the desired criterion.
   → A dialog opens where you can specify the behavior of the conditional formatting more precisely.

4. Select the "custom format" option in the right-hand selection dialog.

5. In the dialog that now opens, select the desired font to be used when the conditional formatting is displayed.

6. Save the Excel document and switch to Word.

7. Make sure that the setting "Font color" is activated in the group "Data from Excel" in the submenu "Table design and structure" in the firesys settings.

8. Execute the "Update" function in the "Excel Data" group in the "*Contents" menu band.
   → The table is updated and the conditional formatting is applied to the table.

.

See also

The Premiumlayout in Word
Overview of the layout manager
Update Premium Layout

Further contents

→ firesys website
→ Customer area
→ YouTube