To export Excel content to Word, select the cells in Excel, copy them, then paste them into your Word document. For a normal editable table, use the standard paste command; choose Paste Special if you want a linked workbook object or a picture instead. Excel does not have a direct command that saves a worksheet as a Word document, so the best method depends on whether you need to edit the data, keep it connected to Excel, or preserve its appearance.
What You’ll Need
- Microsoft Excel and Word for Microsoft 365 on Windows for the menu paths below. You can also copy and paste between Excel and Word for Mac, though Paste Special choices and menu locations can vary by release.
- The workbook containing the data, saved before you start. If you plan to link the Word content to Excel, save the workbook in a location that will remain available.
- A Word document, either an existing file or a new blank document, and a decision about whether the result should be an editable table, a linked or embedded object, or a static image.
- A selected range that contains only the information you want in Word. A worksheet may contain far more rows or columns than will fit usefully on a document page.
Step-by-Step
- Choose the content in Excel. Open the workbook and select the cells to transfer. Drag across the range, or click the Name Box to the left of the formula bar, type a range such as A1:G42, and press Enter. Replace that example with your own first and last cell. Selecting a defined range is usually more dependable than copying an entire worksheet, especially if the sheet has formatting far beyond the data. Include column headings if readers will need them to understand the values.
- Check the selection before copying. Confirm that the range includes the needed rows and columns, but not totals, notes, or blank areas you do not want in Word. If the worksheet is long or wide, decide whether to transfer it in sections. Copying thousands of rows into a document can make the file slow and difficult to format. If the selection has hidden rows or columns, check whether the copied result includes what you expect; when in doubt, select and copy a clean, visible range.
- Copy the cells. In Excel for Windows, press Ctrl+C, or choose Home > Copy. A moving dashed border around the selection indicates it is copied. On a Mac, press Command+C or choose Edit > Copy. Keep Excel open until the content has been pasted. If you want only a visual snapshot rather than a table, use the picture option described in step 6 instead of copying normally.
- Place the cursor in Word. Open the destination document and click where the table or object should begin. If the content belongs on its own page, insert a page break first with Ctrl+Enter on Windows or Command+Enter on Mac. Leave a blank paragraph before or after the pasted content if you need room for a heading or explanatory text. For a new document, create it in Word before pasting so the content is saved as a Word file rather than left only on the clipboard.
- Paste an editable Word table for most uses. Press Ctrl+V on Windows or Command+V on Mac. Word typically inserts the copied cells as a Word table, with the cell contents available for editing in Word. A Paste Options button may appear near the table. Choose Keep Source Formatting to retain more of Excel’s fonts, colors, and borders, or Use Destination Styles to make the table match the Word document. The exact options and icons can differ between versions. Click in the table and type to check that it behaves as a Word table, not as a picture.
- Fit the table to the page. If the table is too wide, click inside it and use the contextual Table Layout tab in Word. Choose Table Layout > AutoFit > AutoFit Window to fit the table to the available page width. You can also select Layout > Orientation > Landscape for a wide table, or Layout > Margins > Narrow to gain space. These Word layout changes affect the document page; they do not alter the source worksheet. Review the result in Print Layout and check that text is not clipped or reduced to an unreadable size.
- Use Paste Special for a linked or embedded Excel object. Copy the selected cells in Excel, switch to Word, then choose Home > Paste > Paste Special. In the dialog, select Microsoft Excel Worksheet Object. Choose Paste to embed a copy that can be opened and edited with Excel tools inside Word. Choose Paste link to connect the object to the source workbook, then confirm with OK. The linked version can reflect later source changes, but Word needs access to the workbook at its saved location. On Mac, use Word’s Edit > Paste Special if available; the formats offered can differ. If you do not see the Excel object option, use the editable table method or check that both desktop apps are open.
- Paste a picture when appearance matters more than editing. In Excel for Windows, select the range and choose Home > Copy ▼ > Copy as Picture. In the dialog, choose how the picture should look and whether it should represent what is shown on screen or the printed appearance, then click OK. Paste it into Word with Ctrl+V. The result is an image: you can resize or position it, but you cannot edit its individual cell values as a table. On Mac, copy the range and check Word’s Edit > Paste Special for a picture format; if that option is not available in your build, use a screen capture or export a suitable image from Excel.
- Save and verify the Word document. Choose File > Save As in Word, select a folder, and save as a Word Document (.docx). If you used a linked object, keep the workbook and document in a stable location and test the link after saving. Scroll through the document or open File > Print to preview page breaks, repeated headings, scaling, and margins. Reopen the saved document if it will be shared, since checking the saved copy can reveal layout changes that are easy to miss while editing.
For a straightforward report, the standard paste method is generally the simplest: the contents become a Word table that can be edited without relying on the original workbook. Use a link only when the Word copy should be refreshed from Excel, and use a picture when an unchanged visual presentation is the priority.
Common Mistakes
- Copying the entire worksheet by accident. Selecting every row and column can create a huge table with empty space. Select the actual data range instead, and verify its boundaries before copying.
- Expecting a pasted table to stay synchronized. A normal Ctrl+V paste is a separate Word table. Editing the Excel cells later will not update it. Use Paste Special > Paste link if automatic connection to the workbook is important.
- Using a link without considering file access. A linked object may stop updating if the workbook is renamed, moved, deleted, or stored somewhere the recipient cannot access. Keep both files in a stable shared location and send the workbook as well when the reader needs it.
- Choosing a picture when the data needs editing. Pictures preserve a visual layout but do not provide editable cells, usable values, or a live connection. Choose an editable table or object if someone must change or reuse the data.
- Ignoring page width and readability. Pasting a wide table onto a portrait page can cause cramped columns or awkward page breaks. Use landscape orientation or split the range into logical tables rather than shrinking text until it is difficult to read.
- Assuming Excel formatting will transfer perfectly. Excel and Word handle cell widths, fonts, number formats, and page layout differently. Check dates, currency, borders, and column widths after pasting, particularly if the document uses different fonts or page margins.
Tips
- Prepare the range in Excel. Set sensible column widths, remove unnecessary blank rows, and make headings clear before copying. A tidy source range usually needs less repair in Word.
- Repeat headings on long tables. If an editable Word table runs across pages, select its header row and use Table Layout > Repeat Header Rows. This makes the column labels appear at the top of subsequent pages. Check the print preview to confirm the header repeats as intended.
- Use a separate caption or note. Add a short title or source note in Word outside the table. It stays readable if you later adjust the table size and helps explain what the figures represent.
- Keep linked files together. Put the Word document and linked workbook in a shared folder before creating the link. Avoid renaming either file after linking, and test the document from the location where it will be used.
- Check the recipient’s needs. A Word table is convenient for editing text, an embedded Excel object is useful when spreadsheet editing tools are needed, and a picture is suitable for a fixed visual. A recipient may need Excel installed to work comfortably with an embedded spreadsheet object.
Troubleshooting
The content pastes as plain text or loses its formatting. Undo the paste with Ctrl+Z on Windows or Command+Z on Mac, then copy the range again. In Word, use the Paste Options button or Home > Paste dropdown to try Keep Source Formatting. If that still looks wrong, use Paste Special and select a suitable format, or paste as an image if editing the cells is not required.
The table is cut off or spills past the page. Click inside the table and try Table Layout > AutoFit > AutoFit Window. Change the page to landscape using Layout > Orientation > Landscape, or reduce margins with Layout > Margins. If the font becomes too small, split the spreadsheet range into two tables or remove columns that are not needed rather than forcing every column onto one page.
The linked object does not update. First open the source workbook and confirm that the changes were saved. In Word, right-click the object and look for an option such as Update Link. If Word reports that the source cannot be found, restore the workbook to its original location or recreate the link from the current file. A recipient who cannot access the source path may see only the last saved display, so share the workbook or replace the link with a static table or picture.
Paste Special does not show an Excel object. Confirm that you copied cells in the desktop version of Excel, not a screenshot or text from another application, and that you are pasting into desktop Word. The browser versions have more limited clipboard and object-link options. Try the regular paste command for a Word table; if you specifically need an Excel object, use the Microsoft 365 desktop apps and reopen the Paste Special dialog.
The Word document becomes slow or unusually large. A very large embedded object or high-resolution picture can increase file size. Replace it with a smaller selected range, or paste as a Word table if you only need the values and basic formatting. For a picture, resize or crop it in Word, but keep a readable resolution. Save the file, close it, and reopen it to see whether performance improves.
Frequently Asked Questions
Can I export an Excel sheet directly to a Word file?
Excel does not provide a one-click command to save a worksheet as a .docx file. Copy the cells and paste them into Word, then save the document from Word as a .docx.
Will the pasted Word table update when I change Excel?
Not if you used a normal paste; it is an independent Word table. To connect it to the workbook, use Paste Special and choose Paste link. Keep the workbook accessible so Word can retrieve updates.
Can I copy an entire Excel sheet into Word?
You can select a large range, but a full worksheet is usually far too large for a useful Word document. Select the used data, or divide it into sections. Word pages are not designed to display a spreadsheet’s full grid conveniently.
Which method keeps Excel formatting best?
Copying normally and choosing Keep Source Formatting usually preserves the appearance while giving you an editable Word table. A picture can preserve a fixed visual layout more closely, but its cell contents are not editable.
Can I do this in Excel and Word for the web?
Basic copying and pasting may work in the browser, but Paste Special, linked objects, and picture options can be limited or unavailable. Use the Microsoft 365 desktop apps when you need a linked or embedded Excel object.
What is the difference between linking and embedding?
An embedded object stores a copy in the Word document and does not depend on the original workbook for its contents. A linked object refers to the workbook and can be updated from it, but its link can break if the file moves or the reader lacks access.
Related
- How to Enable an Audit Trail in Excel: Track Changes
- Freeze Panes in Excel: How to Edit Rows and Columns
- How to Edit Custom Number Formats in Excel Step by Step
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Insert a Horizontal Line in WordIn Microsoft Word for Microsoft 365 on Windows, type three hyphens on an otherwise empty paragraph and press…
- Conditional Formatting Greater Than a Cell?Yes. In Excel for Microsoft 365, you can use conditional formatting to highlight a cell when its value…
- Combine in Excel: Text, Cells, and DataYou can combine text in Excel with the ampersand operator (&), CONCAT, or TEXTJOIN; for example, with a…
- Change Your Calendar View in Outlook: A Step-by-Step GuideTo change your calendar view in Outlook, open Calendar and choose Day, Work week, Week, or Month from…
- Excel Day Counter: Count Days Between DatesWith a start date in A2 and an end date in B2, enter =B2-A2 to count the days…
- Join Two Sheets in Google Sheets: Methods That WorkTo join two sheets in Google Sheets, decide whether you need to stack their rows, match records using…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.