How to easily transfer Excel content to Word 2016

There are many ways to copy Excel data into Word while preserving the layout. Let's learn with TipsMake the easiest and most effective steps to transfer Excel content to Word 2016.

Convert Excel content to Word for easy editing and printing. This article shows two simple ways to do it in Word 2016.

1. Use Paste Special to keep the formatting

Step 1: From an available content on Excel 2016, you proceed to select the parts that need to copy the content.

How to easily transfer Excel content to Word 2016 Picture 1How to easily transfer Excel content to Word 2016 Picture 1

Then right-click on it and select copy.

How to easily transfer Excel content to Word 2016 Picture 2How to easily transfer Excel content to Word 2016 Picture 2

Step 2: Next, you switch to Word 2016, open a new file, or you place the cursor in the part where you want to copy the content. Continue to click on Paste . And select Paste Special.

How to easily transfer Excel content to Word 2016 Picture 3How to easily transfer Excel content to Word 2016 Picture 3

Step 3: When the notification window appears, you customize and select Microsoft Excel Worksheet Object. Finally, click the OK button to complete.

How to easily transfer Excel content to Word 2016 Picture 4How to easily transfer Excel content to Word 2016 Picture 4

And finally you customize Word 2016 to your liking.

How to easily transfer Excel content to Word 2016 Picture 5How to easily transfer Excel content to Word 2016 Picture 5


2. Paste the content normally and align it with AutoFit

Step 1: You also proceed as step 1 of method 1.

Step 2: Open the Word file you want to paste and press Ctrl + V on your keyboard.

Step 3: Adjust the spreadsheet to automatically fit the page.

Click on any cell in the table -> then select the Layout Tab -> Select the AutoFit command -> Select AutoFit Window as shown below.

How to easily transfer Excel content to Word 2016 Picture 6How to easily transfer Excel content to Word 2016 Picture 6

Another way to select the AutoFit Windows command is to right-click on the four-arrow icon of the table then right-click -> select AutoFit -> Select AutoFit Window

Next, drag the columns in the table to make it more pleasing to the eye and beautiful.

How to easily transfer Excel content to Word 2016 Picture 7How to easily transfer Excel content to Word 2016 Picture 7

Converting Excel files to Word or PDF is a common need, making it easier to store and share data. There are many ways to do this conversion, from using software to online tools.

When converting Excel to PDF, you can choose specialized software to ensure data security or use online services if you need to do it quickly.

5 ★ | 2 Vote