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.
Bookmarks