Skip to main content

Excel Automation ribbon and side panel

The Excel Automation ribbon provided by AutoToolit for Office offers quick access to the most essential automation elements in Excel templates:

  • Export sections are areas in the Excel workbook, that can be used for exporting to PowerPoint or for sending by e-mail
  • Parameters are Excel cells, slicers, pivot table filters or data source parameters that can be changed automatically. They can also be made available in PowerPoint for selection by the user.
  • Presets are sequences of automation steps which can be performed automatically.

This is the new Auto tab you will see in Excel after AutoToolit for Office is installed:

Excel Automation ribbon in AutoToolit for Office

Content group#

The Content group contains the quick actions you need to set up the Excel template:

  • Add Section creates a new export section based on the currently selected Excel cells
  • Add Parameter create a new selection parameter based on the currently selected Excel cell
  • Side Panel opens or closes the side panel to define more detailed properties of export sections or parameters

Automation Side panel#

In the Automation side panel you can change all settings for export sections and parameters. It also provides access to the application settings and an easy way to get help and support.

Excel Automation side panel in AutoToolit for Office

Automation group#

The Automation group in the ribbon toolbar contains the quick actions you need to set up and run Excel automations: