Prints too many pages
 

Hi,
I have a spreadsheet with a header. I have it set to print only pages that
have text. Even though only 1 page has text it prints 2 pages (the 2nd page
just has the header). How can I prevent it from printing the extra page?

Thanks,
Mickey

Prints too many pages
 

Mickey

GotoviewPage break Preview, Drag the blue lines to the area you want to
print.
Or gotoFileprint areaclear print area, then select what you want to print
and go back and "set print area".

Mike Rogers

"Mickey" wrote:

Hi,
I have a spreadsheet with a header. I have it set to print only pages that
have text. Even though only 1 page has text it prints 2 pages (the 2nd page
just has the header). How can I prevent it from printing the extra page?

Thanks,
Mickey

Prints too many pages
 

Even if I delete the header 2 pages print. What am I doing wrong?

Thanks

"Mike Rogers" wrote:

Mickey

GotoviewPage break Preview, Drag the blue lines to the area you want to
print.
Or gotoFileprint areaclear print area, then select what you want to print
and go back and "set print area".

Mike Rogers

"Mickey" wrote:

Hi,
I have a spreadsheet with a header. I have it set to print only pages that
have text. Even though only 1 page has text it prints 2 pages (the 2nd page
just has the header). How can I prevent it from printing the extra page?

Thanks,
Mickey

Prints too many pages
 

Page Setup/ Page/ Fit to 1 page wide by 1 tall ?
--
David Biddulph

"Mickey" wrote in message
...
Even if I delete the header 2 pages print. What am I doing wrong?

"Mike Rogers" wrote:

Mickey

GotoviewPage break Preview, Drag the blue lines to the area you want
to
print.
Or gotoFileprint areaclear print area, then select what you want to
print
and go back and "set print area".

"Mickey" wrote:

Hi,
I have a spreadsheet with a header. I have it set to print only pages
that
have text. Even though only 1 page has text it prints 2 pages (the 2nd
page
just has the header). How can I prevent it from printing the extra
page?

Prints too many pages
 

I already have it set up that way. Any other suggestions? Thanks

"David Biddulph" wrote:

Page Setup/ Page/ Fit to 1 page wide by 1 tall ?
--
David Biddulph

"Mickey" wrote in message
...
Even if I delete the header 2 pages print. What am I doing wrong?

"Mike Rogers" wrote:

Mickey

GotoviewPage break Preview, Drag the blue lines to the area you want
to
print.
Or gotoFileprint areaclear print area, then select what you want to
print
and go back and "set print area".

"Mickey" wrote:

Hi,
I have a spreadsheet with a header. I have it set to print only pages
that
have text. Even though only 1 page has text it prints 2 pages (the 2nd
page
just has the header). How can I prevent it from printing the extra
page?

Prints too many pages
 

Do you have contents in your last column that overflow from that column to
subsequent columns? You could try turning on wordwrap for the last column
(or setting it to align from the right, not from the left).
--
David Biddulph

"Mickey" wrote in message
...
I already have it set up that way. Any other suggestions? Thanks

"David Biddulph" wrote:

Page Setup/ Page/ Fit to 1 page wide by 1 tall ?
--
David Biddulph

"Mickey" wrote in message
...
Even if I delete the header 2 pages print. What am I doing wrong?

"Mike Rogers" wrote:

Mickey

GotoviewPage break Preview, Drag the blue lines to the area you
want
to
print.
Or gotoFileprint areaclear print area, then select what you want to
print
and go back and "set print area".

"Mickey" wrote:

Hi,
I have a spreadsheet with a header. I have it set to print only
pages
that
have text. Even though only 1 page has text it prints 2 pages (the
2nd
page
just has the header). How can I prevent it from printing the extra
page?