Merge Excel cells in Faster way

excel

#1

Hi,
Currently, I am trying to merge excel cell using excel shortcuts but it’s taking a lot of time to perform each merge.
The idea is to merge 6 cells together and perform the same activity 12 times horizontally and 15 times vertically.
Below is just a sample of the merge:
I would like to know if there is any faster way to perform the same?
image

Thanks,
Anjali


#2

you can write a macro to merge cells and run macro from UiPath


#3

Hi @anjalimishra
Please do see the below post

Thanks
Ashwin S


#4

Hi @anjalimishra,

Please take a look this activity. It has facility to merge and un-merge the cells.

Regards
Balamuruga.S


#5

I tried opening MergeCells zip but it says “activity could not be loaded because of errors in the XAML”.


#6

Hi @anjalimishra

Sorry I have attached the package that I have configured in the local. Again I will do the upload .

File : MergeCells.zip (8.7 KB)

Note : I have updated in the package thread also.

Thank you
BALAMURUGAN.S


#7

Thanks I have resolved it by invoking VB code
image


#8