To resize an Excel table in Word, first identify how it was inserted: select the object and drag a corner handle to scale an embedded spreadsheet or picture, or click inside a Word table and adjust it through Table Layout or Table Properties. The right method depends on whether your content is an editable Excel object, a regular Word table, or an image.
Before changing the size, consider whether you want to alter only how the content appears on the page or also change the underlying spreadsheet. Resizing an object in Word changes its displayed size, not the cell values or column widths in its source workbook.
What You’ll Need
- Microsoft Word for Microsoft 365 on Windows. The core steps are similar in Word for Mac, though ribbon labels and dialog layouts can differ slightly.
- The Word document containing the Excel content. If the content is linked to a separate workbook, keep that workbook available in case you need to edit its data.
- A mouse or trackpad for selecting and dragging handles. For precise sizing, you can use the size fields available for the selected object or the Word table properties.
Step-by-Step
- Save a working copy and identify what you are resizing. Open the document and, if it is important, use File > Save As to make a copy before changing its layout. Click the content once. If you see a rectangular border with handles around the entire item, it may be an embedded Excel worksheet or a picture. If a text cursor appears inside cells and Word shows the contextual Table Design and Layout tabs, it is a Word table. If the ribbon shows Picture Format, the content is an image. Knowing which type you have prevents you from using a resizing method that cannot work.
- Choose whether you need to resize the whole object or its table cells. A single click on an embedded Excel object selects the object as a unit; dragging its outer handles changes the size of the displayed spreadsheet. Double-clicking the object opens its Excel editing area, where you can adjust the spreadsheet itself. A Word table is different: you can change the overall table width, individual column widths, row heights, or cell spacing. Decide whether the goal is to fit the page, make text easier to read, or alter the proportions of specific columns.
- Resize an embedded Excel worksheet object with its handles. Click once on the worksheet so the outer selection border and sizing handles appear. Point to a corner handle until the pointer indicates that you can resize, then drag inward to make the object smaller or outward to enlarge it. A corner handle is usually the best choice when you want the worksheet to keep its overall proportions. Check the result against the page margins and nearby text. Avoid dragging a middle handle far if it makes the object look unusually stretched or compressed. Click outside the object when you are done to view it without the selection border.
- Set an embedded object’s dimensions more precisely if needed. Select the object and look for its size controls on the ribbon. Depending on the object and Word build, you may be able to enter a height and width in the contextual Format tab. You can also right-click the object and choose Format Object; if the dialog offers a Size section or tab, enter the dimensions there and confirm. If those controls are not available for your selected object, use the corner handles and adjust gradually. Word for Mac has similar object-formatting controls, though the dialog arrangement and tab names may differ.
- Resize a Word table to fit the page. Click inside the table, then open the contextual Layout tab under Table Tools. Choose AutoFit, then AutoFit Window to make the table fit the available page width. This is useful when the table extends beyond the right margin. AutoFit Contents instead adjusts columns to their contents, which can make the table wider if a cell contains long text. If the table should stay at a fixed width, choose Fixed Column Width after setting it rather than repeatedly applying AutoFit.
- Enter a specific Word table width. Right-click inside the table and choose Table Properties. On the Table tab, select Preferred width and enter a value, then choose a measurement unit if Word presents one. Make sure the value is no wider than the space between the page margins. Use the Options button in the same dialog if you need to change the space between cell contents and their borders. On Word for Mac, Table Properties is also available from the table’s context menu or the Table menu, but the dialog may be arranged differently. Apply the change and inspect the table in Print Layout.
- Adjust individual columns or rows when the overall width is right. Move the pointer over a column boundary until the resize pointer appears, then drag the boundary left or right. For greater control, select the relevant cells or column and use the cell-size controls on the Table Layout tab. You can also open Table Properties and use the Column or Row tab to specify dimensions. If you change one column, check adjacent columns: Word may redistribute space or wrap text differently depending on the table’s other settings.
- Handle a pasted picture differently. If selecting the content reveals Picture Format, Word is treating it as an image, not an editable spreadsheet or Word table. Select the image and drag a corner handle to change its display size. For exact dimensions, use the Height and Width fields in Picture Format. If the image appears distorted, undo the change and resize from a corner rather than a side. You cannot edit individual cells in a picture; return to the Excel source and paste the content in an editable format if you need to change cell data.
- Review the page and save. Check that the resized item fits within the margins, does not overlap other content, and remains readable at the intended print or screen size. Use File > Print to preview page breaks and scaling before printing. If changing the size causes a table to split awkwardly, adjust the page orientation or margins, or move the table to a page with enough room. Save the document once the layout looks right.
Common Mistakes
Dragging a cell boundary when you meant to scale the whole worksheet. If the object is active for Excel editing, you may be changing a column width inside the spreadsheet rather than the object’s size on the Word page. Click outside the editing area, then click once on the outer border to select the complete object.
Expecting an image to behave like a spreadsheet. A screenshot or pasted picture has no editable cells. Resizing it changes its displayed dimensions only. Go back to the source workbook if you need to correct values, formatting, or the number of visible rows and columns.
Making the table fit by shrinking it until the text is unreadable. AutoFit Window can solve a width problem, but it does not guarantee comfortable reading. If the table is still crowded, consider landscape orientation, narrower page margins, shorter headings, or splitting a very wide table into two sections.
Confusing the Word copy with the Excel source. An embedded worksheet usually stores a separate copy inside the document; editing it does not necessarily update the original workbook. A linked object can reflect changes from its source file, so resizing its display is not the same as changing the source spreadsheet. Keep the original file and avoid moving it if the link depends on its location.
Changing the whole document’s zoom instead of the object’s size. Word’s zoom controls change how large the page looks on screen, not the printed dimensions of a table or object. Use the selected object’s handles, its formatting controls, or Table Properties instead.
Tips
- Use Print Layout and Print Preview when the final result is intended for paper. A table that looks fine at a high screen zoom may still be too small on a printed page.
- For an embedded worksheet, resize the object first, then double-click it if you need to adjust which rows or columns are visible. Editing the embedded sheet and changing the object’s display size are separate actions.
- For a Word table, use AutoFit Window as a quick starting point, then refine important column widths manually. This can produce a more readable result than relying on automatic sizing alone.
- Consider switching only the page containing a wide table to landscape orientation. In Word, place section breaks around that page, then use Layout > Orientation > Landscape while the cursor is in that section. Check section breaks afterward, since they can affect headers, footers, and pagination.
- When the table is too tall rather than too wide, check whether rows are breaking across pages. Select the rows, open Table Properties, and review the Row tab’s page-break setting if available. Keeping a heading row with the following row can also make a multipage table easier to follow.
- On Mac, use the same selection clues—outer object handles, a cell cursor, or Picture Format—to identify the content type. Ribbon placement and dialog names may vary by Word release, but the object-versus-table distinction still applies.
Troubleshooting
The handles do not appear. Click the item once, not inside a cell or text area. If a cursor appears inside a spreadsheet, press Esc or click outside the object and select its border again. If the item is part of a header, footer, or grouped object, double-click the relevant area or select the object from its edge.
The table is wider than the page after AutoFit. Confirm that you used Layout > AutoFit > AutoFit Window while the cursor was inside the Word table. Then inspect Table Properties for an oversized preferred width or cell margins. Long unbroken text, such as a web address, can also force a column wide; shorten it, insert suitable breaks, or move it to a note outside the table.
The text gets tiny when the object is made smaller. That is normal for a scaled embedded worksheet or image: its contents shrink with the object. Enlarge it, reduce the displayed spreadsheet area by editing the embedded sheet, or use a Word table whose text can wrap and reflow. If the page is too narrow, try landscape orientation rather than reducing the object further.
The object changes shape or looks blurry. Undo the last resize and use a corner handle or enter dimensions in the format controls. Pictures may lose clarity when enlarged beyond their original resolution. Embedded spreadsheet objects can also look different at different zoom levels; compare the document in Print Preview before deciding whether the result is acceptable.
Changes in Excel do not appear in Word. First determine whether the item is embedded or linked. Double-clicking an embedded object edits its stored copy, not necessarily the workbook you opened separately. For a linked object, check that the source workbook still exists at the expected location and use Word’s link-update options if available. If you cannot identify or restore the link, copy the required range from Excel and paste it into Word again using the intended format.
Frequently Asked Questions
Can I resize an Excel table in Word without changing the Excel file?
Yes. Dragging the outer handles of an embedded object changes its size on the Word page, not the source workbook’s cell values. An embedded worksheet is commonly a stored copy. If the content is linked, keep in mind that editing the source and resizing its Word display are separate operations.
How do I make an Excel table fit one page in Word?
If it is a Word table, click inside it and use Layout > AutoFit > AutoFit Window to fit the width. For an embedded object, reduce its displayed size with a corner handle. If it is too tall to fit, shrinking may make it unreadable; consider landscape orientation or splitting the content across pages.
Why can’t I resize individual cells?
You may have selected an embedded worksheet or a picture instead of a Word table. Double-click an embedded worksheet to edit its Excel cells, or return to Excel if it is an image. To adjust cells directly in Word, the content needs to be a Word table, with the contextual Table Design and Layout tabs visible.
Does resizing in Word change column widths in Excel?
Not when you drag the outer handles of the object; that scales how the object appears in Word. To change worksheet column widths, double-click the embedded worksheet and adjust them in its Excel editing area. The original workbook is updated only when you edit that workbook or work with a linked object as appropriate.
Can I resize a pasted Excel table on Word for Mac?
Yes. The same basic methods apply: select the object and drag a corner handle, or click in a Word table and use its layout controls or Table Properties. Mac ribbon labels and dialog placement may differ from Windows, so use the selection border and contextual tabs to identify which kind of content you have.
Related
- How to Print in Microsoft Excel: A Step-by-Step Guide
- Password-Protect an Excel File So It Can’t Be Opened
- Protect an Excel Workbook From Opening with a Password
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Keyboard Shortcuts: Settings and CustomizationExcel for Microsoft 365 on Windows does not provide one settings page where you can remap every built-in…
- How to Add Footnotes in WordTo add a footnote in Word for Microsoft 365 on Windows, place the cursor where the note marker…
- Microsoft Word: How to Add FootnotesTo add a footnote in Microsoft Word, place the cursor where its reference number should appear, then choose…
- How to Schedule Send an Email in the Microsoft Outlook AppTo schedule an email in Outlook, write your message, open the menu beside Send, choose Schedule send, and…
- Google Sheets Count If Not Blank: Formulas and FixesTo count cells that are not blank in Google Sheets, use =COUNTA(A2:A100), replacing the range with your own.…
- Delete a Blank Page in Word: Step-by-Step GuideTo delete a blank page in Word, turn on formatting marks, find the paragraph mark or break creating…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.