Copy Excel Sheet to Word: Methods and Formatting

To copy Excel data into Word, select the cells in Excel, press Ctrl+C, click where the content should go in Word, and press Ctrl+V. Choose a paste option to keep the spreadsheet formatting, turn the data into a Word table, link it to the workbook, or insert it as a picture.

The quickest way to copy Excel cells

For a normal table, copying a specific range is usually the clearest and most reliable approach. In Excel for Microsoft 365 on Windows, drag across the cells you need, press Ctrl+C, switch to Word, place the cursor in the document, and press Ctrl+V. The pasted content is generally editable as a Word table or text, depending on the paste option selected.

After pasting, look for the Paste Options button beside the new content. Its choices depend on the Excel and Word versions and on what is on the clipboard. Common options include keeping the source formatting, matching the Word document’s styles, linking the data, or pasting it as a picture. Hover over an option when available to preview the result before choosing it.

Excel for Windows: Ctrl+C copies the selection; Ctrl+V pastes it.
Excel and Word for Mac: use Command+C and Command+V. Paste Special may be available from the Edit menu, though its location and choices can vary by version.
Excel for the web: ordinary copy and paste work in many browser situations, but advanced Paste Special and object-linking choices may be limited. Use the desktop apps when you need precise control over embedded or linked content.

Before copying, check that the selected range includes the intended headings and totals but not stray blank rows or columns. A compact selection makes the document easier to format and avoids bringing unwanted worksheet content into Word.

Choose the right paste format

The best format depends on what readers need to do with the copied material. A Word table is convenient for document editing, an Excel object preserves spreadsheet behavior, a link can reflect later workbook changes, and a picture is useful when appearance matters more than editing.

Formatted table or text: suitable for reports where people may edit wording, adjust table styling, or use Word’s page-layout tools. Source colors and number formats may carry over, but the result is no longer a live Excel range.
Unformatted text: useful when you want to apply Word’s own formatting from scratch. Depending on the selected cells and paste route, tabs may separate columns and paragraph breaks may separate rows.
Excel worksheet object: keeps spreadsheet content in an embedded workbook-like object. Readers can often open or edit it through Excel functionality by double-clicking, but it is not the same as a Word table.
Linked Excel object: can display workbook data in Word while retaining a connection to the source file. This is useful for material that changes regularly, but the link depends on the source workbook remaining available at its expected location.
Picture: preserves a visual snapshot and prevents accidental edits to individual values. It is not searchable or directly editable as table data, and scaling it too far can make text difficult to read.

For a routine report table, start with a formatted table. Choose an object only when spreadsheet editing or a source connection is genuinely needed; choose a picture for a fixed visual layout such as a carefully formatted schedule.

Copying a whole worksheet or a large area

A worksheet tab cannot be transferred into Word as a working Excel sheet with all of its rows, columns, formulas, and workbook features intact. Instead, copy the part of the sheet that belongs in the document, or insert an Excel object if readers need spreadsheet functionality. Excel worksheets can contain up to 1,048,576 rows and 16,384 columns, far beyond what a Word page can sensibly display.

To select the used area in Excel, click a cell within the data and use Ctrl+A; depending on the layout, the first press selects the current data region and another press can select more of the sheet. Review the highlighted cells before copying. Alternatively, drag-select a clearly defined range, or select the row and column headers for a deliberate section. Avoid selecting the entire worksheet grid just to copy a small table.

Ctrl+Shift+End can extend a selection toward the last cell Excel considers used, but formatting in apparently blank cells may make that area larger than expected. A safer option for a large sheet is to select the exact range using the Name Box to the left of the formula bar: type a range such as A1:F40, press Enter, and then copy. On Mac, keyboard combinations can differ by keyboard and Excel release; using the Name Box or selecting with the mouse avoids shortcut uncertainty.

For a wide table, consider whether every column belongs in the document. Removing helper columns or splitting the material into two smaller tables can produce a more readable result than shrinking all columns until the text is tiny.

Embedding versus linking Excel data

An embedded object stores a copy of the spreadsheet content inside the Word document. It does not normally update just because someone edits the original workbook later. Embedding is appropriate when the document should travel independently and the recipient may need to inspect or edit the copied spreadsheet content. The trade-off is a larger document and a separate copy that can diverge from the source.

A linked object refers to an external workbook. If the workbook changes, Word may be able to update the displayed content when the document opens or when the link is refreshed. The exact prompts and update behavior depend on application settings and the file location. If the source is moved, renamed, stored somewhere the recipient cannot access, or excluded when the document is shared, the link may not work for that person.

In Word for Windows, advanced options are commonly available through Home > Paste > Paste Special after copying the Excel selection. The dialog may offer a choice to paste or paste link, along with formats such as an Excel worksheet object or a picture. Available entries vary with the clipboard contents and installed applications. If the command is absent or the choices differ, use the Paste Options button or consult the menus in the version you have.

Before distributing a linked document, test it from the recipient’s perspective. Keep the workbook in a shared, accessible location and provide it when needed. If a self-contained file is more important than automatic updates, embed the content or paste a static table instead.

Keep the table readable in Word

Excel’s grid is designed for worksheets, while Word’s pages have fixed printable dimensions. A table that looks comfortable on screen may overflow a page, wrap headings, or become too small when pasted into a portrait document. Check the document at its intended page size and print layout, not only in the editing view.

Use Word’s landscape orientation for a table that is only moderately wider than the page. In Word for Windows, the usual route is Layout > Orientation > Landscape.
Try Layout > Margins to adjust the available page width, while keeping the document’s required margins in mind.
In Word, select the table and use Table Layout > AutoFit to fit the table to the window or its contents. Ribbon labels can differ slightly across versions.
Shorten unnecessarily long headings, wrap text where appropriate, and repeat or restate context if a table must continue on another page.
Use a readable font size. If the table only fits after substantial shrinking, split it, remove nonessential columns, or use a different page layout.

When a table spans pages, inspect where Word breaks rows and whether column headings remain clear. A copied table may not inherit the same page-break behavior as the Excel sheet. For a large report, it can be better to paste a summary table into the main text and place detailed data in an appendix or separate workbook.

Common problems and practical fixes

The pasted table loses its colors or borders: choose a source-formatting option in Paste Options, or use Paste Special if available. If you prefer Word’s design, select a destination-style option and apply a Word table style afterward.

Numbers or dates look different: Excel display formats and Word formatting are not always identical. Confirm the displayed values in Excel before copying. If exact appearance is essential, a picture can preserve the visual result; if values must remain editable, check and adjust the Word table after pasting.

The table is too wide: switch to landscape, reduce margins within document requirements, or select fewer columns. Avoid relying on extreme font reduction, which can make the document inaccessible to readers.

Only some cells appear: check the selection outline in Excel before copying, and make sure the desired cells are not hidden or outside the selected range. If filtered data is involved, verify which visible rows are included in the copied selection.

The linked content does not update: confirm that Word can reach the original workbook and that the link has not been broken by moving or renaming the file. For recipients who cannot access the same source, replace the link with a static table or embed the content.

The content pastes as an image unexpectedly: undo the paste with Ctrl+Z in Word, then use the Paste Options button to choose an editable format. On Mac, use Command+Z to undo. If the correct option is unavailable, recopy the cells and try Paste Special in the desktop applications.

Alternatives when copying is not ideal

If the table changes often, consider whether the Word document needs to contain the data at all. A shared workbook may be a better source of truth, with Word holding a short summary and a reference to the file. This avoids maintaining two competing copies, though it requires readers to have access to the workbook.

For a report that needs a fixed appearance, export or capture only the relevant range rather than an entire worksheet. A picture can be practical for a small, stable table, but include an accessible text explanation when the information matters to readers using assistive technology. For complex data, provide the spreadsheet as a companion file so readers can sort, filter, or inspect values that a static document cannot expose conveniently.

Frequently Asked Questions

Can I copy an entire Excel sheet into Word?
Not as a complete, functioning worksheet that retains every Excel feature. Copy a selected range as a table or picture, or insert an Excel object if spreadsheet-style editing is needed. A full grid is far too large for a normal Word document.

How do I copy Excel to Word without losing formatting?
After pasting, choose a source-formatting option in the Paste Options button. If that is unavailable, try Home > Paste > Paste Special in Word for Windows and select a suitable format. Check page width because preserved Excel formatting can still overflow the Word page.

Can a Word table update when the Excel file changes?
Yes, if you paste the content as a link and Word can still access the source workbook. A regular pasted table or embedded copy is generally a snapshot, not a live connection to later edits in the original file.

Should I paste the sheet as a picture or a table?
Choose a table when people need to edit or search the values. Choose a picture when the layout must stay fixed and the content is not expected to change. Pictures are less flexible and can become hard to read if enlarged or reduced.

Why does my Excel table not fit on a Word page?
Excel columns do not automatically adapt to Word’s page width. Try landscape orientation, suitable margins, fewer columns, or a split table. Keep the type large enough to read rather than forcing the entire range onto one page.

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.