cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NewPower
New Member

Drag copy Excel formulas

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.

 
 
4 REPLIES 4
fraenK
Super User
Super User

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
Regular Visitor

Hello,

 

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

 

Thank you,

Gelareh

MichaelAnnis
Resident Rockstar
Resident Rockstar

Activate cell in Excel Worksheet

Send Keys {Control}(c)

Select cells in Excel worksheet

Send Keys {Control}(v)

VJR
Memorable Member
Memorable Member

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.

 

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Top Solution Authors
Users online (2,234)