PRINTING IN FILTERED AREA

[peyman]

Hi,
I've got a file with 700 lines and when I wanna print the selected area in
a filter mode ,what comes out is in different pages . I can see some dashed
lines in the filtered area showing different pages.In the "page break
preview" there are also a couple of solid blue lines besides in between the
lines the dashed ones that I don't know how to get rid of them.
Any help please?
Thanx

 

[Peo Sjoblom]

One way would be to copy the filtered range to a new sheet, print and once
you have printed discard the temporary print sheet?

--


Regards,


Peo Sjoblom

 

[peyman]

Thanx,But I have to print out very often and it'll take too much time

 

[Gord Dibben]

Record a macro while doing it once.

Assign that macro to a button.


Gord Dibben MS Excel MVP

 

[peyman]

The problem is I can not print it out correctly even for one time.The page
setting is kinda crazy.When I drag the solid blue lines to the bottom in
"page break preview" ,the no. of pages in the preview reduces for instance
from 14 to 3!!