Manage Content in empower®

Available from Version: - 

Operating System: Windows 

empower® Add-in: Sheets

In empower®, you can manage your content in one location.

When you have created new content such as workbooks, you can save this content to the empower® Library.

Once you have saved content to the empower® Library, you can move the content by using the cut, copy and paste actions, rename the content or delete it from the library again.

You can execute these actions if you have the required permissions.

Note

For further information regarding the permission concept, see Permission Concept.

For further information regarding the creation of content in the empower® Library, see Create New Content in Library.

For further information regarding the creation of new workbooks, see Create a New Workbook.

Save Content to the Library

Once you have created new content in Excel, you can save it to the empower® Library.

To do so, follow the following steps:

  1. Select the elements you want to save.

    If you want to save a single object, select the object.

  2. Navigate to the group Start in the empower® Ribbon.

  3. Click on the lower part of the split button Library (Figure 1, “Button Library”).

Figure 1. Button Library

Button Library

  1. In the drop-down menu, click on the option Save (Figure 2, “Option Save”).

    A menu opens.

Figure 2. Option Save

Option Save

  1. In the menu, choose what element type you want to save.

  2. Then, click on the button Save as (Figure 3, “Button Save as”).

    The library opens.

Figure 3. Button Save as

Button Save as

  1. In the library, navigate to the folder in which you want to save the element.

  2. Change the element name.

  3. Click on the button Save (Figure 4, “Button Save in Library”).

Figure 4. Button Save in Library

Button Save in Library

Important

Files that are bigger than 500MB cannot be saved to the empower® Library.

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.

Save and Edit Table Sizes

Label_For_Administrators.svg

If you have already defined a table (column widths, total width) within your workbook, select it to save it and follow the following steps:

  1. Navigate to the group Start in the empower® Ribbon.

  2. Click on the lower part of the split button Library (Figure 5, “Button Library”).

Figure 5. Button Library

Button Library

  1. Click on the option Save (Figure 6, “Option Save”).

Figure 6. Option Save

Option Save

  1. Then click on the option Table Size (Figure 7, “Save Table Size” (1)).

  2. Select the option Save as (Figure 7, “Save Table Size” (2)).

  3. Navigate to the desired storage location, give the table size a name and confirm your selection.

    The table size is saved.

Figure 7. Save Table Size

Save Table Size

If you have not yet defined a table, follow the following steps:

  1. Navigate to the group Insert in the empower® Ribbon and click on the button Elements (Figure 8, “Button Elements”).

Figure 8. Button Elements

Button Elements

  1. Select the option Tables (Figure 9, “Option Tables”).

Figure 9. Option Tables

Option Tables

  1. Then select the option Table Size (Figure 10, “Options in Table Sizes” (1)).

  2. Then select the option Create Table Sizes (Figure 10, “Options in Table Sizes” (2)).

    A new workbook opens.

Figure 10. Options in Table Sizes

Options in Table Sizes

  1. Apply your desired formatting to each column (Figure 11, “Workbook to Define Table Sizes”):

    1. Column A – Name of the table size set

    2. Column B – Name of the table size

    3. Column C – Total width of the table in centimeters (cm)

    4. Column D et sqq. – Individual fixed column widths

    You can define multiple table sizes from the table in the workbook that opens and then upload them as a set to the library.

  2. Save the table size to the empower® Library.

    The workbook closes automatically.

Figure 11. Workbook to Define Table Sizes

Workbook to Define Table Sizes

Note

It is not necessary to manually set an individual column width for each column. The width of all columns that are not manually defined is automatically calculated and set to the total width of the table based on the remaining width.

A brief guide to the available settings can also be found in the workbook that opens.

To edit table sizes, follow the following steps:

  1. Navigate to the group Insert in the empower® Ribbon and click on the button Elements (Figure 8, “Button Elements”).

  2. Select the option Tables (Figure 9, “Option Tables”) and Table size (Figure 12, “Option Manage table sizes” (1)).

  3. Then select the option Manage table sizes (Figure 12, “Option Manage table sizes” (2)).

    The library opens in the section Table sizes.

  4. Select the table size you want to edit and double-click to open it.

    A new workbook opens.

  5. Adjust the table sizes according to your requirements and save it back to the empower® Library.

    1. Keep the table size name to overwrite it.

    2. Change the table size name to create a new table size.

Figure 12. Option Manage table sizes

Option Manage table sizes

Note

If the User Library is enabled in your empower® Environment, you can save table sizes to your User Library.

Set Documents as Default

Label_For_Administrators.svg

If you have been granted admin permissions, you can set a company default template in Excel that will be used for the whole company.

To do so, follow the following steps:

  1. Open the empower® Library.

  1. In the section Corporate Design Templates, navigate to the required subsection Workbook Templates.

  1. Right-click on the template you want to define as the company default.

    A context menu opens.

  1. In the context menu, click on the option Set as default (Figure 13, “Option Set as default”).

    A dialog box opens.

Figure 13. Option Set as default

Option Set as default

  1. Read the message carefully and make sure all users have permissions to access the template.

  2. In the dialog box, confirm the new company-wide default by clicking on the button Yes (Figure 14, “Dialog Box for New Company Default”).

Figure 14. Dialog Box for New Company Default

Dialog Box for New Company Default

The template will now be marked as the Company's Default (Figure 15, “Workbook Template with Label”).

Figure 15. Workbook Template with Label

Workbook Template with Label

To revoke your choice for the company-wide default, right-click on the template and choose the option Remove default (Figure 16, “Option Remove default”).

A dialog box opens.

Figure 16. Option Remove default

Option Remove default

To confirm the process, click on the button Yes (Figure 17, “Dialog Box for Removal of Company Default”).

Figure 17. Dialog Box for Removal of Company Default

Dialog Box for Removal of Company Default

Important

If you set or remove the company default, your changes take effect for all users after the next synchronization and after a restart of Excel.

Note

Alternatively, you can access the options Set as default and Remove default in the navigation bar via the group Selection.

Cut, Copy and Paste Content

You can use the cut, copy and paste actions to create duplicates or to move content from one location in the library to another.

You can cut and paste elements and folders but folders cannot be copied.

You can also select multiple elements at once. However, the selection of elements and folders at the same time is not possible.

To cut out an element, select the element and navigate to the group Clipboard. Then, click on the button Cut (Figure 18, “Button Cut”).

Figure 18. Button Cut

Button Cut

The element is marked as cut out until it is pasted again.

To copy an element, select the element and navigate to the group Clipboard. Then, click on the button Copy (Figure 19, “Button Copy”).

Figure 19. Button Copy

Button Copy

As soon as you have either used the cut or the copy action, the paste action becomes available.

To paste an element to a location in the empower® Library, navigate to this location. Then navigate to the group Clipboard in the navigation bar and click on the button Paste (Figure 20, “Button Paste”).

Figure 20. Button Paste

Button Paste

The element or the folder is pasted to the location.

Note

Alternatively, you can access the options Cut, Copy and Paste via the context menu of elements or folders or use the following keyboard shortcuts for Copy and Paste:

Copy – Ctrl + C

Paste – Ctrl + V

Note

If you paste an element to a folder in which another element with the same name is present, a number in brackets is added to your copy's name.

If you paste a folder to a location in which another folder with the same name is present, both folders keep this same name.

Important

You cannot cut, copy or paste the subsections of the section Corporate Design Templates as a whole. However, you can copy and paste content from these locations to other locations.

Rename Content

To rename an element or a folder, select it in the library. Then, navigate to the group Organize in the navigation bar and click on the button Rename (Figure 21, “Button Rename”).

Figure 21. Button Rename

Button Rename

Type in the new element name (Figure 22, “Rename Element”).

Figure 22. Rename Element

Rename Element

To finish the renaming process and save the new name, either press Enter or select another element.

To cancel the renaming process, press ESC.

If you rename an element in a folder in which another element with the same name is present, a number in brackets is added to the element name.

If you rename a folder in a location in which another folder with the same name is present, both folders keep this same name.

Note

Alternatively, you can access the option Rename via the context menu of elements or folders.

Important

You cannot rename the content of integration folders such as Unsplash, Icons8 or SharePoint but you can rename the integration folder itself.

You cannot rename the subsections of the section Corporate Design Templates. However, you can rename content inside these subsections if you have the required permissions.

Delete Content

To delete content, select it in the library. Then, navigate to the group Organize and click on the button Delete (Figure 23, “Button Delete”).

Figure 23. Button Delete

Button Delete

A dialog box opens.

To confirm the process, click on the button Yes (Figure 24, “Dialog Box for Deletion”).

Figure 24. Dialog Box for Deletion

Dialog Box for Deletion

The element is deleted from the empower® Library.

Important

If you delete a folder, all its content is deleted.

Note

Alternatively, you can access the option Delete via the context menu of elements or folders.

Note

If the feature Recycle Bin has been enabled by your empower® Administrators, you can find deleted content in the recycle bin.

For further information regarding the recycle bin, see Use the Recycle Bin.

Important

You cannot delete integration folders such as Unsplash or Icons8 and their content.

You cannot delete the subsections of the section Corporate Design Templates.

Was this article helpful?

/

Comments

0 comments

Article is closed for comments.