How do I delete unwanted extra pages on Excel worksheets

R

RogerD

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.
 
T

tim m

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.
 
B

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...
 
B

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...
 
Top