The Excel Addict - Help with Excel 2013, 2010, 2007, 2003

Easily Copy Print Settings From One Worksheet to Another
by Francis Hayes (The Excel Addict)

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.

Copy Print Settings From One Worksheet To Another in Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

Would you believe me if I told you that
you can DOUBLE your productivity in Excel?

How about TRIPLE it ? or QUADRUPLE it ? or MORE ?

If I showed you a tip where you could do a task in Excel in five seconds that would typically take you 20 minutes to an hour or more, what would you call that? Productivity on steroids?

...and that's just ONE tip!
"Give me 10 or 15 minutes each week and I will show you how learning a few of my time-saving 'Spreadsheet Tips From An Excel Addict' on a regular basis will seem almost effortless BUT will quickly help you BOOST your productivity in Excel beyond your imagination" - Francis Hayes, The Excel Addict

Get my FREE Twice-Weekly Newsletter
"Spreadsheet Tips From An Excel Addict"

Now being read by more than 37,000+ Excel Addicts all over the world

Enter Your Name Francis Hayes (The Excel Addict) - I want to help you EXCEL !!
Enter Your Primary Email

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.