software

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.--
danc
------------------------------------------------------------------------
danc's Profile: www.excelforum.com/member.php...oamp;userid=31339
View this thread: www.excelforum.com/showthread...hreadid=522439gt; When I do a print preview it shows 8 pages of information (which is
gt; what I want) and another 8 pages of nothing.
gt; How do I prevent Excel from printing off the extra pages?
gt; My page break setup is only showing the 8 pages.
gt; All looks good to me.

Maybe this will help:

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

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.