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.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Need to concatenate the contents in a number of columns so that it appears in a single column? Excel has no intrinsic way to ...Discover More
When you are developing a worksheet for others to use, you may want to have entries in a particular cell (or cells) be ...Discover More
The radical symbol is used frequently in some branches of mathematics. If you want to insert a radical symbol in a cell, ...Discover More
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.