Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for hiding zero data rows while printing | Excel Discussion (Misc queries) | |||
Hiding Rows when printing | Excel Worksheet Functions | |||
Hiding rows on a sheet before printing | Excel Worksheet Functions | |||
Hiding rows when printing | Excel Discussion (Misc queries) | |||
Hiding rows before printing | Excel Discussion (Misc queries) |