How to Set the Default Font and Size in Excel

Date:2019-11-24 Author:Olivia

You may want to set the default font and size once for all, because it can help to make your workbooks more readable when they are printed. If you are one of those users, who desire to change the default font and size, and select one that better suits your needs, then this post will interest you.

1. Go to File tab and click it in the Ribbon.

How to Set the Default Font and Size in Excel

2. Next click Options in the left pane.

How to Set the Default Font and Size in Excel

3. The Excel Options dialog box will display, now go to General tab.

How to Set the Default Font and Size in Excel

4. When creating new workbooks – hit the arrow of Use this as the default font and select one of the options you prefer in the drop-down list.

How to Set the Default Font and Size in Excel

5. After the previous step, set the Font size in the same way.

How to Set the Default Font and Size in Excel

6. Click OK twice, then close and restart the current Excel, so that the font and size changes can take effect. Next time you open up a new workbook in Excel , the default font and size will be automatically displayed.

How to Set the Default Font and Size in Excel

How to Set the Default Font and Size in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *