PRINTING IN FILTERED AREA

  • Thread starter Thread starter peyman
  • Start date Start date
P

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
 
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
 
Record a macro while doing it once.

Assign that macro to a button.


Gord Dibben MS Excel MVP
 
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!!
 
Back
Top