Instructions to copy data from Excel to Word retain the format

Sometimes at work you want to convert table data from excel to word, but when the copy to word is formatted or exceeds the frame in the word. The following article details how to copy data from excel to word to keep the format.

Step 1: Open the Excel file containing the data to copy -> Highlight the data you want to copy -> Right-click and select Copy .

Instructions to copy data from Excel to Word retain the format Picture 1

Step 2: Open the Word file you want to insert data from Excel -> place the cursor at the position you want to paste -> on the HOME tab -> Paste -> Paste Special .

Instructions to copy data from Excel to Word retain the format Picture 2

Step 3: A dialog box appears, select Paste -> Microsoft Excel Worksheet Object -> OK .

Instructions to copy data from Excel to Word retain the format Picture 3

1. In case you want to paste quickly and keep the format

Right-click -> Choose the 1st, 2, 3, 4 . features of Paste Special .

Instructions to copy data from Excel to Word retain the format Picture 4

You can choose Paste to keep the format using features 1, 2, 3 . And you manipulate editing right on the pasted paste.

2. Get only the textual content to Paste

Select the 6th feature Keep Text Only (T) .

Instructions to copy data from Excel to Word retain the format Picture 5

3. Paste with image format and you can not manipulate, edit the data just pasted

Use the fifth Picture feature (U) .

Instructions to copy data from Excel to Word retain the format Picture 6

Above are some ways to copy data from Excel to Word hoping you will apply this feature often.

Good luck!

Samuel Daniel

Update 19 May 2020

You should read it

May be interested

Instructions for using the Networksday function in excel
the following article details the calculation of workdays using networksday.
Normalize string when pressing Enter key in Excel
the following article will guide in detail how to use functions to normalize strings when pressing the enter key in excel. this function will remove spaces at the beginning and end of the line, delete two consecutive white space characters between words.
Instructions to merge multiple Excel files into 1 File
detailed instructions on how to combine multiple excel files into a single file with macro.
Count the number of Saturdays and Sundays in any period in Excel
instructions to count the number of saturdays and sundays in any period in excel. the following article details how to calculate the number of 7th, sunday or any day in excel in many ways.
Summary of data from multiple Sheets in Excel
the following article details how to aggregate data from multiple sheets in excel.
Split numbers from strings in Excel
in the process of working with excel, i have encountered some cases that require separating only the fraction in a given string, now this post shares with you how to do this. the following article details how to separate numbers from a given string in excel.