Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365

January 24, 2017

Greetings from The Excel Addict

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. 

20160124 weather pic Kelligrews, Conception Bay South, Newfoundland, Canada

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)

Francis Hayes (TheExcelAddict.com)

TheExcelAddict.com Quote of the Day

"If we had no winter, the spring would not be so pleasant:
if we did not sometimes taste of adversity,
prosperity would not be so welcome."

-- Anne Bradstreet --

If you missed my last newsletter, you can click here to view it online.

Excel in Seconds with TheExcelAddict.com

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.

Change Default Font in Microsoft Excel 2007 2010 2013 2016 365

If you've found this tip helpful, please click here to share it.

Click here to get more tips like this every week

Thanks for supporting this newsletter and website

Earnings 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 for a few dollars. 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 I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630