How to Change the Default Settings of a New Excel Workbook

You will certainly make some modifications in an Excel workbook. But changing the default settings according to your need can quicken your work pace.

There are four options that you can modify in an Excel workbook. When you create a new workbook, you will see the settings that you have made. Below we will talk about how to change the settings in detail.

1.      Font

When you open a new workbook, the default font is “Body Font”. Here we open a new workbook and input a phrase into it.Default Font

You can see in the toolbar that the font is “Calibri”. If you need to use other font in your Excel, you need to change the font constantly. Therefore, you can change the default font according to your need.

  1. Click “File” in the ribbon.
  2. And then click the button “Options”.Click File and Click Options
  3. In the “Excel Options” window, click the small arrow in the text box of the “Use this font”.
  4. Now drag the scroll bar and choose the font that you need.Change Font
  5. When you finish selecting, click “OK” in the window.
  6. Next you will see such information. Click “OK” in the window.Information
  7. And then quit and restart Excel. In this new workbook, you can see that the default font has changed into the designated font. Except for the character font that you input, the font of column header and row header will also change.New Font

Therefore, the next time, you don’t need to change the font manually.

2.      Font Size

Except for the font, you will certainly change the font size in Excel. The default font size is 11 in Excel.Default Font Size

And to make things easier, you can also change the default font size.

  1. Follow the first two steps in the previous part and open the “Excel Options” window.
  2. And then click the arrow in the text box of the “Font size”.Change Font Size
  3. After you select your size, click the button “OK” in the window.
  4. And then you will also see the information. Click “OK” in the window.Information of Font Size
  5. Still quit Excel and then restart it. Now you can see the new font size in the workbook.

New Font Size

3.      Workbook View

There are 3 different types of workbook view: normal view, page break preview and page layout view. The default style is the normal view. In certain conditions, such as printing, you need to change the view. Therefore, you can also change the workbook view to make things easier.

  1. Still you need to open the window of “Excel Options”.
  2. Click the small arrow in the text box of the “Default view for new sheets”. From the name, you can know that this setting will take effect in a new sheet.
  3. In the drop-down menu, choose the sheet view that you need.Change Default View
  4. Next click “OK”. In this setting, you will not see the information that appears in the former two parts.
  5. Now create a new sheet. In addition, you can also create a new workbook. You can see that the view changes according to your setting.

The New View

4.      Sheet Number

Now comes to the sheet number. The default number of sheets is 3 in a new workbook. If you need to create many worksheets in a new workbook, you can change the default number.

  1. Open the “Excel Options” window.
  2. Now change the sheet number in the “Include this many sheets”. You can directly input the number into the text box or click the two arrows.Change Sheet Number
  3. After you set the number, click “OK” in the window.
  4. And then quit Excel and then restart. In this new workbook, you can see that the sheet number is exactly the number you have set.New Sheet Number

From the above analysis, the next time, you can also change the default settings for your Excel workbook.

Most of the Lost Data is Recoverable

You will panic if you lose your precious data and information. Actually, if you can take the right action, you have a great change to recover your file. Among all the methods you can take, the most effective one if purchasing an affordable Excel repair tool. This tool has the best technology in the world. Besides, it can also repair xlsx data and fix other errors in Excel. With this tool at and, you can rest assured.

Author Introduction:

Anna Ma is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair docx file and outlook repair software products. For more information visit

Comments are closed.