To resize Excel content in Word, select it and drag a corner handle inward or outward; for a pasted Word table, use Table Layout > AutoFit > AutoFit Window. First check whether your spreadsheet is an embedded Excel object, a Word table, or an image, because each type has different resizing controls. These steps are for Word and Excel for Microsoft 365 on Windows.
What You’ll Need
- A Word document containing the spreadsheet content you want to resize.
- Desktop Word for the fullest set of controls, especially if the content is an embedded or linked Excel workbook.
- Optional: the original Excel workbook, if you need to change the displayed range or edit the data rather than just change its size.
Step-by-Step
- Identify what is in the document. Click the spreadsheet once. If it shows a border with small square handles around the whole item, it is likely an embedded or linked Excel object, or an image. Double-click it: if Excel-style cell selection and Excel controls appear, it is an Excel object. If Word shows a grid with table cells and a contextual Table Layout tab, it is a Word table. If Picture Format appears and the content behaves like a picture, it is an image. Press Esc or click outside the item when you finish checking.
- Save a working copy and make room on the page. Save the document before changing the layout, particularly if you are resizing a linked workbook or a complex object. If the content is wider than the page, click in the relevant section and choose Layout > Orientation > Landscape. To reduce the page margins, choose Layout > Margins and select a preset such as Narrow, or choose Custom Margins to set them yourself. These changes give the spreadsheet more space without making its text smaller.
- Resize an embedded or linked Excel object. Click the object once so its outer handles appear. Drag a corner handle toward the center to make it smaller, or away from the center to enlarge it. Use a corner rather than a side handle when you want to preserve the object’s proportions; side handles can stretch it and make cells look distorted. Release the mouse when the object fits the page. Leave a little space between the object and the page margins so it does not look cramped.
- Set a specific size if dragging is imprecise. Select the object and look for a contextual Format tab or a size control on the ribbon. For an image, open Picture Format and use the Height and Width boxes in the Size group. For an Excel object, right-click it and look for a formatting or size dialog; the available controls depend on the object type. Enter the dimensions you want, and keep the aspect ratio locked if that option is shown. If no numerical size controls are offered for the object, use the corner handles and check the result in Print Layout.
- Resize a pasted Excel range that is now a Word table. Click in the table, then open Table Layout, the contextual tab that appears when a table is selected. Choose AutoFit > AutoFit Window to fit the table between the page margins. This adjusts column widths to the available page width; it does not simply scale the whole table like a picture. If columns still look uneven, select the affected columns and use Table Layout > Distribute Columns. You can also drag a column boundary, but check that the change has not made text wrap into too many lines.
- Resize an Excel range pasted as an image. Click the image and open Picture Format. Drag a corner handle to change its overall size, or enter a measurement in the Height and Width boxes. If the picture is too wide, try a landscape page before shrinking it. Enlarging an image beyond its original resolution can make the grid and text blurry, so use the original Excel range or workbook if readers need to zoom in or edit values.
- Check the content and the printed page. Use File > Print to preview the page before distributing the document. Confirm that the spreadsheet is not cut off, its headings and values are readable, and the object has not overlapped other text. If the frame fits but expected rows or columns are missing, double-click the Excel object to inspect its displayed range; changing the frame size does not always change which cells the object contains. Adjust the source range or paste the correct cells if needed.
Common Mistakes
Dragging a side handle and stretching the spreadsheet. A wide object can become oddly compressed or elongated when resized from the middle of an edge. Use a corner handle for a proportional adjustment, then inspect the cell shapes and text.
Assuming every Excel item is an editable workbook. A pasted range may be a Word table or a static image. The object’s appearance alone can be misleading, so check which contextual ribbon tab appears and whether double-clicking opens Excel editing controls. A picture cannot be edited as cells; you must replace it or work from the source workbook.
Shrinking everything to force it onto a portrait page. This may technically fit but leave the numbers too small to read. Try landscape orientation, narrower margins, or a more selective range before reducing the object substantially. For a Word table, AutoFit Window usually makes more sense than scaling the table down as a graphic.
Confusing the object frame with the spreadsheet’s contents. Resizing changes the size of the item on the page, but it may not add missing columns, rows, or worksheets. If the item shows the wrong cells, edit the Excel object or replace it with the intended range.
Forgetting that linked content has a source file. A linked workbook can depend on its original file location. Moving or renaming that file may break the link. If the document needs to travel independently, consider embedding the workbook or pasting a suitable static copy, after checking your organization’s file-sharing requirements.
Tips
- Decide whether readers need to edit the values. An embedded workbook supports editing in Word by double-clicking; a static image is convenient for display but cannot be edited cell by cell.
- For a large dataset, show only the useful range in the document and provide the full workbook separately. A full worksheet shrunk to fit one page is rarely useful to read.
- Use landscape orientation for a wide table, but consider applying it only to the section that needs it. In Word, section breaks let different parts of a document use different page orientations.
- For Word tables, make important headings visible and check how text wraps after AutoFit. A table that fits the page can still be difficult to follow if the columns become too narrow.
- Use Print Preview after resizing, even if the document looks fine on screen. Page boundaries, margins, and printed scaling can reveal clipping that is easy to miss while editing.
- On Word for Mac, the same basic approach applies: select the object and drag a corner, or use the contextual Picture Format or Table Layout controls. Ribbon labels and dialog placement can vary slightly by release. Word for the web may not offer the same controls for embedded Excel objects, so open the file in desktop Word if you cannot select or resize one.
Troubleshooting
The handles do not appear. Click the outer edge of the item, not inside a cell or on text beside it. If a double-click has activated Excel editing, press Esc or click outside the object to return to Word, then select its border. For a table, click in a cell and use the contextual table tabs rather than looking for picture handles.
The spreadsheet keeps changing shape. Undo the last adjustment, select it again, and drag a corner instead of a side handle. If you have a size dialog with a Lock aspect ratio option, turn it on before entering new dimensions. Avoid repeatedly resizing a picture larger and smaller, since a low-resolution image will not gain detail.
The table still runs off the page after AutoFit. Check that the correct table is selected and that the page has usable width. Set the page to landscape or reduce its margins, then apply Table Layout > AutoFit > AutoFit Window again. If a single column contains a long unbroken entry, shorten or wrap that content; AutoFit cannot always make an awkward table easy to read.
Some cells are missing or the object looks blank. Double-click an Excel object and verify the cells and sheet it displays. If it is a linked object, the source workbook may have moved or become unavailable. Reconnect to the correct source or insert the workbook again. If it is only a picture, create a fresh image or paste the correct range from Excel.
The resized item is clipped in print. Open File > Print and check the preview, then confirm the item remains inside the page margins. Reduce its width slightly, change the page orientation, or adjust the margins. Also check whether the item is anchored in a text area or section with a different layout; the page containing it may not share the settings of the rest of the document.
Frequently Asked Questions
How do I resize Excel in Word without distorting it?
Click the item and drag a corner handle, not a side handle. If a size dialog offers Lock aspect ratio, enable it before changing the height or width.
How do I make an Excel table fit one page in Word?
For a Word table, select it and choose Table Layout > AutoFit > AutoFit Window. For an embedded object, try landscape orientation and narrower margins, then resize the object from a corner. Check Print Preview because a wide or long spreadsheet may still need more than one page.
Can I resize just one column in a pasted spreadsheet?
Yes, if the range is a Word table. Drag that column’s boundary or select it and use the table layout controls. If the range is an image, individual columns cannot be changed; edit the Excel source and paste the range again.
Will resizing the object change the Excel cell values?
No. Changing the on-page size changes how large the object appears in Word, not the values in its cells. Double-click an embedded workbook to edit cell content, or open the source file if the object is linked.
Why does my resized spreadsheet look blurry?
It may have been pasted as a low-resolution image or enlarged beyond its original size. Re-copy the range at a useful scale, paste it as an Excel object, or use a Word table when readers need clear text and editable cells.
Related
- How to Password Protect an Excel File from Opening
- Password Protect an Excel File to Open on Windows PC
- Open Excel for the Web in the Desktop App
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Freeze Rows on iPad: A Practical GuideYes. In the Google Sheets app on an iPad, open the spreadsheet, touch and hold the number of…
- Excel Named Range in a Drop-Down List: How to Set It UpYes. In Excel for Microsoft 365 on Windows, create a named range for the list items, then set…
- How to Add a Drop-Down in Excel Using Keyboard ShortcutsTo add a drop-down in Excel for Microsoft 365 on Windows, select the cell or cells, press Alt+D,…
- How to Animate in Microsoft PowerPoint: A Practical GuideTo animate in Microsoft PowerPoint, select text or an object, open the Animations tab, choose an effect, then…
- Excel Group Rows: How to Expand and Collapse Rows EasilyIn Excel for Microsoft 365 on Windows, select the rows you want to fold away, choose Data >…
- Excel Find and Replace Shortcut: Keys, Options, and TipsIn Excel for Microsoft 365 on Windows, press Ctrl+H to open Find and Replace, then enter the text…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.