Too many pages to print off

D

danc

I have a large spreadsheet that I have a macro set up to sort
information .
When I do a print preview it shows 8 pages of information (which is
what I want) and another 8 pages of nothing.
How do I prevent Excel from printing off the extra pages?
My page break setup is only showing the 8 pages.
All looks good to me.
 
J

Jay

When I do a print preview it shows 8 pages of information (which is
what I want) and another 8 pages of nothing.
How do I prevent Excel from printing off the extra pages?
My page break setup is only showing the 8 pages.
All looks good to me.
Click to expand...

Maybe this will help:

File > Page setup > Page > Scaling >
Fit to “1” page wide by “8” tall
 
J

Justloseit

Select all that you want to print and then go to file, print area and
click set print area. If you save the spreadsheet the print area you
have set will also be saved.
 
Top