Where is fit to page in word 2010

Microsoft Excel and Word integrate very well with one another, which is convenient when you are copying and pasting data between the programs. But Excel does not work with the same page size limitations that Word does, which can make it difficult to copy large amounts of data from Excel into Word.

This is especially problematic when you need to copy an area from Excel with a lot of columns, as the columns that do not fit in the Word document are simply not displayed on the page. Fortunately there is a simple way to fix this problem and make your Excel table columns fit on one page in Word This tutorial will focus specifically on making a table from Excel fit on one page in Word , but the method below will work on tables from any program that you paste into Word, as everything that we will be doing is occurring within Microsoft Word.

This will also only make it possible to fit all of the columns of the table on one page. If there are too many rows, then the table will still extend to a second page. You can read this article to learn how to paste your Excel table as an image, which can be a much simpler solution when you are working with a very large table where you need to fit all of the rows and columns on one page. Step 1: Open the Microsoft Word document containing the table that is too large to fit on one page.

Step 2: Click somewhere inside the table so that the Table Tools tabs appear at the top of the window. Making a table fit to one page in Microsoft Word is a much more common problem when the table has been added from a different location such as a Microsoft Excel table. Specifically these large tables often extend off the side of the page, which can be resolved by using the steps above to fit the table to the document.

However, large tables added through Word may extend to multiple pages if there are too many rows. This allows the table to be the top elements on its own page, providing additional space to try and fit it on one page.

Learn how to print two pages of your document on one sheet in Word to help save paper. Word will attempt to shrink the document by one page by reducing the size and spacing of the text.

For example, it will shrink the document above to 1 page, or it might shrink a 3-page document down to 2. Tip: Save a copy of your document before using this command. In order to shrink the document, Word decreases the font size of each font used in the document. However, after you save the document and close it, there is no quick way to restore the original font size. You can, however, quickly add it.

The quickest way to add the button is to add it to the Quick Access Toolbar. Click Shrink One Page to select it, and then click the Add button. As you click Shrink Font , Word decreases the size of every font in your document. Need more help? Expand your skills. Get new features first. A subscription to make the most of your time. Try one month free. Was this information helpful? Yes No. Thank you!