Announcements
[Power Automate Desktop] Without using a loop, how can I fill a range of cells in excel with one particular value?
Hi @reginaldbal This sequence is not beautiful by any means but it works.Suppose you want to fill A1 to A6 with value A:1. 'Launch Excel' with a blank sheet2. 'Write to Excel worksheet' write in A1 (row=1, column=1) the value A3. 'Copy cells from Excel worksheet' copy cell A1 (row=1, column=1)4. 'Select cells in Excel worksheet': select the remaining range you want to fill. In our example it's A2 to A6 (row=2, column=1 to row=6, column=1)5. 'Focus window', class= XLMAIN (in order to use send keys properly)6. 'Send keys' {LControlKey}({V}) (this sends Ctrl+V)
Yasunm02, thank you, works with formulas also!
Garth
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 664
Haque 460
Valantis 357
