Design Your Worksheets

Available from Version: -

Operating System: Windows

empower^® Add-in: Sheets

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 1, “Button Library”). The library opens.	Figure 1. Button Library
In the library, navigate to the section Corporate Design Templates (Figure 2, “Section Corporate Design Templates – Table Style Sets” (1)). Then, navigate into the section Table Style Sets (Figure 2, “Section Corporate Design Templates – Table Style Sets” (2)).	Figure 2. 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 3, “Button Format as Table”). The category Custom is added to the styles.	Figure 3. 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 1, “Button Library”). The library opens.
In the library, navigate to the section Corporate Design Templates (Figure 4, “Section Corporate Design Templates – Cell Style Sets” (1)). Navigate into the section Cell Style Sets (Figure 4, “Section Corporate Design Templates – Cell Style Sets” (2)).	Figure 4. 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 5, “Button Cell Styles”). The category Custom is added to the styles.	Figure 5. 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 1, “Button Library”). The library opens.
In the library, navigate to the section Corporate Design Templates (Figure 6, “Section Corporate Design Templates – Table Sizes” (1)). Navigate into the section Table Sizes (Figure 6, “Section Corporate Design Templates – Table Sizes” (2)).	Figure 6. 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 7, “Button Elements”) to expand the drop-down menu.	Figure 7. Button Elements
Select the option Tables (Figure 8, “Load Table Size Sets” (1)), then select the option Table Sizes (Figure 8, “Load Table Size Sets” (2)). Select the option Load table size set (Figure 8, “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 8. 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 9, “Section Corporate Design Templates – Charts Styles” (1)). Navigate into the section Chart Styles (Figure 9, “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 9. 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 10, “Switch Rows and Columns” (1)). Select the option Charts. Then select the option Switch Row/Column (Figure 10, “Switch Rows and Columns” (2)).	Figure 10. 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