Copying Text from Excel to Word: Formatting, Links and Tables

To copy cells from Excel into Word, select the cells, press Ctrl+C in Excel, place the cursor in Word, and press Ctrl+V. Word usually pastes a cell range as a table; use the Paste Options button or Word’s Paste Special command to choose plain text, a picture, or an Excel object instead.

Copy a cell range into Word

In Excel for Microsoft 365 on Windows, drag across the cells you need, or select a cell and use Shift with the arrow keys to extend the selection. Press Ctrl+C, switch to the Word document, click where the content should appear, and press Ctrl+V. Excel marks the copied range with a moving border until you copy something else or cancel the selection. In Word, the pasted cells generally appear as a table, with rows and columns retained.

Select only the cells that belong in the document. If the worksheet has headings, include them when they will help readers understand the data.
Copy with Ctrl+C, or choose Home > Clipboard > Copy in Excel.
Click the insertion point in Word. If you want the table on its own page, insert a page break first or place the cursor at the intended location.
Paste with Ctrl+V, or choose Home > Clipboard > Paste in Word.
Review the pasted result and use the Paste Options button near it to change how Word handles formatting.

On a Mac, use Command+C and Command+V in place of Ctrl+C and Ctrl+V. Excel for the web and Word for the web also support copy and paste, but browser clipboard behavior and available paste choices can differ from the desktop apps. If a web paste loses formatting, try the desktop versions or use Word’s available paste menu rather than assuming the cells themselves are missing.

Choose what Word should receive

Copying a range is not just a choice between copying and not copying. The best paste type depends on whether people need to edit the content, preserve its appearance, or see updates from the workbook. After pasting, select the Paste Options button to see choices available for that particular content and Office setup. The labels can vary, but common options include keeping the source formatting, adapting the content to the destination styles, pasting a picture, or keeping text only.

Formatted table: Choose this when readers should be able to select and edit the words or numbers in Word. The rows and columns remain structured, and the pasted content is normally a Word table rather than a working Excel grid.
Keep source formatting: Use this when Excel’s fonts, fills, borders, and number display are important. It can make the table look closer to the worksheet, although the result may not match the document’s typography.
Use destination styles: Choose this when the table should better match Word’s document formatting. Excel-specific appearance may change, so check fills, borders, and column widths afterward.
Picture: Use a picture when the visual arrangement matters more than editing individual cells. A picture can be resized as one object, but its text is not directly editable as table content.
Keep text only: Use this when you want the words and values without most of the spreadsheet styling. Depending on the content and paste route, columns may become tab-separated text rather than a formatted table.

For example, a small budget with columns for Item, Planned, and Actual is usually easiest to read and edit as a Word table. A carefully formatted dashboard with merged cells, colored indicators, and precise spacing may be more reliable as a picture if readers only need to view it. There is no single best setting for every range: decide first whether editability, appearance, or updateability matters most.

Keep or remove Excel formatting

Excel formatting communicates information, but it can also create an awkward Word page. A copied range may bring over background colors, font sizes, borders, alignment, and number formats. Dates and currency values usually display according to the cell’s formatting, which is often what readers expect; however, a long value may not fit the Word column width. Check the pasted table for clipped text, unexpected line breaks, and columns that extend beyond the page margins.

If the table is editable, click inside it and use Word’s table tools to adjust its appearance. Word displays contextual table tabs when the cursor is in a table; commands and tab names can vary slightly by version. You can drag column boundaries, change cell alignment, or select a table style. For a wide table, consider changing the relevant page to landscape orientation or reducing unnecessary columns. Avoid shrinking the font so far that the figures become difficult to read.

To remove unwanted visual styling, try a destination-style or text-only paste from the Paste Options button. Another approach is to paste first and then select the table in Word and apply a simpler table style. If the result needs to follow a report’s heading and body-text conventions, text-only paste can be useful, but it may discard the grid structure. In that case, you may need to recreate the table in Word or paste the cells as a table and restyle them.

Paste as plain text or as a Word table

People often say they want to copy text from Excel when they actually want one of two different results: a clean list of cell contents, or a table that keeps the spreadsheet’s rows and columns. For a list, select the relevant cells and use Keep Text Only if that option appears. For a table, use the ordinary paste command and retain the table structure. A range with several columns pasted as plain text may use tab characters between columns and paragraph breaks between rows; those separators are useful for moving data, but they may not look like a finished table in a document.

Word’s Paste Special command gives more control over the representation. In Word for Windows, choose Home > Clipboard > Paste > Paste Special. Depending on the copied content, available formats may include formatted text, unformatted text, a picture, or a Microsoft Excel worksheet object. You can also open Paste Special with Ctrl+Alt+V in Word for Windows. The list is context-sensitive, so do not expect every format to appear for every selection.

A Word table is usually the practical choice for material that needs proofreading, editing, or accessible text selection. Pasting unformatted text can be useful when cleaning up a short list, but it is not automatically a better option for data with meaningful columns. If you choose text only and the values run together, undo immediately with Ctrl+Z and try a table-oriented paste instead.

Link or embed the Excel content

A normal paste creates content in Word that does not automatically stay synchronized with the original workbook. If numbers change later, the pasted table or picture will not necessarily update. For content that should reflect workbook changes, use Paste Special and select a linking option if Word offers one, such as a Microsoft Excel worksheet object linked to the source. A linked object refers back to the workbook, so updates can be reflected in Word when the link is refreshed and the source file is available.

Linking is useful for a recurring report that displays the same range from a maintained workbook. It also introduces dependencies: moving, renaming, or deleting the workbook can break the link, and recipients may not have access to the source location. Word may ask whether to update links when a document opens. Review the result and link behavior before sharing, especially if the document will leave your organization.

Embedding is different from linking. An embedded Excel object is stored within the Word document rather than kept synchronized with the original workbook. Depending on the paste method, a reader may be able to open or edit the embedded spreadsheet object, but changes to the original workbook do not automatically flow into it. Embedding can increase the Word file size, while linking keeps the source separate but depends on its continued availability. For a static report, a regular table or picture is often simpler than either object method.

Make a pasted table fit the document

Excel sheets are designed around a grid, while Word pages have fixed page dimensions and margins. A range that looks tidy on screen can become too wide when pasted, particularly when it has many columns or long headings. Before copying, remove columns the reader does not need, shorten headings where appropriate, and check whether the displayed values are wider than their cells. These small changes can prevent a table from becoming unreadable in Word.

After pasting an editable table, use Word’s table layout controls to adjust widths and alignment. You can also reduce paragraph spacing inside cells or wrap long headings onto more than one line. If the table spans multiple pages, keep the header row visible on later pages where possible by using Word’s repeat-header-row setting. This is preferable to manually copying the heading onto every page, because manually repeated rows can become inconsistent when the table changes.

For a very large dataset, copying every row into a report may not help the reader. Include a concise summary or selected rows in Word and provide the workbook separately when recipients need the full data. If the purpose is to print the entire dataset, check the page layout and print preview in Excel as well as the Word layout; a spreadsheet may be better suited to that task.

Fix common copy-and-paste problems

The table is too wide: Remove unneeded columns, change the page orientation, adjust Word column widths, or use a readable picture only when editing is unnecessary.
Formatting looks different: Open Paste Options and try Keep Source Formatting or Use Destination Styles. Then inspect fonts, colors, number display, and borders instead of judging only the first row.
Only one cell appears: Return to Excel and check that the intended range was selected before copying. Select the full rectangular range, copy again, and click a single insertion point in Word.
Values appear without formulas: This is expected when a range is pasted as a Word table or plain text; Word is not automatically importing the Excel calculation logic. Use an Excel object or link when spreadsheet functionality or a live connection is needed.
Columns run together: Undo, then paste as a table or choose a format that retains separators. Plain text is not guaranteed to preserve a visible grid.
The pasted content will not update: A standard paste is a snapshot. Create a linked object through Paste Special if updates are required, and keep the source workbook in a stable, accessible location.

If a paste produces an unexpected result, undo it before trying another option. Ctrl+Z reverses the recent paste in Word on Windows; Command+Z is the Mac equivalent. Keep in mind that undoing a paste does not change the original workbook, and a linked or embedded object should be checked separately if it has been edited.

Frequently Asked Questions

How do I copy only the text from Excel to Word?
Select the cells, copy them, and use Keep Text Only from Word’s Paste Options when it is available. This removes much of the spreadsheet formatting, but it may also remove the visible table grid.

Will formulas still work after I paste Excel cells into Word?
Usually not when you paste as a Word table, plain text, or picture. Those formats carry displayed content rather than a live Excel calculation. Use a linked or embedded Excel object if spreadsheet behavior is required.

How can I make pasted Excel columns fit on a Word page?
First remove unnecessary columns or shorten headings. Then adjust the Word table width, reduce excess cell spacing, or switch the page to landscape if that suits the document. Check that the text remains readable.

Can I copy an Excel table into Word and keep it updated?
Yes, by using Paste Special and choosing a linking option when available. The Word document then depends on the source workbook remaining accessible, and updates may need to be refreshed.

What is the difference between embedding and linking an Excel range?
An embedded object is stored in the Word file and is not automatically synchronized with the workbook. A linked object points to the workbook and can reflect later changes, but the source file must remain available.

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.