ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Printing problems with hidden rows (https://www.excelbanter.com/excel-worksheet-functions/260956-printing-problems-hidden-rows.html)

Banker

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

Banker

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