Copy Excel to Word and Keep Formatting

Yes. To copy an Excel range into Word and retain its appearance, select the cells in Excel, press Ctrl+C, then paste in Word and choose Keep Source Formatting from the Paste Options button. For a live spreadsheet or a picture instead of an editable Word table, use Paste Special and choose the format that matches how you plan to use the content.

What happens when you paste Excel cells into Word

Excel and Word can exchange copied cells in several forms. The same range may become a Word table, an embedded Excel worksheet, a link to the original workbook, or a picture. Those choices affect more than appearance: they determine whether a reader can edit cell contents, whether changes in Excel can appear in Word, and how the result behaves when the document is shared.

When you paste a range as a Word table and keep source formatting, Word generally preserves visible details such as fonts, fills, borders, alignment, and number formats. The pasted cells are then part of the Word document, not a working Excel range. A displayed value such as $1,250.00 can look the same, but the underlying Excel formula, data validation, and worksheet behavior do not become Word table features.

The Paste Options button appears near pasted content in Word. Its available choices can depend on what was copied and on the Office version. If it disappears, undo the paste and repeat it, or use Word’s Paste Special command to select a format deliberately.

Choose the paste method for your purpose

Before pasting, decide whether you need to preserve appearance, edit the numbers in Excel, or make a fixed visual record. Use these common options as a guide:

Keep Source Formatting: Makes a Word table that retains much of the Excel range’s visible formatting. Choose this for reports where readers should be able to edit text or cells in Word.
Use Destination Styles: Adapts the pasted table to the Word document’s styles. This can make a table fit a house style, but may change its colors, fonts, or borders.
Microsoft Excel Worksheet Object: Embeds spreadsheet content in the document. A reader can usually double-click the object to edit it with Excel tools. It is useful when spreadsheet editing matters, but can take more space and may not fit a page like a Word table.
Paste Link: Creates a connection to the source workbook, if you select a suitable Excel format in Paste Special. The Word content can reflect later source changes, but the link depends on the workbook remaining accessible.
Picture: Keeps a visual snapshot of the copied range. It is usually easy to position and resize, but cell text and values are not individually editable as a table.

For a simple report table, Keep Source Formatting is often the best starting point. For a chart or a carefully arranged block that must not reflow, a picture may be more predictable. For content that needs ongoing spreadsheet edits, embed or link the workbook rather than assuming a Word table will retain Excel functionality.

Copy and paste while retaining the source appearance

In Excel, select the cell range you want to use. Include headers and only the rows and columns required in the document.
Press Ctrl+C on Windows. In Word, click where the table should begin and press Ctrl+V.
Click the Paste Options button beside the pasted range and choose Keep Source Formatting, if it is not already selected.
Inspect the result in Word. Check number formats, borders, column widths, and page fit; these can shift when the table enters a differently sized page.

On a Mac, use Command+C and Command+V instead of the Windows Ctrl shortcuts. The paste choices are similar, although their position and wording can vary by Office version. Excel for the web and Word for the web can also have different menus and may offer fewer options than the desktop apps. If a specific Paste Special format is missing in a browser, use the desktop application when available.

To change a pasted Word table’s fit, click inside it and open the contextual Table Layout tab. Choose AutoFit, then AutoFit Window to make the table fit the available text width. This can narrow columns, so review the result rather than assuming all content will remain on one line. You can also adjust page margins from Layout > Margins, or switch a wide page to landscape through Layout > Orientation.

Use Paste Special for a workbook, link, or picture

Paste Special is useful when the default paste is not the format you want. Copy the Excel range, switch to Word, and select Home > Paste > Paste Special. In the dialog, choose an available format. For an embedded spreadsheet, select Microsoft Excel Worksheet Object and choose Paste. For a linked object, select Paste link and then the appropriate Excel object format. Exact labels can vary with the content copied and the installed Office version.

An embedded worksheet object stores spreadsheet content inside the Word file. It does not need to find the original workbook just to retain the embedded copy, but edits to that copy do not automatically update a separate original workbook. Double-clicking the object opens its spreadsheet editing surface; the amount of worksheet content visible in the document depends on the object’s size.

A linked object refers back to the source workbook. If the workbook changes, Word may be able to update the linked content, sometimes after you refresh it or respond to an update prompt. Links can break if the workbook is moved, renamed, or unavailable to the person opening the document. When sharing a linked document, keep the source file in a stable shared location and confirm the recipient has access. A link is not the same as embedding: it can keep a document current, but it also adds a dependency.

A picture is a static representation. It will not recalculate when Excel values change, and readers cannot select individual cells to edit them. However, it avoids many table reflow issues and can preserve the visual arrangement of a compact report block. If text inside the picture must remain readable, avoid shrinking it excessively to fit a narrow page.

What formatting transfers and what does not

Visible cell styling usually transfers more reliably than worksheet behavior. Fonts, background colors, borders, alignment, and displayed number formats are part of the appearance readers see. The final result can still differ because Word uses its own table layout, page width, and style rules. For instance, a long heading may wrap in Word even if its Excel column was wide enough to show it on one line.

Excel features such as formulas, filters, data validation menus, frozen panes, and conditional formatting rules should not be assumed to work in a pasted Word table. The table may show the results or colors that were visible when copied, but that does not mean the rule or calculation remains active. An embedded worksheet object is the more appropriate choice when readers need spreadsheet editing features. A linked object is useful when the Word document should draw from an external workbook, subject to link availability and update behavior.

Charts have their own paste choices. Depending on the selection and the options offered, a chart may be pasted as a picture, embedded chart, or linked chart. A picture is fixed; an embedded chart can be edited in the document; and a linked chart can refer to its Excel source. If the chart must stay synchronized with source data, check that you chose a linked option rather than a static image.

Fix common copy-and-paste problems

The colors or fonts changed: Click the Paste Options button and select Keep Source Formatting. If the table has already been pasted, undo and paste again with the desired option; changing Word styles afterward may be more work.
The table runs past the page edge: Select the table, choose Table Layout > AutoFit > AutoFit Window, and check whether landscape orientation or narrower margins would help. Reduce unnecessary columns in Excel if the content is still cramped.
Columns are too wide or too narrow: Adjust column widths in Word after pasting. Excel’s widths are measured in a different layout context, so they may not translate neatly to the page.
Numbers show too many or too few decimals: Check the displayed values in Excel before copying, then verify the Word result. If Word’s table display differs, reapply the desired number appearance in the source and paste again, or format the Word cells as needed.
The linked content does not update: Confirm that the source workbook still exists at its linked location and that Word can access it. If the document will be sent outside your organization, consider embedding a copy or pasting a static result instead.
The pasted object is hard to select: Click its edge rather than inside the cells. For an embedded object, clicking inside may activate spreadsheet editing instead of selecting the object for resizing.

One common misconception is that choosing Keep Source Formatting makes a Word table behave like Excel. It preserves appearance, not the spreadsheet’s full calculation and interaction model. Another is that linking guarantees the recipient will see current data: the link must remain valid, and the recipient may not have access to its source file.

Keep the result readable and reliable

For a polished document, prepare the Excel range before copying. Remove blank rows or columns that add needless space, use concise headings, and make sure values display at the precision readers need. A table with ten narrow columns may technically fit after AutoFit but still be difficult to read; splitting it into two tables or moving it to a landscape page can be clearer.

Think about document size and portability as well. An embedded workbook carries spreadsheet content in the Word file, which can make the document larger. A linked workbook keeps the source separate but requires a working file path. A pasted table is generally convenient for sharing a self-contained report, while a picture is suitable when the visual layout matters more than editing. If the numbers are important, retain the original Excel workbook as the authoritative data source and verify that the copied figures match it.

Frequently Asked Questions

How do I paste Excel into Word without losing formatting?
Copy the cells, paste them into Word, then use the Paste Options button to choose Keep Source Formatting. Review the table width and page fit afterward.

Can I keep an Excel table editable in Word?
Yes. Pasting as a Word table lets you edit its cells in Word, but it does not preserve Excel formulas or spreadsheet features. To edit the content with Excel tools, use Paste Special and embed a Microsoft Excel Worksheet Object.

Will a Word table update when I change the Excel file?
Not if you pasted it as an ordinary Word table or picture. Use Paste Special with Paste link to create a source connection, and keep the workbook accessible so Word can update the linked content.

Why does my Excel table not fit on the Word page?
Word’s text area may be narrower than the Excel range. Use Table Layout > AutoFit > AutoFit Window, adjust column widths, or try landscape orientation. For a very wide table, splitting it may be easier to read than shrinking it.

Is it better to paste an Excel range as a picture or a table?
Choose a table when readers need to edit text or cells in Word. Choose a picture for a fixed visual snapshot that should not reflow. Choose an embedded or linked Excel object when spreadsheet editing or source updates matter.

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.