View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Banker Banker is offline
external usenet poster
 
Posts: 21
Default 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??