Hidden Rows and Page Breaks

[Anthony]

Just when you find a cool feature--bang--it's useless cause MS doesn't
think things through. Argh...Sorry for the tirade, here's my problem:

I've got a big big automated spreadsheet. Sneaky guy that I am, I like
to hide--dynamically--big blocks of rows. The problem: When I print
the entire spreadsheet the hidden rows do not print (which is good) but
the manual page breaks inside the hidden rows DO print--weird, eh? Now
I can make the user suffer with an occasional blank page, but I'm
getting like 70 blank pages.

Any solutions? Thanks!

Anthony Hatfield, MCP
Junction Software Services

[John F. Opie]

Hi there -

Define a print range. Then you only print what you want. If need be,
set up a second worksheet in the workbook and link into that. This
way you can do all the fancy formatting you might want and be assured
that only that which you want to print is thus printed...

John

PS If you do the latter, beware that if you have several intervening
worksheets between, say, source data and final printout, that these
sheets need to be adressed and calculated. If you open a workbook
with 3 worksheets, actualising links, say, in the first and then
simply go directly to the third, Excel *may* not calculate the
processing in the second worksheet, leading to a printout (from the
third page) that hasn't been updated and is therefore incorrect. This
is especially so when using macros to automate life. Solution is
simple: activate all the worksheets in a workbook one by one and
force recalc...

John

[Brian Damon]

Anthony wrote:
>
> Just when you find a cool feature--bang--it's useless cause MS doesn't
> think things through. Argh...Sorry for the tirade, here's my problem:
>
> I've got a big big automated spreadsheet. Sneaky guy that I am, I like
> to hide--dynamically--big blocks of rows. The problem: When I print
> the entire spreadsheet the hidden rows do not print (which is good) but
> the manual page breaks inside the hidden rows DO print--weird, eh? Now
> I can make the user suffer with an occasional blank page, but I'm
> getting like 70 blank pages.
>
> Any solutions? Thanks!
>

If everyone has the same printer and the pages are truely blank.
Check to see if the printer has the capability to suppress blank
pages. I know at least one printer manufacturer that has had
that feature for some time. ;-)

Brian
--
Disclaimer: All opinions expressed are mine alone and do not represent
the views of my employer, Lexmark International, Inc.

Remove "..." to reply.