FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

The Excel Addict - Help with Excel 2013, 2010, 2007, 2003
April 21, 2016

Greetings from The Excel Addict
Hi fellow Excel Addict,

Last Thursday I was sitting on my back deck having a coffee and enjoying the warmth of the springtime sun. In my newsletter I said, "I think spring is finally here! The snow is all gone. The sun has been shining. It's been reasonably warm"...

...but guess what? I was wrong. Really wrong!

20160421 Sprint snow storm Conception Bay South, Newfoundland

In today's 'Excel in Minutes' tutorial, I will show you how to 'Force All New Workbooks to Print 1 Page Wide'...but only if YOU want to.

If you missed my 'Excel in Seconds' newsletter on Tuesday, I showed you how to 'Get a Glow On'. You can read all about that here.

Pivot Table Webinar Replay
Congratulations to those of you who watched the free PivotTable webinar I told you about last week. Many of you were surprised by how much you learned in just that hour-long webinar. PivotTables can be life changing when you know how to use them properly. In the webinar John showed how to create a basic Pivot table and then showed some simple tricks that can turn your basic Pivot Table into a powerful and efficient reporting tool.

If you didn't get a chance to watch the webinar, you can watch the reply here but its available only until Thursday, April 21st.

If you are interested, John also offers an online Xtreme PivotTable course. You can save 20% off until Thursday April 21st (8PM Pacific Time) if you use coupon code: PIVOTWEB

If you decide to watch the webinar or enroll in the course, please send me an email and let me know what you think. I want to get your feedback about anything I recommend in my newsletter.

Wishing you another great day of Excelling
Francis Hayes (The Excel Addict)
Email:  fhayes[AT]

Francis Hayes (

If you missed my last newsletter, you can click here to view it online. Quote of the Day

"Things that matter most must never be at the mercy
of things that matter least."

-- Goethe --

If you have a favourite quote, send it to me and I may post it in my newsletter.

Today's Microsoft Excel Tip

Force All New Workbooks to Print 1 Page Wide

How often do you create a worksheet and find that when you go to print it, the data is just a little too wide to fit on one page? If you're like me, 90+% of the workbooks you create you want them to print only one page wide.

So I decided I wanted ALL of my new worksheets to default to 'Fit to print 1 page wide' and for those few that I didn't want to fit on one page, I could easily change the setting.

The way to make ALL of your new worksheets default to printing 1 page wide is by changing the 'Fit to...pages wide' option for your default worksheet and workbook templates.

Choose the 'Fit to 1 page wide' option

1) Open a blank workbook;

2) If the blank workbook has more than one worksheet, right-click and delete all worksheet tabs except for Sheet1. If you prefer to have more than one sheet in your new workbooks, go to File, Options, and on the General tab, choose a number for 'Include this many sheets';

3) From the Page Layout tab on the Ribbon, click the dropdown arrow for the Width option in the 'Scale to Fit' section and choose '1 page';

Fit To Print 1 Page Wide in Microsoft Excel 2007 2010 2013 2016 365

If there are other Page Layout settings (e.g. margins, header/footer, etc...) you would like to change as the default for all new worksheets and workbooks, you can make those changes now.

Save/Update Your Default Workbook Template

Be careful not to make any other changes to this workbook.

From the File tab, click Save As;

2) In the 'Save as Type' dropdown at the bottom of the dialog box, select Excel Template (*.xltx). You will notice that the active folder changes to the Templates folder. However, you want to save this default workbook template to your XLSTART folder;

3) Next, type or 'copy and paste' this path %APPDATA%\Microsoft\Excel\XLSTART into the File Name field and press Enter. This takes you to the XLSTART folder;

4) Change the suggested file name to Book.xltx and click OK. That's the default template for your new workbooks;

5) Again, click File, Save As (you should still be in the XLSTART folder);

6) Change the name to Sheet.xltx and click OK. That's the default template for all new inserted worksheets.

Save To Xlstart Folder in Microsoft Excel 2007 2010 2013 2016 365

Both the Book.xltx and Sheet.xltx templates will now include your personalized Page Layout settings (including Fit to 1 page wide) and will be available in a
ll new worksheets and workbooks.

1604 Excel Pivot Table Webinar

Thanks for supporting this newsletter and website

FREE Excel Tips Newsletter from
Subscribe here to get more tips like this every week

Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are EVER not completely satisfied with anything I recommend, please let me know and you will get your money...GUARANTEED. You can't lose.
"Spreadsheets Tips From An Excel Addict" is a weekly publication of
Copyright Francis J. Hayes All Rights Reserved.

8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630