In this article, we will learn How to Change Excel default font and font size.
New workbook in Excel
When a user opens a new workbook in Excel, it opens with the book name as Book1. Book1 has some default options like default font, font size, default view and number of sheets when any new workbook is opened. You can change these default styles.
Excel options to change default styles
Go to File > Options > Select new default font and font size (under When creating new workbooks option)
Example :
All of these might be confusing to understand. Let's understand how to use the function using an example. Here we have a sample workbook and we need to change the default font Calibri with font size 11.
Follow the steps
Go to File. You can find the File tab options adjacent to Home tab in the menu bar.
Now select Options from the left pane as shown below.
Now you will see the Excel Options dialog box. You can find the default font and font size boxes. Select the new default font and font size and click Ok as shown below.
When you click Ok. Excel throws an instruction "Please close and restart Microsoft Excel so that the font changes can take effect". Click Ok. Make sure there is no work that needs to be saved.
This will open a new blank workbook with required font style and font size.
Here are all the observational notes using the process in Excel
Notes :
Hope this article about How to Change Excel default font and font size is explanatory. Find more articles on calculating values and related Excel formulas here. If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write to us at info@exceltip.com.
Related Articles :
How do I Insert a Checkmark in Excel 2016 : To insert a checkmark in Excel Cell we use the symbols in Excel. Set the fonts to wingdings and use the formula Char(252) to get the symbol of a check mark.
How to disable Scroll Lock in Excel : Arrow keys in excel that move sheet cell up, down, Left & Right. But this feature is only applicable when Scroll Lock in Excel is disabled. Scroll Lock in Excel is used to scroll up, down, left & right your worksheet not the cell. So click this link to learn how to check scroll lock status and how to disable it?
Use a closed workbook as a database (DAO) using VBA in Microsoft Excel : To use a closed workbook as a database with DAO connection use this VBA snippet in Excel.
Use a closed workbook as a database (ADO) using VBA in Microsoft Excel : To use a closed workbook as a database with ADO connection use this VBA snippet in Excel.
Popular Articles :
How to use the IF Function in Excel : The IF statement in Excel checks the condition and returns a specific value if the condition is TRUE or returns another specific value if FALSE.
How to use the VLOOKUP Function in Excel : This is one of the most used and popular functions of excel that is used to lookup value from different ranges and sheets.
How to use the SUMIF Function in Excel : This is another dashboard essential function. This helps you sum up values on specific conditions.
How to use the COUNTIF Function in Excel : Count values with conditions using this amazing function. You don't need to filter your data to count specific values. Countif function is essential to prepare your dashboard.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
