| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| printing a filtered selection without blank pages included | Excel Discussion (Misc queries) | |||
| Batch Printing - filtered by Picklist | Excel Worksheet Functions | |||
| Printing Filtered Excel Worksheets | Excel Discussion (Misc queries) | |||
| Filtered results and printing | New Users to Excel | |||
| filtered area | New Users to Excel | |||
Linear Mode
