How to Insert an Excel Worksheet Into Word

If you just need to insert an excel worksheet into word and move on, the boxed answer at the top is all you need. The rest of this page is for when you want to understand why it works in Excel, adapt it to a trickier version, or make it robust enough to hand to a colleague. We keep the opening short on purpose — the depth is here when you want it, not in your way when you don’t.

Exact answer

In Excel: for a range, copy it and in Word use Home ▸ Paste ▸ Paste Special ▸ Paste link ▸ Microsoft Excel Worksheet Object; for a chart, copy it and pick Keep Source Formatting & Link Data from Word's Paste Options button.

On this page7
Annotated stepsExcel
1

Select the range in Excel and press Ctrl+C — copy the exact block you want, not whole columns.

2

In Word, place the cursor and open Home ▸ Paste ▸ Paste Special.

3

Choose Microsoft Excel Worksheet Object; tick Paste link for a live link, leave it clear to embed a copy.

4

For a plain formatted table instead, use Paste ▸ Keep Source Formatting or Paste ▸ Picture when layout matters more than editability.

5

Refresh a linked object with Ctrl+A then F9, or right-click it ▸ Update Link.

6

For a chart, copy the chart in Excel, paste into Word and open the Paste Options button that appears: Keep Source Formatting & Link Data keeps the Excel look and follows the workbook, Use Destination Theme & Link Data restyles it to the document, and Picture freezes it.

Ctrl+CthenCtrl+Shift+V+Cthen+Ctrl+VPaste values · WindowsMac

What this does

Word accepts a range three different ways and they behave nothing alike. A plain paste produces a static Word table you can edit in Word but which never updates. An embedded object stores a private copy of the worksheet inside the .docx, so it travels with the document and opens in Excel on double-click. A linked object stores only the file path, so the document shows whatever the workbook currently holds. A chart is handled by a different control entirely — Word's Paste Options button, which offers four combinations of theme and data source rather than the Paste Special dialog. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. Treat “insert an excel worksheet into word” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected sheet shows up while it is still harmless. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. That turns a layout choice that keeps the sheet readable and sortable into a method you can reuse, explain, and defend when the workbook leaves your screen.

A worked example

A monthly report needs the summary from Q3.xlsx. Copy A1:D13, switch to Word, Home ▸ Paste ▸ Paste Special, tick Paste link and pick Microsoft Excel Worksheet Object. When September closes and the workbook is updated, pressing Ctrl+A then F9 in Word redraws the table with the new figures. Reports get rebuilt every period, and a table that was retyped into Word is the one number in the document nobody re-checks. A practical tip: try it on a copy of the sheet or a handful of sample rows first and check the result before you apply it to the real data. That one habit catches almost every surprise while it is still cheap to reverse.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. Nothing on this page is behind a login or a download: the exact answer is at the top, and the detail below it is there for when you need it. That is the whole promise here — the answer first, and just enough context to make it stick. If you take one thing from this page on “insert an excel worksheet into word”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.

Common mistakes

  • Linking to a workbook that later moves or is renamed — the link breaks and the reader sees a stale table with no warning.
  • Embedding a 30 MB workbook to show a twelve-row summary; the whole file is copied into the document.
  • Pasting a range wider than the page and letting Word crop it instead of switching the section to landscape or pasting as a picture.
  • Expecting a plain paste to update later; only linked objects and fields refresh.

Frequently asked questions

How do I keep the Excel formatting in Word?

Use Paste ▸ Keep Source Formatting, or paste as a Worksheet Object, which reproduces the sheet exactly including fonts, fills and number formats.

How do I make the Word table update automatically?

Paste it with Paste link. Then in Word, File ▸ Options ▸ Advanced ▸ Update automatic links at open keeps it current every time the document opens.

Embed or link?

Embed when the document must be self-contained for external readers. Link when both files live on the same shared drive and the numbers change.

Can I edit the numbers from inside Word?

Double-click an embedded object and it opens an Excel editing surface in place. A linked object opens the real workbook instead.

How do I put an Excel graph into Word?

Copy the chart, paste it, then use the Paste Options button — not Paste Special. Choose one of the two Link Data options if the chart must follow the workbook, or Picture if it must never change.