Formating all Worksheets to print "Fit all Columns on One Page"

I did this last month but I can't remember how. I have multiple worksheets that need to be printed and I need to format them all to "Fit All Columns on One Page".

If I choose print entire workbook then put fit all columns on one page, it only formats the sheet that I am looking at on the print menu, not all of them.

If I choose print active worksheets and have all sheets selected and change the setting the Headers all change to match the first worksheet.

Thanks for your help.

Perhaps something like this?

Please Login or Register  to view this content.

Alf