Hiding rows and printing

B

Banker

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

Banker

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top