![]() |
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?? |
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?? |
All times are GMT +1. The time now is 04:18 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com