Share via

Copy merged rows from Excel to Word table

Anonymous
2022-08-29T06:31:53+00:00

I have to copy some rows of data to a Word table. The data is in Excel and in the format that is needed in Word.

I had merged the cells in Excel corresponding to the formatting needed in the Word formatting above.

How can I copy the rows of data from Excel over to the Word table in the above format?

Microsoft 365 and Office | Word | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2022-08-29T09:49:38+00:00

Dear Sajit,

Good day! Thank you for posting your query in our community.

Based on your description, my understanding is that you want to copy Excel merged cells into Word with the same format.

You can try to paste with the option to "Keep Source Formatting" like below:

If my understanding is wrong, please feel free to post back.

Sincerely,

Jazlyn | Microsoft Community Moderator

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-09-05T09:09:21+00:00

    Thanks Jazlyn, It works.

    I think I was trying to copy to a Word table that had merged cells but I had not made all of the merges in the excel to match for the copy to fit.

    Was this answer helpful?

    0 comments