In Excel, using Power Automate Desktop, how do I drag-copy a formula from one cell (or a range of cells) to multiple cells?
The built-in "Paste cells to Excel worksheet" action only pastes to one cell. I would like to paste the same formula to a range of cells at once, which is what I do by dragging if I don't use Power Automate.
Do you mean to all cells in a column? This is done automatically by Excel in a defined table.
Otherwise you could loop through multiple cells to add formulas or write a table variable with https://docs.microsoft.com/en-us/power-automate/desktop-flows/actions-reference/excel#writetoexcel
The solution from MichaelAnnis is perfect in this situation.
This is a must-have feature in PAD for Excel.
Therefore I have submitted an idea around the same.
Please cast your vote for faster execution of this idea.