How to Convert Excel to Word

Copy and paste Excel data into Word

How to Convert Excel to Word Picture 1

Copy Excel data. In Excel, click and drag to select the content you want to save into the Word document, then press Ctrl + C.

Press Ctrl + A to select all the data in the chart, then press Ctrl + C.

You can also click the Edit menu, then choose Copy.

If you're on a Mac, press ⌘ Command + C to copy.

In addition to copying and pasting Excel data, you can also copy and paste Excel charts into Word.

How to Convert Excel to Word Picture 2

Open the Word program, paste the Excel data in. In the Word document, move the cursor to the location where you want to paste the excel sheet, then press Ctrl + V. So the excel sheet has been pasted into Word.

You can also click the Edit menu, then choose Paste.

On a Mac, press ⌘ Command + V to perform the paste.

How to Convert Excel to Word Picture 3

Select the paste option. In the lower-right corner of the table, click the Paste Options button to view various paste options.

If you do not find the Paste Options button, your device has not enabled this feature. To activate, go to Word Options, select Advanced. Under Cut, Copy, and Paste, check Show Paste Options buttons to add features.

How to Convert Excel to Word Picture 4

Click the Keep Source Formatting button to use the Excel table style.

How to Convert Excel to Word Picture 5

Or select the Match Destination Table Style button (According to the target program's format) to use the Word table style.

How to Convert Excel to Word Picture 6

Create a linked table with Excel. In Word, there is a feature that allows you to create links to other Office files. That is, if you make changes to the Excel file, the copied table in Word will also be updated. Click the Keep Source Formatting and Link to Excel button (Keep the source formatting and link to Excel) or the Match Destination Table Style and Link to Excel button (According to the target program format and link to Excel) to create a linked table with Excel.

These two options match the format source for the other two paste options.

How to Convert Excel to Word Picture 7

Click the Keep Text Only button to paste the Excel content without any formatting.

When you use this option, each row will be on its own paragraph, with columns of data separated by tabs.

Insert an Excel chart into Word

How to Convert Excel to Word Picture 8

In Excel, click on the chart to select, then press Ctrl + C to copy.

How to Convert Excel to Word Picture 9

In Word, press Ctrl + V to paste the chart into Word.

How to Convert Excel to Word Picture 10

Select paste option. In the bottom right corner of the table, click the Paste Options button to see different paste options.

Unlike pasting Excel data, for charts there are two different sets of options to choose from. You can change the chart's data options, as well as formatting options.

How to Convert Excel to Word Picture 11

Click on Chart (linked to Excel data) to update the chart when the Excel file is updated.

How to Convert Excel to Word Picture 12

Click the Excel Chart (entire workbook) button to allow opening the Excel file from the chart.

To open an Excel file from a chart, right-click the chart, then select Edit data. And the Excel source file will be opened.

How to Convert Excel to Word Picture 13

Click Paste as Picture to paste the chart as a static image and the chart will not be updated when the Excel file changes.

How to Convert Excel to Word Picture 14

Click Keep Source Formatting to use the Excel table style.

How to Convert Excel to Word Picture 15

Select the Use Destination Theme button to use the Word table style.

David Pac

Update 24 February 2022