How do I delete unwanted extra pages on Excel worksheets

[Guest]

I have a worksheet in Excel which I do scheduling with. I keep getting the
Header printed out on it, and then as a page 2. I don't see how to delete the
page two on the worksheet as it doesn't show. But will print. How do I delete
that second page in the worksheet? Am using Microsoft Office Pro 2003.

 

[Guest]

There are probably cells with blank spaces in them below the end of your
data. What I do when this happens is I do a print preview, then go back onto
the sheet and highlight a whole bunch of blank rows just under the 1st page
break. This will usually get rid of any blank spaces and thus shoyuld only
print your one page of data.

 

[Debra Dalgleish]

There are instructions here for manually or programmatically reseting
the used range:

http://www.contextures.com/xlfaqApp.html#Unused

That should prevent unused pages from printing

 

[broro183]

Hi Roger,

To see where the page breaks are, change the view to "pagebreak
preview" [alt + v + p]. The blue lines that appear show the edges of
your pages & can be dragged with the mouse to suit.
Another approach is to clear the existing print area [alt + f + t + c],
select the range you want printed & set the print area [alt + t + s].

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...

 

[broro183]

Ooopps!

The shortcut for setting the print area should be [alt + f + t + s] (in
my version of excel anyway).

hth
Rob Brockett
NZ
Always learning & the best way to learn is to experience...