Design Your Worksheets

Available from Version: -

Operating System: Windows

empower^® Add-in: Template Management

To design your worksheets, you can use elements from the empower^® Library.
For example, you can insert corporate design compliant table and cell styles as well as chart templates from your Corporate Design Templates.

Note

Files that are protected either by the Office built-in document protection or by Microsoft Purview Information Protection cannot be processed by empower^®.

Files with Microsoft Purview Information Protection labels similar to Public can be processed.

For further information regarding Microsoft Purview Information Protection, see Protect your sensitive data with Microsoft Purview.

Insert and Use Table and Cell Styles

You can use custom and corporate design compliant cell and table styles in empower^® to format cells and tables.
To download a table style to your workbook, follow the following steps:
Navigate to the group Start and click on the button Library (Figure 1705, “Button Library”). The library opens.	Figure 1705. Button Library
In the library, navigate to the section Corporate Design Templates (Figure 1706, “Section Corporate Design Templates – Table Style Sets” (1)). Then, navigate into the section Table Style Sets (Figure 1706, “Section Corporate Design Templates – Table Style Sets” (2)).	Figure 1706. Section Corporate Design Templates – Table Style Sets
Find the table style set you want to insert and double-click it. The table style set is downloaded to your workbook.
To apply a table style to a selected table, follow the following steps:
Select the table you want to format.
Navigate to the group Formatting and click on the button Format as Table (Figure 1707, “Button Format as Table”). The category Custom is added to the styles.	Figure 1707. Button Format as Table
Select the custom style you want to apply to the table. The table format is changed accordingly.
To download a cell style to your workbook, follow the following steps:
Navigate to the group Start and click on the button Library (Figure 1705, “Button Library”). The library opens.
In the library, navigate to the section Corporate Design Templates (Figure 1708, “Section Corporate Design Templates – Cell Style Sets” (1)). Navigate into the section Cell Style Sets (Figure 1708, “Section Corporate Design Templates – Cell Style Sets” (2)).	Figure 1708. Section Corporate Design Templates – Cell Style Sets
Find the cell style set you want to insert and double-click it. The cell style set is downloaded to your workbook.
To apply a cell style to a selected cell, follow the following steps:
Select the cell you want to format.
Navigate to the group Formatting and click on the button Cell Styles (Figure 1709, “Button Cell Styles”). The category Custom is added to the styles.	Figure 1709. Button Cell Styles
Select the custom style you want to apply to the table. The cell format is changed accordingly.

Insert and Use Table Sizes

You can use predefined table sizes in empower^® to format a table.
To download them to your workbook and apply them to an existing table, follow the following steps:
Select the table you want to apply a table size to.
Navigate to the group Start and click on the button Library (Figure 1705, “Button Library”). The library opens.
In the library, navigate to the section Corporate Design Templates (Figure 1710, “Section Corporate Design Templates – Table Sizes” (1)). Navigate into the section Table Sizes (Figure 1710, “Section Corporate Design Templates – Table Sizes” (2)).	Figure 1710. Section Corporate Design Templates – Table Sizes
Find the table size you want to use and double-click it. The table size is downloaded to your workbook.
To apply a table size to a selected table, follow the following steps:
Select the table you want to resize.
Navigate to the group Insert and click on the button Elements (Figure 1711, “Button Elements”) to expand the drop-down menu.	Figure 1711. Button Elements
Select the option Tables (Figure 1712, “Load Table Size Sets” (1)), then select the option Table Sizes (Figure 1712, “Load Table Size Sets” (2)). Select the option Load table size set (Figure 1712, “Load Table Size Sets” (3)). Find the table size you want to apply to your table and double-click it. The table format is changed accordingly.	Figure 1712. Load Table Size Sets
The table sizes are named by your empower^® Administrators in a meaningful way, so that the names already provide information about the use of the table sizes.
The following values can be predefined for a table size:
Total width of the table Column widths for individual columns
If the number of column widths defined in the table size is greater than the number of columns in the table to be formatted, all selected columns are formatted according to the table size, and any column widths additionally defined in the table size are not applied.
If the number of column widths defined in the table size is less than the number of columns in the table to be formatted, all selected columns are formatted according to the table size. For the remaining columns in the table to be formatted, the total width of the table defined in the table size is subtracted from the column widths already used, and the difference is distributed evenly among the remaining unformatted columns.

Note

In case there are unsaved changes to your current workbook, you are asked to save the workbook to proceed.

If the workbook you are working with is saved in a cloud and you want to add a table size to it, you are informed that no other editors should be working in the file.

Table sizes are available in a workbook after being loaded once you select a range in your open workbook and will be kept in a workbook after saving it.

Use Chart Styles

You can use custom chart templates to illustrate the contents of a table with a chart.
To do so, follow the following steps:
Select the table contents you want to illustrate with a chart.
Navigate to the group Start and click on the button Library. The library opens.
In the library, navigate to the section Corporate Design Templates (Figure 1713, “Section Corporate Design Templates – Charts Styles” (1)). Navigate into the section Chart Styles (Figure 1713, “Section Corporate Design Templates – Charts Styles” (2)). Find the chart style you want to apply use and double-click it. The chart style is used to illustrate the table content.	Figure 1713. Section Corporate Design Templates – Charts Styles
A chart style can be of two types:
with fixed colors with colors that dynamically adapt to the design or color scheme
The fixed color chart styles have the property that the colors used in the chart template are completely adapted to the corporate design and do not change even if the workbook’s color scheme differs from the chart’s colors or if the design of the workbook is changed via Excel (tab Page Layout – Designs).
If you choose a chart style with dynamically changing colors, the colors of the chart will automatically adapt to the workbook’s design/color scheme.
To change the display order in charts for rows and columns, follow the following steps:
Navigate to the group Insert and click on the button Elements to expand the drop-down menu (Figure 1714, “Switch Rows and Columns” (1)). Select the option Charts. Then select the option Switch Row/Column (Figure 1714, “Switch Rows and Columns” (2)).	Figure 1714. Switch Rows and Columns
With this option, you can toggle between assigning the rows and columns to the horizontal and vertical graph axes, depending on the arrangement of the series within a graph. The settings made here affect, among others, the chart title, legend and data point labels.

Note

Chart styles in empower^® can only be applied to Excel charts and not to charts that have been created with empower^®.

Design Your Worksheets

Note

Insert and Use Table and Cell Styles

Insert and Use Table Sizes

Note

Use Chart Styles

Note

Comments