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!
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)
If you missed my last newsletter, you can click here to view it online.
If you have a favourite quote, send it to me and I may post it in my newsletter.
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';
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.
1) 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.
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 all new worksheets and workbooks.
|"Spreadsheets Tips From An
Excel Addict" is a weekly publication of TheExcelAddict.com.
Copyright Francis J. Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630