How to Convert an Excel Table to Word Without Losing Layout

How-to basics · Updated November 20, 2026

To convert an Excel table to Word, select and copy the cells in Excel, then paste them into Word using Home > Paste > Keep Source Formatting. This creates an editable Word table. If you want the Word version to update when the workbook changes, use Paste Special and choose a link instead; if you need a fixed visual snapshot, paste the selection as a picture. Decide first whether editability, automatic updates, or an exact-looking snapshot matters most.

What You’ll Need

  • Microsoft Excel and Word for Microsoft 365 on Windows, with the workbook and document available on the same computer.
  • The Excel range or table you want to transfer. Check that it includes the intended headers and excludes any notes or totals you do not want in Word.
  • For a linked paste, keep the original workbook in a stable location and save it before copying. Word relies on that source file to refresh linked content.

Step-by-Step

  1. Prepare the table in Excel. Open the workbook and review the cells you plan to copy. Make sure the headings are clear, columns are in the intended order, and displayed values are correct. If the range is an Excel table with filter arrows, those controls do not become working filters in Word; Word receives the cell content and much of its formatting, not Excel’s table functionality. If you do not want a totals row or extra worksheet notes, leave them out of the selection.
  2. Select the exact cells. Click the first cell you need, then hold Shift and click the last cell in the range to select the rectangle between them. You can also drag across the range. Include the header row if it should appear in Word. Avoid selecting entire worksheet columns or rows unless you really intend to copy all their cells. Check the highlighted boundary before copying so blank cells or adjacent data are not included.
  3. Copy the selection. Press Ctrl+C on Windows. Alternatively, right-click the selected cells and choose Copy. A moving dashed border usually appears around the copied range. Do not cut the cells: copying leaves the original table intact, while cutting removes it from its current location when you paste. If you will make a linked version, save the workbook now so Word can refer to a named, saved source.
  4. Choose where the table belongs in Word. Open the document, click where the table should start, and make sure the insertion point is on a blank line or in the intended place in the text. If the table is wide, consider changing that page to landscape before pasting: select the page or section, then use Layout > Orientation > Landscape. For just one page, add section breaks around it so the rest of the document can remain portrait.
  5. Paste an editable table with its Excel appearance. In Word, select Home > Paste and choose Keep Source Formatting if that option is shown. Word normally converts copied cells into a Word table: you can edit text and cell formatting using Word’s Table Design and Layout tabs. Some paste menus show a small set of icons instead of full labels; hover over an icon to see its name. The resulting table is separate from the workbook, so later edits in Excel will not automatically change it.
  6. Pick a different style if needed. If the source colors and fonts clash with your document, use the paste option called Use Destination Styles, Merge Formatting, or a similarly named choice offered by your version. This applies more of Word’s styling while retaining the rows and columns. Choose Keep Text Only only when you want the cell contents without the table’s formatting; depending on the content and paste choice, Word may put the text into a tab-delimited layout that needs cleanup.
  7. Make a linked table when updates matter. In Excel, copy the range again. In Word, choose Home > Paste > Paste Special. In the dialog, select Paste link, then choose an appropriate format, such as Formatted Text (RTF), if it is offered. Confirm with OK. The pasted table can reflect changes in the source workbook when links update, but it depends on the workbook remaining accessible. Avoid renaming or moving the source file without checking the link afterward. Paste Special options can vary with the Office version and what is on the clipboard.
  8. Paste a workbook object or a picture when that fits better. For an Excel object, use Home > Paste > Paste Special and select Microsoft Excel Worksheet Object; choose Paste for a standalone embedded object or Paste link if you want it connected to the source and that option is available. Double-clicking an embedded object lets you work with it using Excel tools, but it is not as convenient to edit as a native Word table. For a static snapshot, use Paste Special and select a picture format if listed, or use the picture paste option. A picture preserves appearance well but its cells cannot be edited as table cells.
  9. Fit and check the result. Click the pasted table and inspect its headings, borders, number formats, and page breaks. To adjust widths, drag a column boundary or use the table layout controls. If the table is wider than the page, try Layout > Orientation > Landscape, narrower margins, or smaller font size. Save the Word document, then reopen it or use Print Preview to confirm the table fits as intended.

Common Mistakes

Copying too much. Selecting a full worksheet column can bring in a large block of blank cells and make the Word document unwieldy. Select only the used range you need, including the correct heading row.

Expecting a normal paste to stay connected to Excel. A standard paste creates an independent copy. It will not track later workbook changes. Use Paste Special and Paste link if updating from the workbook is important, and remember that a broken or inaccessible source file can prevent refreshes.

Assuming Excel features transfer intact. Excel formulas generally appear as their current displayed results in a Word table; Excel formulas, sorting, filters, and data validation do not become working Word features. Likewise, a picture is not an editable table. Choose the format based on what you need to do after pasting.

Ignoring page width and print layout. A table that looks fine in Excel may overflow a portrait Word page or split awkwardly across pages. Check the page size and orientation before finalizing, and preview the printed pages rather than judging only by the on-screen view.

Tips

For a report that will be edited mainly in Word, a regular Word table is usually the easiest choice. It allows you to revise wording, add rows, change borders, and apply Word styles without opening Excel. Use source formatting as a starting point, then apply the document’s heading and table styles for a consistent appearance.

For a report that must show current workbook data, use a link and keep the workbook in a shared, stable location. If someone else will receive the document, make sure that person can access the linked file too. A link to a file on your personal desktop may work for you but fail on another computer. When sending a final, fixed report, consider updating the link first and then saving or sharing a copy whose appearance has been checked.

For a very wide table, do not shrink the font until it becomes difficult to read. Consider placing the table on a landscape section, splitting it into two smaller tables, or moving supporting detail to an appendix. Word tables have a maximum of 63 columns, so a selection wider than that cannot be represented as a normal Word table. An embedded Excel object or a carefully sized picture may be more appropriate for unusually wide data, although each has editing and accessibility trade-offs.

Use meaningful column headings and avoid relying on color alone to distinguish important values. If the table continues across pages, repeat its header row: select the header row, then choose Table Layout > Repeat Header Rows. This setting helps readers understand a long table after a page break. It does not make an Excel filter or formula available in Word.

On a Mac, the basic process is the same: copy the range in Excel with Command+C and paste in Word with Command+V. The paste options may appear in a floating control or the Edit menu, and Paste Special may be under Edit > Paste Special rather than in the same ribbon location as Windows. Choose the equivalent linked, formatted, or picture option available in that dialog. Excel for the web and Word for the web may show fewer advanced paste choices; use the desktop apps if you need a linked paste or a specific object format.

Troubleshooting

The table pastes as plain text. Undo the paste with Ctrl+Z, recopy the cells, and try the paste dropdown rather than the default Ctrl+V action. Select Keep Source Formatting or a table-oriented option. If you intentionally chose Keep Text Only, check whether tabs separate the columns; you may be able to select the text in Word and use Insert > Table > Convert Text to Table, with tabs as the separator.

The table is too wide or columns look uneven. Select the table and use Table Layout > AutoFit to Contents or AutoFit to Window, if available in the ribbon. AutoFit to Window makes the table fit the text area but may make columns narrow. You can also switch the relevant page to landscape, reduce margins, or adjust individual column widths. Check that the Word page size matches the document’s intended print size.

Formatting changes after pasting. Try another paste option: Keep Source Formatting preserves more of the Excel look, while Use Destination Styles or Merge Formatting blends the table into the Word document. Some number displays may depend on how the values were formatted in Excel. If exact visual fidelity matters more than editing, paste a picture instead and verify that it remains legible at the final page size.

A linked table does not update. First open the source workbook and confirm that it has been saved. In Word for Windows, go to File > Info and look for Edit Links to Files if that command is available; use it to check the source path and update the link. If the workbook was moved, browse to its new location or recreate the linked paste. Link-management commands can vary by Office build and may not be available for every pasted format.

The table breaks across pages badly. Reduce unnecessary paragraph spacing around the table, adjust column widths, or move the table to a landscape section. You can also select a row, open Table Properties, and review the Row settings for whether rows are allowed to break across pages. Repeat the header row on subsequent pages so readers can identify the columns.

Frequently Asked Questions

Does copying an Excel table into Word keep it linked?
No. A normal copy-and-paste creates a separate Word table. To link it, use Paste Special and select Paste link, then choose a suitable format. Keep the original workbook accessible for updates.

Can I edit the pasted table in Word?
Yes, if you paste it as a Word table. You can edit its text, cells, and formatting in Word, but Excel formulas and interactive features do not transfer as working spreadsheet features. An embedded Excel object is edited differently: double-click it to open its Excel-style editing interface.

How do I paste only the data and not Excel formatting?
Use the paste dropdown in Word and choose Keep Text Only if offered. If you want to retain a proper grid, choose a table-oriented paste option and then apply Word’s table styles, rather than removing all formatting.

Why do my Excel colors or number formats look different?
Word may apply different styles or display values according to the selected paste format. Try Keep Source Formatting, and check the number display in Excel before copying. For a document-matched appearance, choose destination styles and adjust the Word table afterward.

Can I convert a very large Excel table to Word?
You can copy a large range, but a Word table may be difficult to navigate, may span many pages, and cannot have more than 63 columns. For extensive data, consider including a summarized Word table and sharing the full workbook separately, or embed the workbook if readers need spreadsheet functionality.

Can I do this in Excel and Word for the web?
Basic copying and pasting usually works, but the web apps may offer fewer Paste Special and link choices than the desktop apps. For a linked table, embedded Excel object, or more control over formatting, open the files in the Microsoft 365 desktop apps.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.