Written by Allen Wyatt (last updated September 10, 2025)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021
Jerald uses Excel quite a bit in conjunction with Word. He creates his financial models in Excel and then pastes the Excel data into a Word document before printing. Every time he pastes the data, the "table" in Word extends beyond the right margin. Jerald wonders if there is something he can do, in Excel, to ensure that the data will stay within the page margins in Word.
There are a few ways you can approach this, with most of the solutions occurring on the Word side of the process. One option is to, in Word and before pasting, create a single-cell table that is the full width of the margins on the page. You can then paste the Excel data into that single cell, which results in Word creating a table within a table. Since the table is bounded by the outer single-cell table, it won't extend beyond the margins of the page.
You can also, within Word, choose from different available pasting options for the table. When you copy the table in Excel and switch to Word, click where you want the data inserted. Then, display the Home tab of the ribbon and, in the Clipboard group, click the down arrow under the Paste tool. From the resulting options you should notice six options in the Paste Options area:
A third option is to try modifying a deeply buried setting in Word. Follow these steps, again within Word:
Figure 1. The Settings dialog box in Word.
If your table extends beyond the right margin after you paste it, you could also follow these steps after the pasting:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13288) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and 2021.
Best-Selling VBA Tutorial for Beginners Take your Excel knowledge to the next level. With a little background in VBA programming, you can go well beyond basic spreadsheets and functions. Use macros to reduce errors, save time, and integrate with other Microsoft applications. Fully updated for the latest version of Office 365. Check out Microsoft 365 Excel VBA Programming For Dummies today!
After months or years of naming things (such as cell ranges), you may find your workbook cluttered with a bunch of names ...
Discover MoreSometimes getting the right thing to show up in a cell can be a bit tricky when working with dates. If you enter a year ...
Discover MoreSelect a range of cells, and one of those cells will always be the starting point for the range. This tip explains how to ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2021-01-02 10:47:50
Philip Andrew
After copying the Excel range to print and pasting it into Word, the Excel values appear in Word as a Table. I simply select the Table in Word (the table's crossed arrows handle, top left), which causes the "Layout" tab to appear in blue text at the right end of the Word Ribbon, which in turn causes the "Convert to Text" tab to appear near the right end of the ribbon dropdown, which, when clicked, all is perfect!
I find Excel's printing capability incredibly crude, at least partly due to the quirky function AutoFit Row Height.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments