Set active Excel worksheet Action(Power Automate Desktop)


Japanese version.

This action performs sheet selection.

The following action to specify cells in Excel does not specify a sheet, but targets the active sheet.

BGM. Music by

Especially in Excel books with multiple sheets, it is recommended to use Set active Excel Worksheet to
It is recommended to specify the active sheet.

How to use.

Specify the target file in Launch Excel Action or Attach Running Excel Action and drag Set Active Excel Worksheet Action from Excel to the Workspace.

Set parameters.


Excel instance

Specify the target Excel file.

Specify the Variables produced for the Launch Excel Action or the Attach to running Excel Action.

Activate worksheet with

Specify the sheet to be active.

Select either Name or Index as the sheet designation method.


Specify the name of the worksheet to be activated.


Specify the worksheet to be active by its index. The index is a sequential number with the leftmost number as 1.

Variables produced

Not present in this Action.

On error

Error handling is performed as needed.

Can't find worksheet

Error when the specified sheet name does not exist.

Failed to activate worksheet

Errors for other reasons.



Excel Actions.

Examples of Use

Send newsletter. Email one line at a time from an Excel book.

Transcribing from one Excel book to another.

How to get the last business day of the specified month.

How to get the number of business days for a specify month.

How to get the number of business days within a specified period.

How to convert Excel files to CSV files.

How to get the last row and last column of an Excel book.

Create a table of contents for sheet names in an Excel book.

Move to the specified cell in the Excel book.

Delete rows of Excel with specific conditions.

How to delete multiple rows/columns in Excel.