General discussion
January 6, 2004 at 01:49 PM
groupjb

XL – Pg Setup for Multi Wkshts at Once

by groupjb . Updated 22 years, 8 months ago

I have a number of multiple-worksheet files to print out, and I need to be able to select all the tabs and re-set the page setup parameters for all worksheets and once and then print out all worksheets/pages in one command. But even when I select all the tabs and re-set the page size and ‘fit to’ parameters, it only changes these parameters for one sheet, so I end up having to re-set the parameters and print out each worksheet individually, which takes a lot of time when dealing with 50 multiple worksheet files. HELP!

This discussion is locked

All Comments