Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : Es44gxaTtANoZdftm+wDeN
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 779 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

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,004 Most Valuable Professional

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