Unanswered

How to merge 2 or more cells in the excel

(0) Share

Report

Posted on by gottapu_harish

I am trying to merge the 2 cells in the excell using power automate desktop. can someone tell me which action I need to use.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (0)

Sort by

MichaelAnnis 5,727 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

I would "populate text field" in the UI in the top left:

Send keys for the cell you want (the left cell) and Enter...example: A5{Enter}

Send keys for {Shift}({Right}) to simulate Shift + Right Arrow

Send Keys for Merge Cells which is {Alt}()hmc NOTE: the excel hotkey menu is slower than PAD, so change the delay from 10 per keystroke to 100

Alt hmc gets merge and center, you can replace the c with a or m for different actions like below.

Best of luck!

Was this reply helpful? Yes No
mohamad1996 2 on at

Like
a
(0)

Report
Copy link

Link copied!

you can select range of cells and send key with shortcut text to send {ALT}{{H}{M}{C}}, or you can record Macro excel and then run it from power automate desktop

I have wrote blog regarding to merge excel cells take a look here

Was this reply helpful? Yes No
kinuasa 801 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi,
I suggest that after selecting the cells using the 'Select cells in Excel worksheet' action, run the following script using the 'Run VBScript' action.

GetObject("%WorkbookPath%").Application.CommandBars.ExecuteMso "MergeCells"

Regards,
kinuasa

Sample Flow:
Excel.SelectCellsFromExcel.SelectCells Instance: ExcelInstance StartColumn: $'''B''' StartRow: 2 EndColumn: $'''D''' EndRow: 4 Scripting.RunVBScript VBScriptCode: $'''GetObject(\"%WorkbookPath%\").Application.CommandBars.ExecuteMso \"MergeCells\"''' ScriptOutput=> VBScriptOutput

Was this reply helpful? Yes No