Setting the Print Area in Microsoft Excel
If you want your headings to repeat,
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
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.
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.
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.
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