The fastest way: copy and paste special

Open both Excel and Word on your screen. In Excel, click and drag to select the table you want to move — include the headers and all the data rows. Right-click the selection and choose Copy, or press Ctrl+C (Windows) or Command+C (Mac).

Switch to your Word document and click where you want the table to land. Do not use regular paste. Instead, right-click and choose Paste Special. A dialog box will open with several options. Choose Microsoft Excel Worksheet Object if you want the table to stay connected to the original Excel file, or choose Formatted Text if you want a standalone table that does not link back.

Formatted Text is usually the right choice for a document you are sending to someone else, because it breaks the link and makes the file smaller. The table will look like a normal Word table, and you can edit it without touching the Excel original.

Key Takeaways

  • Paste Special (not regular paste) preserves table formatting and gives you control over whether the Word table stays linked to Excel.
  • Choose Formatted Text for a standalone table, or Microsoft Excel Worksheet Object if you need the Word version to update when the Excel file changes.
  • If the table is very large or contains formulas, converting it to a picture first prevents formatting problems in Word.
  • Word tables can be edited after pasting, but linked tables will update automatically if you change the original Excel file.

When to use a linked table instead

If you are building a report that pulls data from a live Excel spreadsheet — for example, a monthly sales summary that updates every week — you can keep the table linked. Choose Microsoft Excel Worksheet Object in the Paste Special dialog.

The table will appear in Word as a small embedded Excel sheet. When you open the Word document later, Word will ask whether you want to update the links. Click Yes and the table will refresh to match the current Excel file. This is useful for documents that multiple people edit, because everyone sees the same numbers.

The downside is that the file size grows, and if someone moves or deletes the original Excel file, the link breaks and Word shows an error. For a document you are sending to a client or posting online, a linked table usually causes more problems than it solves.

Fixing formatting problems after pasting

Sometimes a table pastes with broken columns, misaligned text, or colors that do not match your Word document. This usually happens when the Excel table has merged cells, custom fonts, or very wide columns.

The fastest fix is to undo the paste (Ctrl+Z), go back to Excel, and simplify the table before copying. Delete any merged cells, remove background colors you do not need, and make sure column widths are reasonable. Then copy and paste again.

If you cannot change the Excel file, try pasting as Unformatted Text instead. This strips all colors and fonts and gives you a plain table you can format in Word to match your document. You lose the original look, but you gain control and a smaller file.

Converting a table to a picture when nothing else works

If the table is complex — lots of merged cells, formulas, or special formatting — converting it to a picture is sometimes faster than fighting with Paste Special. In Excel, select the table, copy it, then in Word use Paste Special and choose Picture. The table becomes an image that looks exactly like the original.

The trade-off is that you cannot edit a picture table in Word the way you can edit a real table. If you need to change a number or add a row, you have to go back to Excel, make the change, and paste the picture again. Use this method only when the table is final and you just need it to look right.

Pasting into an existing Word table

If you already have a table structure in Word and just want to fill it with data from Excel, select the cells in Excel and copy them. In Word, click inside the first cell where you want the data to go, then right-click and choose Paste. Word will fill the cells row by row.

This works best when the Excel data and the Word table have the same number of columns and rows. If they do not match, Word will either leave cells empty or overwrite cells you wanted to keep. Count your rows and columns before you paste.

Keeping file size down when you paste multiple tables

Each table you paste as a linked Excel object adds to the Word file size. If you are pasting five or more tables, the document can become slow to open and difficult to email. Use Formatted Text for most tables and reserve linked objects only for tables that actually need to update.

After you paste, right-click the table and look for an option called Edit Links to Files or Links. This shows you which tables are still connected to Excel. You can break the link there if you change your mind later, which converts the linked table to a regular Word table and shrinks the file.

Frequently Asked Questions

Will the Word table update automatically if I change the Excel file?

Only if you chose Microsoft Excel Worksheet Object when you pasted. Word will ask you to update links the next time you open the document. If you chose Formatted Text, the Word table is independent — changes to Excel will not affect it.

Can I edit the table after I paste it into Word?

Yes, if it is a regular Word table. Click inside any cell and type to change the content. You can also add or delete rows and columns using the Table menu. If it is a linked Excel object, you can edit it, but the changes will not save back to Excel.

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

Word and Excel handle fonts, column widths, and colors differently. Paste Special with Formatted Text usually fixes this. If it does not, try pasting as a picture instead, or simplify the Excel table before copying — remove merged cells and custom formatting.

What is the difference between Paste and Paste Special?

Regular Paste uses Word's default table style and may lose Excel formatting. Paste Special lets you choose how the table behaves — as a linked object, formatted text, or a picture. Paste Special gives you more control.

Can I paste an Excel chart into Word the same way?

Yes. Select the chart in Excel, copy it, then in Word use Paste Special and choose Formatted Text or Picture. A chart usually pastes better as a picture because Word does not always handle Excel chart formatting well.