Printing Functionalities

[OrlaLynch]

Hi,

I have a excel document with very large spreadsheets. I am trying to make it
more 'printable'. The users of my document will be adding rows to the
spreadsheets so if I organise it to print friendly now, it will be changed in
the future and will not print well. How do I fix this problem? Or is there a
way I can set it so it prints well?

Thank you for your help.
Orla

 

[Gord Dibben]

You have an Excel workbook with very large worksheets......right?

Sounds like you need a Dynamic Print Range.

See Debra Dalgleish's site for creating and using dynamic ranges.

http://www.contextures.on.ca/xlNames01.html#Dynamic


Gord Dibben MS Excel MVP