How to Convert Excel to Word

Copy the Excel data., In Word, paste the Excel data., Choose your paste option., Click Keep Source Formatting to use the Excel table style. , Click Match Destination Table Style to use the Word table style. , Create a linked Excel table., Click Keep...

8 Steps 2 min read Medium

Step-by-Step Guide

  1. Step 1: Copy the Excel data.

    In Excel, click and drag to select the content you'd like to put in the Word document, and then press Ctrl + C.

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

    You can also click the Edit menu, and then click 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.
  2. Step 2: In Word

    In the Word document, move the cursor to the location you'd like your table, and then press Ctrl + V.

    The table is pasted into Word.

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

    If you're on a Mac, press ⌘ Command + V to Paste. , In the bottom right corner of the table, click the Paste Options button to see the different paste options.

    If you don't see the Paste Options button, you don't have it enabled.

    To enable it, go to Word Options, click Advanced.

    Under Cut, Copy, and Paste, click the Show Paste Options buttons check box to add a check.,,, Word has a feature that allows it to create links to other Office files.

    This means that if you make a change to the Excel file, the copied table will be updated in Word.

    Click Keep Source Formatting and Link to Excel or Match Destination Table Style and Link to Excel to create a linked Excel table.

    These two options match the style sources for the other two paste options. , When you use this option, each row will be on its own paragraph, with tabs separating the column data.
  3. Step 3: paste the Excel data.

  4. Step 4: Choose your paste option.

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

  6. Step 6: Click Match Destination Table Style to use the Word table style.

  7. Step 7: Create a linked Excel table.

  8. Step 8: Click Keep Text Only to paste the Excel content without any formatting.

Detailed Guide

In Excel, click and drag to select the content you'd like to put in the Word document, and then press Ctrl + C.

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

You can also click the Edit menu, and then click 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.

In the Word document, move the cursor to the location you'd like your table, and then press Ctrl + V.

The table is pasted into Word.

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

If you're on a Mac, press ⌘ Command + V to Paste. , In the bottom right corner of the table, click the Paste Options button to see the different paste options.

If you don't see the Paste Options button, you don't have it enabled.

To enable it, go to Word Options, click Advanced.

Under Cut, Copy, and Paste, click the Show Paste Options buttons check box to add a check.,,, Word has a feature that allows it to create links to other Office files.

This means that if you make a change to the Excel file, the copied table will be updated in Word.

Click Keep Source Formatting and Link to Excel or Match Destination Table Style and Link to Excel to create a linked Excel table.

These two options match the style sources for the other two paste options. , When you use this option, each row will be on its own paragraph, with tabs separating the column data.

About the Author

V

Virginia Bailey

Enthusiastic about teaching creative arts techniques through clear, step-by-step guides.

70 articles
View all articles

Rate This Guide

--
Loading...
5
0
4
0
3
0
2
0
1
0

How helpful was this guide? Click to rate: