CODEWITHSUNDEEP
excelms-word
Bem
Bem

Reputation: 11

How to copy excel table with formatting into word - Manual Operation

As shown in the figure, I have the table below in Excel with conditional formatting (arrow symbols in each cell)

Image 1: In Excel

I want to copy the same table from Excel to Word with conditional formatting. While copying and pasting to Word, the arrow in each cell is missing. The same is shown in the image below. Please tell me how to copy and paste the same as the excel table shown in image 1.

Image 2: After copying and pasting from Excel to Word

Upvotes: 0

Views: 496

Answers (1)

Scinana
Scinana

Reputation: 402

Have you tried to use Paste Special:

enter image description here

and then use the Microsoft Excel Worksheet Object option? That let me copy the icons from Excel into Word.

enter image description here

For example:

Excel screenshot:

enter image description here

Word screenshot, after pasting as per the instructions above:

enter image description here

Note that if you double click on the pasted content in Word, it will open up an Excel editable object. You can edit the formatting here.

enter image description here

Upvotes: 0

Related Questions