by Allen Wyatt
(last updated October 25, 2014)
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, and 2013.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
When entering data in a worksheet, you may only want to add information to the cells in a particular range. You can ...Discover More
AutoComplete can help you to more quickly enter information in a worksheet. How it works, behind the scenes, can affect ...Discover More
Want to show a user, in a cell, what you expect their input to look like? Unfortuantely it cannot be done natively in ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
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.