Have you ever been in a situation where you needed to quickly convert an Excel document into a Word document, but could not find an easy solution. In some cases, you may want to present your Excel data in a report format, but find it challenging to move data from sheets to pages.
Don’t worry! You have come to the right place. In this article, I will show you two easy ways to convert Excel to Word.
You’ll Learn:
Watch our video on how to convert Excel to Word
Note: You can select the whole Excel table by clicking on the small triangle in the top left corner or by using the keyboard shortcut Ctrl + A.
Now, open an empty or existing Word document.
Right-click on the destination and click on Paste. Or, you can use the keyboard shortcut Ctrl + V.
This copies the data from the Excel sheet to the Word document.
You can now save the file as a Word document either by clicking on Ctrl + S or by navigating to File > Save. Then choose the destination and save the Word file.
While right-clicking on the destination to paste the contents, the paste function has some options enabled to it. They help in choosing our preference and formatting on how to copy the content to the Word file.
Using the first option, Keep Source Formatting pastes the content in the same format you have copied it from.
The second option, Use Destination Styles pastes the content onto the destination format.
The third (Link & Keep Source Formatting) and fourth (Link & Use Destination Styles) options are pretty much similar to the first and second options, respectively. These options are used to link the contents you copied from the Excel file onto a Word document. All the changes made in the content in Excel will be reflect in the Word document.
The fourth option Picture is used to paste the copied table as an image. Thereby, it cannot be changed or altered.
Finally, using the fifth option Keep Text Only pastes the copied table as text. This formatting option just pastes the text, without border center or tables,
Note: You can also paste the content onto a Word file by using the Paste option under Home > Clipboard. It also bears the same options to paste the content based on your formatting and preferences.
Also Read:
This is another easy method to convert an Excel file to a Word file.
Open a Word document.
Click on Insert in the menu bar. Under Text, click on Object.
This opens up a dialog box. Click on Create from File.
Choose the Excel document to be converted to a Word file and click on Okay.
Note: Check the Link to File checkbox to automatically update the data in the Word file. That is if any changes are made to the original Excel file the same changes will get reflected in the Word document.
This inserts and links the Excel file into the Word document.
Now, you can save the file as a Word document. Go to File > Save and save the file, or click on Ctrl + S to save the file on your device.
Suggested Reads:
In this article, we saw two easy ways to convert content from an Excel file into a Word file. Use the Copy and Paste method to choose the formatting of the copied text, and use the Insert method to insert the Excel file onto the Word file. Choose the method which suits you best.
Please visit our free resources centre for more high-quality Excel guides.
Ready to take the next step and hone your Excel skills?
Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advanced Excel courses with in-depth training modules.
To provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Functional Always activeThe technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences PreferencesThe technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics StatisticsThe technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing MarketingThe technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
Accept Deny View preferences Save preferences View preferences Manage ConsentTo provide the best experiences, we use technologies like cookies to store and/or access device information. Consenting to these technologies will allow us to process data such as browsing behavior or unique IDs on this site. Not consenting or withdrawing consent, may adversely affect certain features and functions.
Functional Functional Always activeThe technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network.
Preferences PreferencesThe technical storage or access is necessary for the legitimate purpose of storing preferences that are not requested by the subscriber or user.
Statistics StatisticsThe technical storage or access that is used exclusively for statistical purposes. The technical storage or access that is used exclusively for anonymous statistical purposes. Without a subpoena, voluntary compliance on the part of your Internet Service Provider, or additional records from a third party, information stored or retrieved for this purpose alone cannot usually be used to identify you.
Marketing MarketingThe technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes.
