PRINTING IN FILTERED AREA
 

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

PRINTING IN FILTERED AREA
 

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" wrote in message
...
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

PRINTING IN FILTERED AREA
 

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

"Peo Sjoblom" wrote:

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" wrote in message
...
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

PRINTING IN FILTERED AREA
 

Record a macro while doing it once.

Assign that macro to a button.


Gord Dibben MS Excel MVP

On Sat, 16 Aug 2008 13:33:02 -0700, peyman
wrote:

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

"Peo Sjoblom" wrote:

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" wrote in message
...
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

PRINTING IN FILTERED AREA
 

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!!

"Gord Dibben" wrote:

Record a macro while doing it once.

Assign that macro to a button.


Gord Dibben MS Excel MVP

On Sat, 16 Aug 2008 13:33:02 -0700, peyman
wrote:

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

"Peo Sjoblom" wrote:

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" wrote in message
...
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