
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.įortunately, there is a simple way to fix this problem and make your Excel table columns fit on one page in Word 2010. You can even learn how to create tables in Excel for an easy way to sort and filter your data.īut 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. Microsoft Excel and Word integrate very well with one another, which is convenient when you are copying and pasting data between the programs. While you might be comfortable making changes in a Excel spreadsheet, like how to change a table boundary, row boundary, or column boundary, or how to perform basic data alignment so that you get the right cell spacing, the table adjusting tolls in Word are a little less extensive. One place where you can run into trouble in Word concerns tables.

While adding a table to Microsoft Word is accomplished from the Insert tab, simply adding the table may not be enough.Ĭomplex Word documents can often need to take advantage of various settings like line and page breaks and settings found on menus like the Paragraph dialog box to make their documents look the way they need.
