Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing problems with hidden rows
I have a sheet with 5 templates divided by page breaks. When only 2
templates are needed, I hide the rows that I do not wish to be printed so it will only print 2 sheets instead of 5. This was working just fine until lately. Now it prints all 5 sheets but sheets 3, 4 & 5 are blanks. The print area is set for A1..H340 but I may hide A200 .. H340. Any ideas as to what has changed?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Printing problems with hidden rows
I figured it out. There was a print area defined and when I cleared the
print area, it worked as needed. "Banker" wrote: I have a sheet with 5 templates divided by page breaks. When only 2 templates are needed, I hide the rows that I do not wish to be printed so it will only print 2 sheets instead of 5. This was working just fine until lately. Now it prints all 5 sheets but sheets 3, 4 & 5 are blanks. The print area is set for A1..H340 but I may hide A200 .. H340. Any ideas as to what has changed?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing hidden rows or columns | Excel Discussion (Misc queries) | |||
Again printing with hidden rows | Excel Worksheet Functions | |||
Printing hidden rows | Excel Discussion (Misc queries) | |||
printing worksheet with hidden rows | Excel Worksheet Functions | |||
Printing Hidden Rows | Excel Discussion (Misc queries) |