How do I reduce my document to one page?

[Guest]

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?

Thanks to everyone who replies!
(e-mail address removed)

 

[David Biddulph]

Set the Print Area to cover just your used cells.
If it spreads to more than one page after that, Page Setup/ Page will let
you fit to one page.

 

[Guest]

Thanks David but I want to change my document to only be one page.
Maybe I phrased my question badly.
I want to permenantly resave my document as a one page only document.

dragonslay5

 

[David McRitchie]

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/lastcell.htm#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/getstarted.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



"dragonslay5" ...

 

[Guest]

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

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/lastcell.htm#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/getstarted.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



"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?

 

[David McRitchie]

I install the macros in my personal.xls and I run them from
organized toolbar menus. So simple for me. I never
succeed trying to delete the excess rows and columns
manually, but if you do, don't forget to save your file when you've done that.

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

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/lastcell.htm#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/getstarted.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



"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?

 

[David Biddulph]

When you've set Print Area, and Page Setup, those settings remain when you
save the document, and will apply when you reopen the document.