Converting an Excel File to Word: 15 Steps (with Pictures)

Table of contents:

Converting an Excel File to Word: 15 Steps (with Pictures)
Converting an Excel File to Word: 15 Steps (with Pictures)
Anonim

Do you want to convert an Excel document to a Word document? Excel does not have a function for converting an Excel file to a Word file and Word cannot open Excel files directly. But an Excel table can be copied and pasted into Word and then saved as a Word document. Read this guide to learn how to insert an Excel table into a Word document.

Steps

Method 1 of 2: Copying and pasting Excel data into Word

Convert Excel to Word Step 1

Step 1. Copy the Excel data

In Excel, select the content you want to move to Word by clicking and dragging, then press Ctrl + C.

  • Press Ctrl + A to select all data in a chart, then press Ctrl + C.
  • You can also click the Start menu in Excel and then click Copy.
  • If you have a Mac, press ⌘ Command + C to copy.
  • In addition to copying and pasting Excel data, you can also paste charts from Excel into Word.
Convert Excel to Word Step 2

Step 2. Paste your Excel data into Word

In the Word document, move the cursor to where you want to place the table and press Ctrl + V. The table will now be pasted into Word.

  • You can also click the Home tab and then Paste.
  • If you have a Mac, press ⌘ Command + V to paste.
Convert Excel to Word Step 3

Step 3. Choose your paste option

In the bottom right corner of the table, click Paste Options for the various options for pasting the data.

If you don't see the Paste Options button, you haven't activated it. To do this, go to File > Options > Advanced. Under Cut, copy, and paste, click the Show buttons for paste options check box to activate this feature

Convert Excel to Word Step 4

Step 4. Click Keep Source Formatting to use the Excel table style

Convert Excel to Word Step 5

Step 5. Click Use Target Styles to use Word's style for the table

Convert Excel to Word Step 6

Step 6. Create a linked Excel table

Word has a feature that allows you to create links to other Office files. This means that if you make a change in the Excel file, the copied table will be updated in Word. Click Keep linking and source formatting or Link and use target styles to create a linked Excel table.

These two options correspond to the style sources of the other two paste options

Convert Excel to Word Step 7

Step 7. Click Keep Text Only to paste the Excel data, without any formatting

When you use this option, each row will have its own paragraph, with the column data separated by tabs

Method 2 of 2: Inserting an Excel chart into Word

Convert Excel to Word Step 8

Step 1. In Excel, click a chart to select it and then press Ctrl + C to copy it.

Convert Excel to Word Step 9

Step 2. In Word, press Ctrl + V to paste the diagram.

Convert Excel to Word Step 10

Step #3. Choose your paste options

In the bottom right corner of the table, click Paste Options.

Unlike pasting Excel data, when pasting a chart, there are two different sets of options to choose from. Chart data options and formatting options

Convert Excel to Word Step 11

Step 4. Click Chart (linked to Excel data) so that the chart will be updated when the Excel file is updated

Convert Excel to Word Step 12

Step 5. Click Excel Excel Chart (whole workbook) to open the Excel file from the chart itself

To open the Excel file from the chart, right click on the chart, then click Edit data. The source file of will be opened

Convert Excel to Word Step 13

Popular by topic