hi
the only thing i can think of is to suggest that you record 2 macros.
preprint macro would un-format all and hide rows.
postprint macro would re-format all and unhide rows.

you did say that you "create elaborate worksheets " so it might be a pain to
record it all but once done, unformating and reformating is just a button
click.

my thoughts
Regards
FSt1

"Dbriltz" wrote:

I create elaborate worksheets and would like to have the cells that need
periodic updating to stand out in bold or a different font from the other
(formula-driven) cells, but I do not want them to appear differently when
printed. Has anyone developed an idea that works for this?

Also, I would like to have certain rows on my spreadsheet for information
that would never print out, but would be within my print range. Is there a
way to print without them other than to hide the rows?