How to Change Default Font Size in Excel 2013

The font size that you use in Microsoft Excel can make a big difference on both the appearance of your spreadsheet and your audience’s ability to read what you have entered into the cells.

If you find that your audience is often asking you to make your font size either bigger or smaller, or if you find that you are changing it whenever you create a new spreadsheet, then it might be time to change your default font in Excel 2013. Fortunately this is an option that can be easily modified to suit your needs and will save you time that was otherwise being wasted constantly adjusting the font settings manually.


Use a Bigger or Smaller Default Font in Excel 2013

The steps below were performed in Microsoft Excel 2013. The steps for earlier versions of Excel, such as 2003, 2007 or 2010, will vary from these. Additionally, note that the font will only apply to spreadsheets that you create on your computer. Spreadsheets created by others will use the font that was applied when those spreadsheets were created.


Step 1: Open Excel 2013.


Step 2: Click the green File tab at the top-left of the window.

click the green file tab



Step 3: Click Options in the column at the left side of the window.

click Options at the bottom of the left column



Step 4: Click the drop-down menu to the right of Font Size, then select your preferred font size.

how to change the default font size in excel 2013



Step 5: Click the OK button at the bottom of the window to apply your changes.


Step 6: Click the OK button on the pop-up window, then close and restart Excel 2013 for your new font to take effect.

click the ok button



You can use a similar method to change the default font in Excel 2013. newsletter

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.