The fastest way: copy from Excel and paste into Word

Open both Excel and Word side by side. Select the cells you want in Excel — click the first cell, hold Shift, and click the last cell to select a rectangle. Press Ctrl+C (or Cmd+C on Mac) to copy. Click in your Word document where you want the table and press Ctrl+V to paste.

Word will paste the table with the same layout, colors, and borders it had in Excel. The table stays editable in Word — you can click any cell and change the numbers or text. If you later change the numbers in the original Excel file, the Word table does not update automatically unless you set up a link, which most people do not need.

This method works best when you are done editing in Excel and just need a snapshot of the data in your document. If you are still making changes to the spreadsheet, you may want to update the Word table by hand or use the linking method described below.

Key Takeaways

  • Copy and paste from Excel to Word using Ctrl+C and Ctrl+V, and the table will appear with its original formatting intact.
  • Pasted tables in Word are fully editable — you can change numbers, add rows, or adjust formatting without going back to Excel.
  • If you need the Word table to update when the Excel file changes, right-click the pasted table and choose "Link and Keep Source Formatting" or a similar option.
  • For very large spreadsheets, paste only the rows and columns you actually need in your document to keep the file size down.

Linking the table so it updates when Excel changes

If you want the Word table to reflect changes you make in Excel later, you can create a link instead of a straightforward paste. Copy the cells in Excel as before. In Word, go to the Edit menu (or Home menu on some versions), find Paste Special, and click it. A dialog box will open with several paste options.

Look for an option that says "Paste Link" or "Link and Keep Source Formatting" — the exact wording varies by Word version. Click that option and then click OK. Word will now show the Excel data, and when you open the Word document again after updating the Excel file, Word will ask whether you want to update the linked table.

This approach is useful when you are building a report that pulls data from a live spreadsheet. The downside is that if you move or rename the Excel file, the link breaks and Word cannot find the data anymore. For most documents, a straightforward paste works better because it does not depend on another file staying in the same place.

Inserting a table directly from Excel using the Insert menu

Word also has a built-in way to pull in an Excel table without leaving Word. Click the Insert menu at the top, then look for "Table" or "Object". Some versions of Word show "Table" with a dropdown arrow — click the arrow and look for "Excel Spreadsheet" or "Object".

If you choose "Object", a dialog will open. Click the "Create from File" tab, then click Browse to find your Excel file on your computer. Select the file and click Insert. Word will embed a copy of the entire spreadsheet in your document — you can double-click it to edit it as if Excel were open, but the changes stay inside the Word file.

This method is less common because it makes your Word file much larger and creates a separate mini-spreadsheet inside the document. Most people find it easier to just copy and paste the cells they need. Use this approach only if you need the full spreadsheet embedded and editable within Word itself.

Adjusting the table after you paste it into Word

Once the table is in Word, you can change how it looks. Click anywhere in the table and the Table Design tab will appear at the top. You can choose a different style, change the colors, add borders, or remove shading. You can also right-click the table to access options for adding or deleting rows and columns.

To resize columns, position your cursor on the line between two column headers until it becomes a resize arrow, then drag left or right. To change the width of the entire table, click the table, then drag the resize handle in the bottom-right corner. Word will adjust the column widths proportionally.

If the table is too wide for your page, you can make it narrower by dragging column borders, or you can right-click the table and choose "AutoFit" to let Word adjust the columns to fit the content. You can also convert the table to text if you no longer need it to be a table — right-click and look for "Convert" options.

Keeping file size reasonable when pasting large tables

Excel spreadsheets can be enormous, but your Word document does not need to be. Before you copy, select only the rows and columns you actually want to show in your document. If your spreadsheet has 50 columns but you only need 5 for your report, copy just those 5.

If you are pasting a table with hundreds of rows, consider pasting only a summary or the top rows that matter to your reader. You can always reference the full Excel file separately if someone needs the complete data. This keeps your Word file smaller, makes it load faster, and makes it easier to email or share.

After you paste, you can also delete rows or columns you do not need. Click a row number or column letter to select the entire row or column, then right-click and choose Delete. This removes the data from the Word table without affecting your original Excel file.

Troubleshooting common pasting problems

If you paste and the table looks wrong — columns are too narrow, text is cut off, or the formatting is broken — try pasting again using Paste Special. Copy the cells in Excel again, then in Word use Ctrl+Alt+V (or go to Edit > Paste Special). Choose "Unformatted Text" or "HTML Format" to paste just the data without Excel's formatting, then manually format the table in Word using the Table Design options.

If the table appears but the numbers look different — for example, a date shows as a number like 44562 instead of "January 15, 2022" — the column is too narrow to display the formatted value. Double-click the border between column headers to auto-fit the width, or drag the border wider by hand.

If you pasted a link and it is not updating, check that the Excel file is still in the same location with the same name. If you moved or renamed it, right-click the table in Word, choose "Edit Link", and browse to the new location. If the file is on a network drive or shared folder, make sure you have permission to access it.

When to use a table versus typing data directly

If you have a small amount of data — a few rows and columns — it is often faster to type it directly into a Word table than to copy from Excel. Create a table in Word by going to Insert > Table, then choose how many rows and columns you need. Type your data and format it there.

Use the copy-from-Excel method when the data already exists in a spreadsheet, when the table is large, or when you want to preserve exact formatting like colors or number formats. If you are pulling data from a live spreadsheet that changes regularly, consider using a link so the Word document stays current.

For one-time reports or documents that do not change, a straightforward paste is usually the best choice. It is fast, the table looks professional, and you do not have to worry about broken links or file dependencies.

Frequently Asked Questions

Can I paste an Excel table into Word and keep it updating automatically?

Yes, by using Paste Special and choosing "Link and Keep Source Formatting" instead of a regular paste. When you open the Word document later, it will ask if you want to update the linked table. If you move or rename the Excel file, the link will break, so this works best when the Excel file stays in a stable location.

What if my Excel table is too wide to fit on a Word page?

Select only the columns you need before copying, or paste the full table and then delete unnecessary columns in Word. You can also right-click the table and choose "AutoFit" to shrink columns to fit the page width, or manually drag column borders narrower. Landscape orientation can also help if the table is only slightly too wide.

Does pasting an Excel table into Word make my Word file much larger?

It depends on the table size. A small table with a few rows and columns adds very little to the file size. A large table with hundreds of rows and many columns can noticeably increase the file size. If size is a concern, paste only the data you need, or consider linking to the Excel file instead of embedding the table.

Can I edit the numbers in the Word table without changing the original Excel file?

Yes. When you paste (not link), the table in Word is independent. Changes you make in Word do not affect the Excel file, and changes in Excel do not affect the Word table. If you want them to stay in sync, use the linking method instead.

What is the difference between pasting and using Insert > Object?

Pasting creates a regular Word table that looks like the Excel data. Using Insert > Object embeds the entire Excel spreadsheet inside Word, and you can double-click it to edit it like a mini-Excel file. Pasting is simpler and keeps file size smaller. Use Insert > Object only if you need the full spreadsheet embedded and editable within Word.