Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding rows and printing
I have the print area set to A1..H340 with 4 manual page breaks inserted. I
have hidden rows 200 thru 340 and when I print, I still get 5 pages - two pages from the active rows and three more that are blank. I have been doing this "hiding rows and printing only what I need thing" for over a year now and it has worked as expected. I made some minor changes to the sheet by adding rows of info and I have reset the page breaks accordingly and now it prints all pages including blanks for the hidden row areas. Any ideas?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Hiding rows and printing
I found out what happened. In the past I DID NOT have a print area defined.
After I made changes I assigned the print area. That is why the functioning changed. When I removed the print area and hid rows, it only printed what i wanted it to print. Yee Haw. "Banker" wrote: I have the print area set to A1..H340 with 4 manual page breaks inserted. I have hidden rows 200 thru 340 and when I print, I still get 5 pages - two pages from the active rows and three more that are blank. I have been doing this "hiding rows and printing only what I need thing" for over a year now and it has worked as expected. I made some minor changes to the sheet by adding rows of info and I have reset the page breaks accordingly and now it prints all pages including blanks for the hidden row areas. Any ideas?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for hiding zero data rows while printing | Excel Discussion (Misc queries) | |||
Hiding Rows when printing | Excel Worksheet Functions | |||
Hiding rows on a sheet before printing | Excel Worksheet Functions | |||
Hiding rows when printing | Excel Discussion (Misc queries) | |||
Hiding rows before printing | Excel Discussion (Misc queries) |