How to Copy Excel Cells to Word Without Losing Format

To copy Excel cells into Word, select the cells in Excel, press Ctrl+C, click where the table should go in Word, and press Ctrl+V. Then choose a paste option: keep the Excel formatting, match the Word document’s style, paste plain text, or use a picture. The best choice depends on whether you need an editable table, a live link to the workbook, or an exact-looking snapshot.

The steps below are for Excel and Word for Microsoft 365 on Windows. Save both files before you start if the data matters, and decide whether the Word version needs to change when the Excel range changes.

What You’ll Need

Excel with the worksheet and cell range you want to copy.
Word with the document open and a place ready for the copied content.
If you plan to link the range, keep the Excel workbook saved in a location you can access later. Word needs the source file to refresh the link.

Step-by-Step

Select the cells in Excel. Open the worksheet and drag across the range you need. To select a whole column or row, click its letter or number header. To select a large range precisely, click the Name Box to the left of the formula bar, type a reference such as A1:D12, and press Enter. Check that the selection includes the intended headings and does not include extra blank rows or columns.
Copy the selection. Press Ctrl+C on Windows. You can also use Home > Copy or right-click the selected cells and choose Copy. A moving dashed outline usually appears around the copied range. Leave Excel open while you switch to Word; the copied cells are held on the clipboard.
Choose the insertion point in Word. Switch to the document and click where the range should appear. If it belongs in the middle of a paragraph, click at the intended position; if it should be a separate table, click on a blank line. A copied range can make the surrounding text move, so consider adding a paragraph break first. Press Enter if you need a clear line before or after the table.
Paste the cells. Press Ctrl+V. Word normally inserts the range as a table, including the cell contents and much of the Excel formatting. Depending on your Word settings and the content, a Paste Options button may appear next to the pasted range. Click it to see available choices. If it does not appear, select the pasted range and look for paste choices on the Home tab, or use the paste shortcut again only after recopying the cells.
Choose how the table should look. Select Keep Source Formatting to preserve Excel’s fonts, fills, borders, and number formats as closely as Word supports. Choose Use Destination Styles to make the pasted table fit the Word document’s styles. Choose Keep Text Only when you need the cell contents without the original styling; the values are generally separated into a table-like layout, but you may need to tidy it. The precise labels or available choices can vary with the Office build and what you copied.
Adjust the table to the page. Click inside the pasted table. Use the table layout controls that appear in Word to adjust column widths, row heights, alignment, and cell margins. If the table is wider than the page, try a narrower font, reduce unnecessary columns, or change that page to landscape using Layout > Orientation > Landscape. For a document with surrounding text, check that the table does not push a heading or caption onto an awkward page by itself.
Save and check the result. Save the Word document, then compare the pasted range with Excel. Check the first and last rows, column headings, dates, percentages, currency, and any long text. A normal paste does not keep the cells connected to Excel: it gives Word a copy of the content and appearance at the time of pasting. If the Excel values change later, update the Word table manually or use a linked paste as described next.

To create a link that can update: Copy the range in Excel, then in desktop Word choose Home > Paste > Paste Special. In the dialog, select Paste link, choose an available Excel worksheet object or formatted range option, and click OK. The precise object choices depend on the copied range and Office version. Save the workbook in a stable location and keep its name and path unchanged. When the source data changes, Word may update the link when the document opens or when you use Word’s link-update controls. Linked content can be convenient for reports that are refreshed regularly, but it can stop updating if the workbook is moved, renamed, or unavailable.

To paste a picture instead: Copy the Excel range, open Word’s Paste menu, and choose a picture option if one is offered. Another route in desktop Word is Home > Paste > Paste Special, then choose an available picture format. A picture keeps the layout looking consistent, but its cell text is not editable as a Word table and will not refresh from Excel. Use this for a fixed visual snapshot, not when readers need to edit or search individual cells.

On Mac or Word for the web: On a Mac, use Command+C and Command+V instead of Ctrl+C and Ctrl+V. Paste options may be shown in the menu or in a small control beside the pasted table; the available choices differ slightly from Windows. Word for the web can handle ordinary copy-and-paste, but advanced Paste Special and linked Excel object options may be unavailable or limited. For a linked range or more control over the paste format, use the desktop Word app.

Common Mistakes

Expecting a normal paste to stay connected to Excel. A standard Ctrl+V paste is a snapshot. It does not update automatically when you edit the source cells. Use Paste Special with Paste link if updating is important, or plan to replace the Word table each time.
Copying more cells than intended. A stray selected column or blank row can make the Word table too wide or add unwanted space. Check the selection outline in Excel before copying, especially when using the Name Box or selecting whole rows and columns.
Choosing the wrong paste style. Keep Source Formatting may clash with the Word document’s fonts and colors. Use Destination Styles if consistency with the report matters more than matching the spreadsheet exactly. Keep Text Only removes much of the formatting and may require extra cleanup.
Assuming formulas will work in Word. A pasted table is not an Excel calculation grid. It shows the copied cell content, but you cannot expect Excel formulas to recalculate as formulas inside an ordinary Word table. Keep calculations in Excel, then paste the resulting values or link the range.
Ignoring page width and print layout. A table that looks acceptable on screen may be cut off in print or in a PDF. Check Word’s Print Layout and print preview, and adjust the page orientation, margins, or table columns before sharing.

Tips

Pick the paste method based on the job. Use a regular paste for an editable Word table, a linked paste for a report that needs to reflect later Excel changes, and a picture for a layout that must remain visually fixed.
Keep the selection compact. Copy only the rows and columns readers need. Removing irrelevant columns in Excel before copying is often quicker and clearer than trying to repair a very wide Word table.
Make a complex range easier to read before copying. Set useful column widths, apply number formats, and make headings clear in Excel. Word may not reproduce every detail of Excel’s display exactly, so a quick source cleanup can reduce later formatting work.
Use a consistent document style. If the Word file already has a table design, paste with destination styles and then apply the document’s table formatting. This helps the copied content look intentional alongside the rest of the report.
Keep linked files together. Store the Word document and its source workbook in a known folder. If you need to send the document to someone else, include the workbook or use a non-linked paste so the recipient does not see a broken link.
Test a small range first. If you are unsure how a particular version handles formatting or links, copy a few representative cells into a spare document. That lets you check dates, borders, merged cells, and column widths without disturbing the final report.

Troubleshooting

The cells paste as plain text or lose their colors. Undo the paste with Ctrl+Z, recopy the range in Excel, and use Word’s paste menu to select Keep Source Formatting or an available formatted-table option. If you only see plain text choices, try the desktop Word app; browser-based editing may offer fewer paste controls. Confirm that you copied cells rather than a text selection inside a cell.

The table is too wide or runs off the page. In Word, click inside the table and reduce column widths or font size. You can also remove unneeded columns in Excel and copy the smaller range again. For a report page containing a wide table, change the page orientation to landscape or adjust the margins. Check the result in print preview rather than relying only on the editing view.

The pasted table looks different from the worksheet. Word and Excel do not render every feature in the same way. Some Excel-specific formatting, conditional formatting, row heights, or column widths may not transfer as expected. Try Keep Source Formatting, simplify the formatting in Excel, or paste a picture when exact appearance matters more than editing. For a picture, make sure the copied range is large enough to remain readable at the size it will appear in Word.

A linked range does not update. Confirm that the Excel workbook still exists at the same path and that Word can access it. Open the source workbook, save it, then reopen the Word document and respond to any prompt about updating links. If the file was moved or renamed, restore its original location or recreate the link from the current workbook. If link maintenance is not practical, replace the linked content with a regular paste.

Ctrl+C or Ctrl+V does something unexpected. Click directly in the worksheet grid, select the cells again, and make sure Excel is the active window before copying. Then click in the Word document body before pasting. If the clipboard appears to contain old content, copy the range again. On Mac, use Command+C and Command+V; on Windows, use Ctrl+C and Ctrl+V.

Frequently Asked Questions

Can I copy Excel cells into Word as an editable table?
Yes. Copy the cells and paste them into Word. Word generally inserts a table whose text and cell layout you can edit, although it will not behave like a full Excel worksheet or automatically recalculate Excel formulas.

How do I keep the Excel formatting in Word?
After pasting, choose Keep Source Formatting from the Paste Options control or Word’s paste menu. If that option is unavailable, try Paste Special in desktop Word or use a picture when the exact visual layout matters more than editing.

Will the Word table change when I update the Excel cells?
Not after an ordinary paste. To make it updateable, use Paste Special and select Paste link, then choose an available Excel range or worksheet object. The source workbook must remain accessible, and linked content may need to be refreshed.

Can I copy only the displayed values and not the Excel formulas?
Yes. A regular paste into a Word table copies the displayed cell content rather than creating working Excel formulas in Word. If a particular paste choice gives an unwanted result, use Keep Text Only or paste a picture, depending on whether you need editable text.

Why are my dates or numbers different after pasting?
Word may interpret or display pasted content differently from Excel, particularly when number formats, dates, or regional settings are involved. Compare the result with the source and choose Keep Source Formatting. For critical figures, confirm the displayed values before distributing the document.

Can I do this in Word for the web?
You can usually copy and paste a basic range, but advanced Paste Special and linked-object choices may not be available. Open the document in desktop Word if you need to control the link, choose a specific object type, or troubleshoot missing formatting.

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.