The "Activate Cells in Excel Worksheet" Action is used to activate (select) specific a cell on an Excel worksheet in Power Automate Desktop.
This action allows you to specify the a cell you wish to activate. You may use this action to determine the active cell in an Excel file before performing any processing with a macro or Power Automate Desktop on the active cell.
Note that Excel must be installed with Power Automate Desktop in order to use this action.
- 1. How to use
- 2. For those who want to learn Power Automate Desktop effectively
- 3. Links
How to use
Specify the target Excel file.
Specify the cell position to be activated.
Select either "Absolutely specified cell" or "Relatively specified cell".
Absolutely specified cell
Specify columns and rows numerically. Specifying 1 for both makes cell A1 active.
Relatively specified cell
Specify how much to move from the currently active position.
Select up, down, left, or right for "Direction", and specify the number of cells to be moved for "Offset from active cell".
One action is one direction, so two actions are required for diagonal movement.
Cells with name
Added in the August 2023 update.
Specified by the name of the named cell range.
It does not exist in this action.
Error handling is performed as needed.
If a cell is incorrectly specified or If the selection fails for any reason, an error occurs.
For those who want to learn Power Automate Desktop effectively
The information on this site is now available in an easy-to-read e-book format.
Or Kindle Unlimited (unlimited reading).
You willl discover how to about basic operations.
By the end of this book, you will be equipped with the knowledge you need to use Power Automate Desktop to streamline your workflow.