Answered

Drag copy Excel formulas

(0) Share

Report

Posted on by NewPower

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.

Thanks.

Categories:

Power Automate Desktop

All responses (9)

Answers (1)

Sort by

fraenK 2,125 on at

Like
a
(1)

Report
Copy link

Link copied!

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
gkarbaschi 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Have you found a way to drag-copy? I use loops but it is much more time consuming.

Thank you,
Gelareh
Verified answer

MichaelAnnis 5,727 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

Activate cell in Excel Worksheet
Send Keys {Control}(c)
Select cells in Excel worksheet
Send Keys {Control}(v)
VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @NewPower

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.
PAD: Paste into multiple cells and Drag Formula - Power Platform Community (microsoft.com)
Please cast your vote for faster execution of this idea.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

This worked perfectly, thanks!
LucianoGomesBR on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, it works perfectly.
Thanks, Michael.
mcnemare1 214 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @MichaelAnnis , I tried to use the method you recommended. But every time I end up with the values / formula not committing.

If I end the flow and press [Enter] on my keyboard, then all the formulas fill in for the rows witching this column.

Am I missing something?

flow
MichaelAnnis 5,727 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

The text I used below is 100% exactly what you need. You are sending Control (Hold) + the sequence open bracket - Shift + c - close bracket and then release Control. This isn’t what you want.

so, just use {Control}(c) and same thing for {Control}(v). Make sure they are lower case, otherwise it will be pressing shift.

good luck.
mcnemare1 214 on at

Like
a
(0)

Report
Copy link

Link copied!

This worked really well.