How to Make a Table Fit on One 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 2010.


Fit an Excel Table to One Page in Word 2010

This tutorial will focus specifically on making a table from Excel fit on one page in Word 2010, 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.

open the document with the table



Step 2: Click somewhere inside the table so that the Table Tools tabs appear at the top of the window.

click inside the table to display the table tools



Step 3: Click the Layout tab under Table Tools.

click the layout tab



Step 4: Click the AutoFit button in the Cell Size section of the ribbon at the top of the window, then click the AutoFit Contents option.

how to fit a large table on one page in word 2010



Learn how to print two pages of your document on one sheet in Word 2010 to help save paper. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.