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