When you make a copy of a worksheet tab in Excel by holding down the CTRL key and dragging the sheet tab, the print settings get copied as well. However, if you want to copy just the Print Settings from one sheet to one or more other sheets, there doesn't appear to be an option to do that.
But there is! In fact, there is a VERY SIMPLE , EASY and FAST way to do this that most Excel users have never heard of.
1) First, select the sheet tab whose print settings you want to copy;
2) Hold down the CTRL key and click each sheet tab you want to copy the print settings to;
3) From the Page Layout tab, click Print Titles (to open the Page Setup dialog), then simply clickOK (or press ENTER).
4) Last VERY IMPORTANT step: Right click any sheet tab and click Ungroup Sheets. If you don't do this, you could mess up all of your sheets because everything you do to one sheet will be duplicated in all other grouped sheets.
|Copyright © 2017
Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.