You will have to customize to suit yourself.

What looks good to me may look horrible to you.


Gord Dibben MS Excel MVP

On Wed, 26 Mar 2008 07:46:05 -0700, PJ wrote:

This is a very general and basic question. However, I would like to know if
you have any recommendations for printing various styles and sizes of excel
documents to their optimum size on the printer page.

Previous ways that I have done this include...center aligning data onto the
page through page setup as well as formatting the rows and columns for an
"autofit", but when you have various amounts of data in these documents this
sometimes crams the data and becomes ineffective in its presentation purpose.

Is there any key or function in excel that optimizes the best suited print
function for the user?

Thank you for your help