How to Insert an Excel Table into Word

PDF download Download Article
PDF download Download Article

Is there data in your Microsoft Excel sheet that you want to display in a Word document? This wikiHow will teach you how to copy data from your spreadsheet to your Word document using the Microsoft Office desktop suite.

Steps

PDF download Download Article
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/35\/Insert-an-Excel-Table-into-Word-Step-1-Version-3.jpg\/v4-460px-Insert-an-Excel-Table-into-Word-Step-1-Version-3.jpg","bigUrl":"\/images\/thumb\/3\/35\/Insert-an-Excel-Table-into-Word-Step-1-Version-3.jpg\/aid939842-v4-728px-Insert-an-Excel-Table-into-Word-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":344,"bigWidth":728,"bigHeight":545,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    This method will walk you through the steps of copying and pasting data from Excel into Word using a Windows or Mac desktop application. You can either open your document from within Excel by going to File > Open or you can right-click on the file, select Open With , and then Excel .
    • If you have data or a table of data, you'll be able to change how the pasted information appears within the Paste Options , all steps are otherwise identical if you're trying to copy and paste data or tables.
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a1\/Insert-an-Excel-Table-into-Word-Step-2-Version-4.jpg\/v4-460px-Insert-an-Excel-Table-into-Word-Step-2-Version-4.jpg","bigUrl":"\/images\/thumb\/a\/a1\/Insert-an-Excel-Table-into-Word-Step-2-Version-4.jpg\/aid939842-v4-728px-Insert-an-Excel-Table-into-Word-Step-2-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    Using your mouse, click the first cell of data you want to copy and drag it to include the range (if you want to copy more than one cell).
    Advertisement
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7c\/Insert-an-Excel-Table-into-Word-Step-3-Version-4.jpg\/v4-460px-Insert-an-Excel-Table-into-Word-Step-3-Version-4.jpg","bigUrl":"\/images\/thumb\/7\/7c\/Insert-an-Excel-Table-into-Word-Step-3-Version-4.jpg\/aid939842-v4-728px-Insert-an-Excel-Table-into-Word-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":342,"bigWidth":728,"bigHeight":541,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can also right-click and select Copy .
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/89\/Insert-an-Excel-Table-into-Word-Step-4-Version-4.jpg\/v4-460px-Insert-an-Excel-Table-into-Word-Step-4-Version-4.jpg","bigUrl":"\/images\/thumb\/8\/89\/Insert-an-Excel-Table-into-Word-Step-4-Version-4.jpg\/aid939842-v4-728px-Insert-an-Excel-Table-into-Word-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":547,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You can open a document you've been working on or you can create a new document.
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2d\/Insert-an-Excel-Table-into-Word-Step-5-Version-3.jpg\/v4-460px-Insert-an-Excel-Table-into-Word-Step-5-Version-3.jpg","bigUrl":"\/images\/thumb\/2\/2d\/Insert-an-Excel-Table-into-Word-Step-5-Version-3.jpg\/aid939842-v4-728px-Insert-an-Excel-Table-into-Word-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    When you press the keyboard shortcut, the data you've copied from Excel will paste into the Word document.
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f5\/Insert-an-Excel-Table-into-Word-Step-6-Version-3.jpg\/v4-460px-Insert-an-Excel-Table-into-Word-Step-6-Version-3.jpg","bigUrl":"\/images\/thumb\/f\/f5\/Insert-an-Excel-Table-into-Word-Step-6-Version-3.jpg\/aid939842-v4-728px-Insert-an-Excel-Table-into-Word-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":347,"bigWidth":728,"bigHeight":549,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    The data you copied from Excel will appear in your Word document.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fb\/Insert-an-Excel-Table-into-Word-Step-7-Version-3.jpg\/v4-460px-Insert-an-Excel-Table-into-Word-Step-7-Version-3.jpg","bigUrl":"\/images\/thumb\/f\/fb\/Insert-an-Excel-Table-into-Word-Step-7-Version-3.jpg\/aid939842-v4-728px-Insert-an-Excel-Table-into-Word-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You should see a "Paste Options" drop-down next to your pasted data or chart. If not, you'll find "Paste Options" above the document editing space on the left side of the window under "Home."
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f9\/Insert-an-Excel-Table-into-Word-Step-8-Version-3.jpg\/v4-460px-Insert-an-Excel-Table-into-Word-Step-8-Version-3.jpg","bigUrl":"\/images\/thumb\/f\/f9\/Insert-an-Excel-Table-into-Word-Step-8-Version-3.jpg\/aid939842-v4-728px-Insert-an-Excel-Table-into-Word-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":346,"bigWidth":728,"bigHeight":548,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    You'll see these options from left to right:
    • Keep Source Formatting : Keeps data as it was formatted in Excel.
    • Use Destination Styles : Updates the data to reflect Word's style. Use this paste style if you have data in a chart format with gridlines you want to keep.
    • Link & Keep Source Formatting : Keeps the formatting as it was in the Excel document, however, the data in the pasted table will update any time you edit it in Excel.
    • Link & Use Destination Style : Removes the original formatting and replaces it with that of your Word document. This also links the data to the original spreadsheet so that updating the spreadsheet will also update your Word document.
    • Picture : Inserts the data as an image instead of a table and cannot be updated.
    • Keep Text Only : Pastes only the text from the table and ignores all formatting (such as the lines in the table). However, each row of data in the chart/table is separated by a new paragraph and each column is separated by tabs. [1]
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f8\/Insert-an-Excel-Table-into-Word-Step-9-Version-2.jpg\/v4-460px-Insert-an-Excel-Table-into-Word-Step-9-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/f8\/Insert-an-Excel-Table-into-Word-Step-9-Version-2.jpg\/aid939842-v4-728px-Insert-an-Excel-Table-into-Word-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":343,"bigWidth":728,"bigHeight":543,"licensing":"<div class=\"mw-parser-output\"><p>License: <a target=\"_blank\" rel=\"nofollow noreferrer noopener\" class=\"external text\" href=\"https:\/\/en.wikipedia.org\/wiki\/Fair_use\">Fair Use<\/a> (screenshot)<br>\n<\/p><\/div>"}
    If you're using a Mac, press ⌘ Cmd + S and if you're using a Windows computer, press Ctrl + S .
    • You want to save your progress after you paste data from Excel into your Word document.
    10. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      You Might Also Like

      How to
      Unprotect an Excel Sheet
      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Unhide Multiple Rows in Microsoft Excel
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Add a Column or Calculated Field in an Excel Pivot Table
      The Best Ways to Make & Format Lists in Excel
      How to
      Add a Best Fit Line in Excel
      Advertisement

      References

      1. ↑ https://support.office.com/en-us/article/copy-from-excel-to-another-office-program-4ba759cc-62f3-422c-bd75-3fc83b06bb6b

      About This Article

      Article Summary X

      1. Open your document in Excel.
      2. Select the data in your Excel sheet that you want to copy and paste into Word.
      3. Press Ctrl + C (Windows) or Cmd + C (Mac).
      4. Open a document in Word.
      5. Move your cursor in the Word document where you want to paste the Excel data.
      6. Press Ctrl + V (Windows) or Cmd + V (Mac).
      7. Choose your paste formatting.
      8. Save your work.

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 47,111 times.

      Is this article up to date?

      Advertisement