By default, when you create a new blank document, the text you start typing will be a Normal style using a font of Calibri with a size of 11. This is a commendable choice, but it might not be right for you.
You can change that default. Start typing some text and then select it. Change its styling to be the way you want it. For example, you could change the font size, the font family and even the colour. Select it again and then right click on it and select Font.
When the Font window opens, click on Set As Default.
A reasonable question to answer is whether you want the new default font to apply only to the current document, or all documents based on the Normal.dotm template (to all intents and purposes all documents). You can answer that question in the next window that appears:
Make your choice and click OK. The chances are, you will want this new default font to apply to all documents, to save you having to change it every time.
What you have done here is change a style. In this case it was the Normal style. Similarly, you can change the styling for other styles as well (headings, subtitles, etc.) and make the same choice regarding application to only the current document or all new documents.
Jul 29, 2017 Change the Use this Font drop-down list (Excel 2007 and Excel 2010) or the Use This As the Default Font drop-down list (Excel 2013 and Excel 2016) so that it reflects the font you want used. If desired, use the Font Size drop-down list to pick the size of font you want Excel to use. Restart Excel. Jan 11, 2018 Hi Sid, In order for you to change the default settings for a shape or text box in Excel 2016, you may refer to this support article. Note: These steps only set defaults for the spreadsheet, slide presentation, email message, or document that you have open.
By default, Excel for Mac uses Body Font in font size 12, which is displayed as Calibri font in font size 12 when you type data in a worksheet, header or footer, or text box. However, you can change the default font and font size for all new workbooks that you create.
![Set default font in excel 2016 windows 10 Set default font in excel 2016 windows 10](/uploads/1/2/5/7/125772686/442631831.jpg)
- On the Excel menu, click Preferences.
- Under Authoring, click General.
- In the Default font and Font size boxes, select a new font and font size.
- Click OK.Note: This won’t change the font for an existing workbook.
- Close and restart Excel.The new default font is applied when you create a new blank worksheet or workbook.