Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How do I reduce my document to one page?

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!

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 620
Default How do I reduce my document to one page?

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.
--
David Biddulph

"dragonslay5" wrote in message
...
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!



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How do I reduce my document to one page?

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 Biddulph" wrote:

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.
--
David Biddulph

"dragonslay5" wrote in message
...
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!




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 903
Default How do I reduce my document to one page?

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?




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default How do I reduce my document to one page?

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?







  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 903
Default How do I reduce my document to one page?

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.

"dragonslay5" wrote in message ...
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?







  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 620
Default How do I reduce my document to one page?

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.
--
David Biddulph

"dragonslay5" wrote in message
...
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 Biddulph" wrote:

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.
--
David Biddulph

"dragonslay5" wrote in message
...
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!






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page break says it has been inserted but does not respond Granite_Plow New Users to Excel 6 January 11th 07 01:28 AM
Fixing a Total on a page Jimbob Excel Worksheet Functions 9 November 2nd 06 09:26 AM
How do I delete page 2 of a 2-page document? Katie New Users to Excel 3 June 14th 06 04:55 PM
Can't delete a page break Suhail Excel Discussion (Misc queries) 4 July 7th 05 06:49 PM
Automatically Saving an Excel Document as a Web Page Danimagus Excel Discussion (Misc queries) 0 May 31st 05 07:32 PM


All times are GMT +1. The time now is 04:52 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"