January 24, 2017
Hi fellow Excel Addict,
When I left you the last time there was a big snowstorm bearing down on us here eastern Newfoundland. It turned out to be a pretty big storm but not quite the snow accumulation that had been forecasted. We received around 30cm (12in) of snow instead of the 'feared' 50cm (20in), but the winds were pretty high... up to 100kmh (60mph).
Sometimes winter storms are ominous when you are feeling the brunt of them but once the wind dies down and the sun comes out, the beauty of winter is revealed once again.
In today's 'Excel in Seconds' tip, I show you how you can quickly 'Change Your Default Font For All New Workbooks'.
If you missed my last 'Excel in Minutes' tip, 'Print Different Headers and Footers for Odd and Even Pages', you can read it here now.
Please feel free to share my newsletter with your Excel friends — they will thank you for it.
Hope you're having a great week and keep on Excelling,
Francis Hayes (The Excel Addict)
If you missed my last newsletter, you can click here to view it online.
Change Your Default Font For All New Workbooks
By default, Excel uses Calibri font size 11 for new workbooks. If you would like to use a different font for your workbooks, you can easily change it. Note, however, that the new font will apply only to new workbooks that you create.
To change the default font for all NEW workbooks...
1) From the File tab click Options;
2) In the General category, click the dropdown next to 'Use this as the default font: [Body Font]'; and choose a new font. In this section you can also change the default font size.
3) Click OK to return to your worksheet.
4) You must now close and restart Excel to start using the new font.
If you've found this tip helpful, please click here to share it.
| 'Spreadsheets Tips
Excel Addict' and 'Excel in Seconds' are publications of
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630