Copy Excel to Word Without Losing Formatting

To copy Excel cells into Word without losing their appearance, select the range in Excel, press Ctrl+C, then in Word choose Home > Paste > Keep Source Formatting. This usually preserves colors, borders, fonts, and number formats; choose a linked object or picture instead if you need live updates or an exact visual copy.

Choose the right paste method

There is no single best paste choice for every document. A normal paste with source formatting is a good default when you want a readable Word table that resembles the spreadsheet. Other choices trade editability, updating, and visual fidelity against one another.

Keep Source Formatting: Creates a Word table in most ordinary range-copy situations and retains much of the Excel formatting. You can edit the cells as a Word table, but Excel formulas are not carried over as working formulas.
Use Destination Styles: Applies Word’s document styles to the pasted content. This can make a table fit a report’s typography, but may change its colors, fonts, or borders.
Paste as a picture: Keeps the displayed appearance fixed and prevents accidental edits to individual cells. The result is an image, not a spreadsheet or Word table.
Paste as an Excel object or link: Keeps spreadsheet behavior or a connection to the workbook, but requires more care with file access and document compatibility.

After pasting, Word may show a Paste Options button near the new content. Select it to switch among choices available for the copied material. The available options depend on what was copied and the Office versions involved.

Keep source formatting with a normal paste

For a standard table, use Excel for Microsoft 365 on Windows and Word desktop as follows:

In Excel, select only the cells you want in the document. Include the heading row if it belongs in the table.
Press Ctrl+C. A moving dashed border around the selection indicates that it has been copied.
Click the insertion point in Word where the table should go. Avoid placing the cursor inside another table unless you intend to insert or merge content there.
On the Word ribbon, select Home > Paste, or use Ctrl+V. If the Paste Options button appears, choose Keep Source Formatting.
Review the result at the intended page size. Adjust column widths or page layout if the table is too wide.

On Windows, Ctrl+C and Ctrl+V are the usual copy-and-paste shortcuts. The equivalent shortcuts in Excel and Word for Mac are Command+C and Command+V. Ribbon labels and available paste options can differ slightly on Mac, so use the paste menu or the Paste Options control if the result is not what you expected.

Keep Source Formatting preserves much of the visible design, but it does not make the Word table a second live copy of the Excel model. Cell values and displayed results come across; formulas, charts linked to those cells, data validation, and other workbook features do not become functioning Word-table features. If you later change a source cell, a normal pasted table will not automatically refresh.

Use Paste Special for more control

Paste Special is useful when the ordinary paste result is not suitable or when you need a particular kind of object. Copy the range in Excel, click the destination in Word, then use Home > Paste > Paste Special. In Word for Windows, Ctrl+Alt+V also opens the Paste Special dialog in many desktop versions. The dialog’s choices depend on the clipboard content; they may include formatted text, an Excel worksheet object, or a picture format.

Select a format that matches your goal, rather than choosing an option just because it sounds more complete. Formatted text is generally suited to a Word-native table. An Excel worksheet object is suited to retaining spreadsheet content inside the Word file. A picture format is suited to a fixed visual result. If the dialog offers a Paste link option, selecting it creates a connection to the source workbook instead of an independent static copy.

When you paste an Excel object, Word can display the copied range as an embedded object. Depending on the Office setup, double-clicking it can open Excel editing controls within Word or open the content for editing in Excel. This is different from a regular Word table: it retains more spreadsheet behavior, but can be less convenient to resize, style, or edit alongside surrounding Word text.

Paste Special is not a guarantee that every Excel feature will transfer. Excel-specific features such as conditional formatting rules, filters, formulas, and interactive controls may not behave the same way in Word. Check the actual result, especially when a document will be opened on another computer or in a different Office application.

Decide whether to link, embed, or use a picture

A linked object can reflect later changes to the workbook, which is useful for recurring reports or figures that are updated frequently. The link depends on Word being able to find the source file. Moving, renaming, or deleting the workbook, changing access permissions, or sending the Word document without the workbook can prevent the link from updating. A recipient may also see a prompt about updating external links.

An embedded object stores a copy of the spreadsheet content in the Word document, so it does not rely on the original workbook path in the same way. It does make the document larger and can be harder to maintain: edits to the embedded copy do not update the original Excel workbook. Embedding is useful when a recipient should have spreadsheet content available in the document, but not a continuing connection to the source.

A picture is often the most dependable option when the page must look the same on different computers and readers do not need to edit cells. It will not update when the workbook changes, and text inside it is not as accessible or easy to search as a real table. For a large or detailed range, verify that the image remains legible at the size it will appear in the document. If you need a Word-native table that people can edit, choose a normal formatted paste instead.

In short, use a Word table for editing and document flow, an embedded object for spreadsheet-style editing inside the file, a link for updates from a maintained workbook, and a picture for a fixed appearance. Keep the original workbook when it is the authoritative source, regardless of which method you use.

Prepare the worksheet before copying

Formatting problems often begin in Excel rather than Word. Before copying, make the range look as you want it to appear in print or on the page. Check font size, fill colors, borders, alignment, wrapped text, and number formats. A date displayed as 2-Nov in Excel may be copied as a displayed date rather than as the underlying serial value, but inspect it in Word to confirm that the presentation is appropriate.

Trim the selection to the actual report area. Copying whole rows or columns can bring unnecessary blank space or formatting into Word. If cells are merged, check that the selection includes the full merged area; partial selections around merged cells can produce confusing results. If the range includes hidden rows or columns, confirm whether you intend to include them, because copying a selection with hidden content can behave differently depending on how the range was selected.

For a wide table, decide how it should fit before pasting. In Word, Layout > Orientation > Landscape changes the page orientation for the relevant section. Layout > Margins offers page-margin choices. You can also reduce the number of columns, shorten headings, or split a very wide table into two related tables. Shrinking the font excessively may technically fit the data but make the document difficult to read.

Fix common formatting and layout problems

If the Word table loses colors or borders, use the Paste Options button and select Keep Source Formatting rather than Use Destination Styles. If the desired option is absent, try Home > Paste > Paste Special and choose an available formatted-text option. The precise labels vary with the content on the clipboard and the installed Office version.

If columns are too wide, click in the table and look for the contextual Table Layout tab. In Word for Windows, Table Layout > AutoFit includes options such as AutoFit Contents and AutoFit Window. AutoFit Contents sizes columns around their contents; AutoFit Window adjusts the table to the available page width. These choices can alter column proportions, so check headings and numeric columns afterward. You can also drag column boundaries or use the table’s sizing controls.

If text wraps unexpectedly, the Word page may simply be narrower than the worksheet area. Try landscape orientation, narrower margins, a smaller but readable font, or fewer columns. If borders seem doubled or missing, inspect the table in Print Layout and check whether the source used cell borders, gridlines, or both. Excel gridlines are not the same as printed borders; if the lines matter in Word, apply actual borders in Excel before copying or format the Word table after pasting.

If numbers appear different, check whether Excel displayed them with a particular number format, such as currency, percentage, or fixed decimal places. A normal paste generally carries displayed formatting, but a linked or embedded object may present differently depending on how it is opened and scaled. Verify totals and important figures against Excel rather than assuming that the visual copy is a new calculation.

Excel for the web, Mac, and Word options

Excel for the web and Word for the web can copy and paste cell ranges, but the available paste choices and fidelity can differ from the Windows desktop applications. Browser clipboard permissions and the web app’s current capabilities may affect the result. If you need Paste Special options such as an embedded Excel object or a link, use the desktop apps where available; do not assume every desktop object-paste choice exists in a browser.

On Mac, copy and paste with Command+C and Command+V. Excel and Word for Mac provide paste choices, but their dialogs and exact options may not match Windows. Use the visible Paste menu or Paste Options control and confirm the result. A document shared between Mac and Windows can also display objects differently if a recipient lacks the relevant application or fonts, so inspect the final file on the platform that matters.

For a document that must travel reliably, consider whether a regular Word table or picture is more appropriate than a linked spreadsheet object. A native table is usually easier to edit in Word and a picture is usually simpler to preserve visually; links and embedded objects retain more spreadsheet context but may behave differently across systems.

Frequently Asked Questions

How do I paste Excel into Word and keep the colors?
Select the cells in Excel, copy them, then paste in Word and choose Keep Source Formatting from the Paste Options control. If the colors still change, try Home > Paste > Paste Special and select an available formatted-text option.

Can I edit an Excel table after pasting it into Word?
If it was pasted as a normal table, you can edit its cells using Word’s table tools, but Excel formulas and spreadsheet features will not remain active. To retain spreadsheet-style editing, paste or insert it as an Excel worksheet object instead.

How do I make the pasted table fit on one page?
Try landscape orientation, adjust margins, and use the table’s AutoFit options in Word. If it remains too wide, reduce columns or split the table. Avoid making the text so small that readers cannot comfortably read it.

Will a pasted Word table update when the Excel file changes?
No, not if you pasted it as an ordinary table or picture. Choose Paste Special with Paste link when available to connect the Word content to the workbook. Keep the source file in an accessible location and check links after moving or sharing files.

What is the safest way to preserve the exact appearance?
Paste the range as a picture when readers only need to see it and the appearance matters more than editing or accessibility. For readable, editable content, use a Word table with source formatting and review the document at its final page size.

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.