Copy & Paste Page Setup (print area, margins, scale, etc)
I'd like to be able to copy/paste the entire Page Setup from one tab to multiple others. Currently, I have to set the print area tab by tab. Then add in the page setup separately.
We have "styles" so why not use the same kind of code for setting up Page Setup "styles" we can select for a worksheet or file, then modify as and if needed on a worksheet? Or select several tabs, then apply the Page Setup "style" all at once. With maybe an "Apply To Chosen Worksheets" button in case the setup isn't in our previously defined styles? (You know, so you don't have to do the whole silly "Open Page Setup, Make a change, Save (applying it across select sheets), then change it back and Save again" routine that we have to apply to so many things?)
Candace Runion commented
I also would like the ability to set print area, set page breaks, etc to multiple tabs at one time. I have worksheets that contain over 100 tabs and counting for vending food orders. It would save so much time to be able to change the print areas or page breaks on all tabs at once instead of having to do one tab at a time. I have 10 work files with tab counts ranging from 5 to 112. That's a LOT of tabs!
Thank you for considering this request.