Windows  |  Free Downloads

 

 

 

Setting the Print Area in Microsoft Excel

If you want your headings to repeat, click here.

There seem to be so many misconceptions about the Print Range in Excel, and many people set it unnecessarily.

Fit to a Page

One of the few settings you might want to make is to force the data to fit to a page. Please keep in mind that you can't make it perfectly fit a page both horizontally and vertically. Make a choice, which is usually horizontal. To do this, go to FileàPage Setup and click the Fit To option. Click inside the "tall" box and delete the 1 that's there if you don't want it to fit to one page tall, but you do want to limit the horizontal width.

Setting a Print Area

Excel will automatically want to include all cells that contain information. But suppose the only thing you have over in column H is a note to yourself, but you don't want it to print. You can select entire columns to set a print range, there's no need to select all the cells. So, you can select columns A through G, for instance, and hit FileàPrint Area, Set Print Area.

Print Area Too Big

So you didn't set a print area, but Excel wants to print too many pages? Or you set the width to fit to one page wide, and it only fills half a page and it's too small? It's as if Excel is seeing something in cells that don't contain anything? Well, it is...

You may need to clean up these areas of "dirty" cells.

  1. Select the first completely blank column in your worksheet by clicking on its letter. Hold Shift+Ctrl and then hit the Right arrow key until you have selected all the way to Column IV. Hit EditàClearàAll.

  2. Select the first completely blank row in your worksheet by clicking on its number. Hold Shift+Ctrl and then hit the Down arrow key until you have selected all the way to Row 65536. Hit EditàClearàAll.

  3. Save your workbook, and try your print preview again.

OfficeArtilces.com debuted on May 26, 2005.

MrExcel.com provides examples of Formulas, Functions and Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Formulas, Functions and Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

Access®, Excel®, FrontPage®, Outlook®, PowerPoint®, Word® are registered trademarks of the Microsoft Corporation.
MrExcel® TM is a registered trademark of Tickling Keys, Inc.

All contents © 1998-2014 by MrExcel Consulting | All rights reserved

privacy policy