Paste Excel Table to Word Fit to Page
To paste an Excel table into Word and have it fit the page, use Paste Special > Microsoft Excel Worksheet Object or paste as a picture, then adjust the column widths and scale. The most reliable method is to paste the table, then resize it using the table handles or change the page orientation to landscape for wide tables. This article explains the exact steps, common pitfalls, and alternative methods so you can get a clean, printable result every time.
Why Excel Tables Don’t Fit Automatically
When you copy a range of cells in Excel and paste it into Word, Word imports it as a table with the same column widths as in Excel. Those widths are measured in points (1 inch = 72 points) and often exceed the printable area of a Word page, especially if your Excel sheet is wide or has long text in cells. The default Word page is 8.5 x 11 inches with 1-inch margins, leaving 6.5 inches of printable width. If your Excel table is, say, 8 inches wide, it will overflow the right margin.
Word does not automatically scale imported tables to fit the page. It preserves the original column widths, so you must manually adjust them or use one of the methods below to force the table to fit.
Method 1: Paste and Resize the Table (Quickest)
This works for most tables and takes less than a minute.
- In Excel, select the range you want to copy (e.g., A1:F20). Press Ctrl+C.
- In Word, place your cursor where you want the table and press Ctrl+V to paste.
- Click anywhere inside the pasted table. A small square handle (the table move handle) appears at the top-left corner of the table. Click it to select the entire table.
- Right-click the selected table and choose Table Properties.
- Under the Table tab, check Preferred width and set it to 100% (or a specific value like 6.5 inches). This makes the table stretch to the full text width.
- Now go to the Layout tab (under Table Tools) and click AutoFit > AutoFit to Window. This instantly resizes all columns to fit within the margins.
If the table is still slightly too wide, you can manually drag the right edge of the table to the left, or adjust individual column widths by dragging the column borders.
Method 2: Paste Special as an Excel Object
This method embeds the Excel data as an object that you can scale like a picture. It keeps the formatting and allows you to edit the data by double-clicking, but it can be harder to control column widths.
- Copy the range in Excel.
- In Word, go to Home > Paste > Paste Special.
- Choose Microsoft Excel Worksheet Object and click OK.
- The table appears as a single object. Click it to select, then use the corner handles to resize it proportionally. Hold Shift while dragging to keep the aspect ratio.
- To ensure it fits the page width, right-click the object, choose Size and Position, and set the width to 6.5 inches (or your page’s printable width).
Note: The object may appear with a white background and can be hard to edit if you need to change individual cells. For most users, pasting as a regular table (Method 1) is more practical.
Method 3: Paste as a Picture (When You Don’t Need to Edit)
If you only need a visual snapshot of the table (e.g., for a report or presentation), pasting as a picture guarantees it will fit if you resize it.
- Copy the range in Excel.
- In Word, go to Home > Paste > Paste Special.
- Choose Picture (Enhanced Metafile) or Bitmap.
- The table is pasted as an image. Click it and drag the corner handles to reduce its size until it fits within the margins.
You can also take a screenshot of the Excel range (using Alt+Print Screen or the Snipping Tool) and paste that image into Word. This is the simplest method if you never need to edit the data.
Adjusting Page Setup for Wide Tables
Sometimes the table is too wide to fit even after resizing columns, especially if it has many columns. In that case, change the page orientation to landscape.
- In Word, go to Layout > Orientation > Landscape.
- This gives you 9 inches of printable width (with 1-inch margins) instead of 6.5 inches.
- If the table still doesn’t fit, reduce the margins: Layout > Margins > Narrow (0.5 inches on each side) gives you 10 inches of width.
You can also set the table to a specific width in Table Properties – just type a number like 9 inches.
Common Mistakes and How to Avoid Them
- Mistake: Pasting with Ctrl+V and then trying to drag the table’s right edge, but the table doesn’t move because it’s anchored to the paragraph. Fix: Use the table move handle to select the whole table first.
- Mistake: Forgetting to check the page margins. If your margins are 1.5 inches, the printable width is only 5.5 inches. Fix: Check the ruler or go to Layout > Margins to see the actual width.
- Mistake: Using AutoFit to Contents instead of AutoFit to Window. AutoFit to Contents makes columns as wide as their content, which can make the table wider than the page. Fix: Always choose AutoFit to Window after pasting.
- Mistake: Pasting a huge range (e.g., 1000 rows) – it will span many pages. Fix: Copy only the rows you need, or use the Print Area in Excel to set a specific range before copying.
When to Use Each Method
- Regular table paste (Method 1): Best when you need to edit the data in Word, apply Word formatting, or the table is small/medium.
- Excel object (Method 2): Best when you want to keep the Excel formatting exactly and edit the data by double-clicking, but you don’t mind the object being less flexible.
- Picture (Method 3): Best when the table is just for display and you don’t need to edit it.
- Landscape orientation: Best for tables with many columns (e.g., 10+ columns) or very wide text.
Frequently Asked Questions
Why does my pasted table go off the page?
Because Word preserves the column widths from Excel. If the total width exceeds the printable area (page width minus margins), the table overflows. Use AutoFit to Window or reduce margins/orientation to fix it.
How do I make the table fit on one page without cutting off columns?
First, try AutoFit to Window. If that makes columns too narrow, switch to landscape orientation or reduce margins. You can also change the font size in the table (select the table, then reduce the font size) to allow narrower columns.
Can I paste an Excel table into Word and keep the formulas?
No. When you paste as a regular table, formulas are replaced with their calculated values. To keep formulas, you must paste as an Excel object (Method 2) or link the data (Paste Special > Paste Link > Microsoft Excel Worksheet Object).
What is the difference between “AutoFit to Window� and “AutoFit to Contents�?
AutoFit to Window resizes the table to fit the width of the page’s text area. AutoFit to Contents sizes each column to fit its content, which can make the table wider than the page if content is long.
How do I paste an Excel table into Word without losing the formatting?
Use Paste Special > Microsoft Excel Worksheet Object to keep the exact Excel formatting. Alternatively, paste as a regular table and then apply Word’s table styles to match your document.
Can I link the Excel table so it updates in Word when I change Excel?
Yes. Copy the range in Excel, then in Word use Paste Special > Paste Link > Microsoft Excel Worksheet Object. This creates a link that updates when you open the Word document (if you choose to update links).
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.