The fastest way: copy from Excel, paste special into Word

Open your Excel file and select the table or range of cells you want to move into Word. Click and drag to highlight the cells, or click the first cell, hold Shift, and click the last cell. Then press Ctrl+C (or Cmd+C on Mac) to copy.

Switch to your Word document and click where you want the table to appear. Do not use the regular paste command. Instead, right-click and select Paste Special, or press Ctrl+Alt+V. A dialog box will open with several paste options.

Choose Microsoft Excel Worksheet Object if you want the table to stay connected to the original Excel file and update automatically when you change it. Choose Formatted Text (RTF) or HTML Format if you want a static copy that keeps the colors, borders, and alignment but does not link back to Excel. Click OK.

Key Takeaways

  • Paste Special (Ctrl+Alt+V in Word) gives you control over how the table looks and whether it updates when the Excel file changes.
  • Pasting as an Excel Worksheet Object keeps a live link to your original file, so changes in Excel show up in Word automatically.
  • Pasting as formatted text or HTML breaks the link but preserves colors, fonts, and borders without extra file size.
  • If the table looks wrong after pasting, you can convert it to a Word table by right-clicking and selecting Convert to Table.

When to use a live link versus a static copy

A live link (Excel Worksheet Object) is useful when the numbers or data in your table change often and you want Word to show the latest version without you having to copy and paste again. The downside is that the Word file becomes larger and depends on the Excel file staying in the same location on your computer or network. If you move or delete the Excel file, Word will ask you to find it.

A static copy (formatted text or HTML) is better when you are sending the Word document to someone else, when the data is final and will not change, or when you want a smaller file size. The table sits in Word as its own object and does not need the original Excel file.

Fixing alignment and borders after pasting

Sometimes a table pasted into Word looks cramped, has misaligned columns, or loses its borders. Right-click the table and look for Table Properties or AutoFit. Click AutoFit Contents to let Word adjust column widths to fit the text, or AutoFit Window to stretch the table to fill the page width.

If borders are missing, click inside the table, go to the Table Design tab (or Design under Table Tools), and choose a border style from the gallery. You can also right-click, select Borders and Shading, and manually set which borders appear.

Pasting only the values, without formulas

If your Excel table contains formulas (like SUM or AVERAGE), those formulas will paste into Word as well. If you only want the numbers the formulas produced, use Paste Special and choose Unformatted Text or Formatted Text (RTF). Both strip out formulas and leave only the values.

Alternatively, in Excel before copying, select the cells with formulas, copy them, then use Paste Special within Excel itself and choose Values Only. Then copy those results and paste them into Word normally.

Converting a pasted table so you can edit it in Word

If you pasted an Excel table as an object and now want to edit it directly in Word (without opening Excel), right-click the table and select Convert to Table. Word will turn it into a native Word table that you can modify, add rows to, or delete cells from without touching the original Excel file.

Be aware that once you convert, the link to Excel is broken. Changes you make in Word will not affect the Excel file, and changes in Excel will not show up in Word.

Keeping the table on one page

Large Excel tables often break awkwardly across pages in Word. Click inside the table, right-click, and select Table Properties. Go to the Row tab and uncheck Allow row to break across pages. This forces each row to stay together, though it may push the table to a new page if it does not fit.

If the whole table needs to stay on one page, select the entire table, go to Layout (under Table Tools), and look for Properties. You can also reduce font size or column width to make the table smaller. Word will not automatically shrink a table to fit a page, so you have to adjust it manually.

Frequently Asked Questions

Why does my pasted table look different in Word than it did in Excel?

Word and Excel use different default fonts, spacing, and column widths. After pasting, use AutoFit to adjust columns, and check the font size in the Table Design tab. If colors or borders are missing, you pasted as plain text instead of formatted text — undo and use Paste Special with HTML Format or Formatted Text (RTF) instead.

Can I edit the table in Word after pasting it as an Excel object?

If you pasted as an Excel Worksheet Object, double-clicking the table opens it in Excel for editing. Changes you make there update in Word automatically. If you want to edit directly in Word without opening Excel, right-click and select Convert to Table, but this breaks the link to the original file.

What if the Excel file is on a network drive and I move it?

Word will not be able to find the file and will ask you to locate it the next time you open the document. To avoid this, paste as formatted text or HTML instead of as an Excel object, or move both the Word and Excel files together to the new location.

How do I paste only certain columns from an Excel table?

In Excel, select only the columns you want by clicking the column header, then holding Ctrl and clicking other column headers. Copy and paste into Word using Paste Special as usual. Only the selected columns will appear in Word.

Does pasting a table make my Word file much larger?

Pasting as formatted text adds minimal file size. Pasting as an Excel object embeds the entire Excel file inside Word, which can make the document significantly larger. If file size matters, paste as formatted text or HTML instead.