Thank you David
That's a very complex solution to fix a very simple problem,
now I remember why I hate Excel so much.

"David McRitchie" wrote:

Unless you have formulas in those cells that
look empty, the problem is probably a
"last used cell" problem. Use Ctrl+End
to find the cell that Excel thinks is your last
cell, which is the intersection of the rightmost
used cell and the lowest down used cell.

You can switch between formula view and values
by using Ctrl+` (accent grave to left of number row)
or by using Tools, Options, View, [x] formulas [view].
don't forget to uncheck formula view when done.

What happens is that you insert rows, and you
delete rows. When you delete rows, Excel is not
keeping track of your last used cell but more like
the high-water-mark so tries to print 3 or 4 pages
in your case instead of one.

If it does not match your data, including your
use of formulas then you can reset for a single
sheet using the MakeLastCell on my page
http://www.mvps.org/dmcritchie/excel...m#MakeLastCell

but you can fix all of your sheets at one time
with Debra Dalgleish's macro
Why do my scrollbars go to row 500 -- my data ends in cell E50?,
http://www.contextures.com/xlfaqApp.html#Unused
Warning: merged cells problems -- a merged cell has content only
in the upper left cell of a merged cell group.

If unfamiliar with macros, you will probably want to read how to
install a macro you find in newsgroup or on a website, see
http://www.mvps.org/dmcritchie/excel....htm#havemacro


Do watch out that no one tried to do hidden calculations
in an out of the way place on the worksheet, that simply
spells trouble. Additional information:
Fit Print to Page, and Adjustments to Layout
Location: http://www.mvps.org/dmcritchie/excel/fitprint.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dragonslay5" ...
I have several excel documents that are three or four pages long
but only have cells on page one. Everytime I print out I have to change
my printer settings to page 1 only so I do not print out three blank
pages.

How do I reduce my document to one page?