Print Preview doesn't match print in Excel 2010

Sometimes it's just a matter of adjusting a few things to get all the text in a cell to show up when printed. Experimenting with the following will normally get you the results you need:

1. Wrap Text
   • Wrap Text is nothing more that Word Wrap in a cell. This is a great way to have all the text show up in print if you want to keep the column at a fixed width. The downside is that your rows tend to get quite large. Manually adjust your column width for the best look and feel for the workbook. Find out more about Wrap Text.
2. Row and Column AutoFit
   • Use Column AutoFit to fix the width (Text cut off at the end or numbers displaying as ######.) and Row AutoFit to fix the height (Text or numbers cut off at the top or bottom). Find out more about the AutoFit functions.
3. Page Break
   • If part of your workbook prints on a different page, check the Page Break View, and make adjustments as necessary.
     Find out more about the Page Break view.
4. Set Print Area
   • Setting your Print Area incorrectly can cut off cells that need to be printed. Find out more about setting your Print Area.

Workbooks created in older versions of Excel.

If your Workbook was created on an older version of Excel (2003 or earlier), it will open in Compatibility mode. In Compatibility mode, cells can contain 32,767 characters, but only 1024 will be visible in the cell and only 1024 characters can be printed (all 32,767 characters will be visible in the Formula bar). Find out more about the Compatibility Mode.

Need more help?More information about print preview is provided in this Printing and print preview article.

You can also get help from the Microsoft Community online community, search for more information on Microsoft Support or Office Help and How To, or learn more about Microsoft Assisted Support options.