Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities - Lets Get Started!
News and Announcements icon
Community site session details

Community site session details

Session Id : G+62b9rUPHQjeVGZyaWwwZ
Power Platform Community / Forums / Power Automate - Power Automate Desktop / How to merge a cell in...
Power Automate - Power Automate Desktop
Unanswered

How to merge a cell in excel using Power Automate Desktop

Like (0) ShareShare
ReportReport
Posted on 8 Feb 2024 09:43:09 by Shanmugapriya09 10

I need output in the below format in excel, how to perform using Power Automate desktop

 

Shanmugapriya09_1-1707385373827.png

 

 

 

  • kinuasa Profile Picture
    kinuasa 781 Most Valuable Professional on 09 Feb 2024 at 07:22:02
    Re: How to merge a cell in excel using Power Automate Desktop

    Hi,
    Power Automate for desktop does not provide a dedicated action for merging cells.
    For stable processing, I recommend using a script only for the cell merging part as shown below.

     

    1. Open the workbook. (Launch Excel or Attach to running Excel action)
    2. Activates a specific worksheet. (Set active Excel worksheet action)
    3. Selects a range of cells or a named cell in the active worksheet. (Select cells in Excel worksheet action)
    4. Execute the following script to merge the cells. Please change the workbook path in the code. (Run VBScript action)
    With GetObject("C:\hoge\hoge.xlsx").Application
 .DisplayAlerts = False
 .CommandBars.ExecuteMso "MergeCells"
 .DisplayAlerts = True
End With

    or

    With GetObject(, "Excel.Application").Application
 .DisplayAlerts = False
 .CommandBars.ExecuteMso "MergeCells"
 .DisplayAlerts = True
End With

     

    Regards,
    kinuasa

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.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities - Lets Get Started!

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Automate - Power Automate Desktop

#1
eetuRobo Profile Picture

eetuRobo 62 Super User 2025 Season 1

#2
Nived_Nambiar Profile Picture

Nived_Nambiar 18 Super User 2025 Season 1

#3
CU12050101-0 Profile Picture

CU12050101-0 12

Overall leaderboard

Featured topics

Flows are not visible for users who sign in with their personal accounts
List of actions cheat sheet for Power Automate Desktop

Product updates

Microsoft Power Platform Community release plans