How to copy excel from one sheet to another without changing formatting

Help Activities
, , ,
1

Hi all,
How to copy excel from one sheet to another sheet without changing the format. How to do this, please guide me on this.
Please check the below attached screenshot.
image
data present in sheet1 same need to copy to sheet2.

2

Hi @lakshmi.mp

Try this way:

image
image829×964 39.5 KB

Input:
image

Output:
image

Hope it helps!!

3

@Parvathy ,
input:
image

Output:
image
like this i am getting, column width is not same and for department cell no border, what changes need to be done.

4

Hi @lakshmi.mp

Try this way:

image
image829×1276 55.2 KB

Hope it helps!!

5

@Parvathy , please check this screenshot
image
like this i am getting.

6

Hi @lakshmi.mp

Can you please share the excel file.

Regards

7

Employee details.xlsx (9.5 KB)
please check the attached excel.

8

@lakshmi.mp,

If you want to copy whole data from one sheet to another, there is more quick option that is Copy Sheet Activitie

This will copy the whole sheet with all formatting and all.

Thanks,
Ashok :slight_smile: