Too many pages to print off

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

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

Maybe this will help:

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

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