Customize The Way Excel Starts

Do you want to change the default settings in Excel?

For example you want to change the default Font, default Font Size, the way Excels’, View shows up when we start the application? Or do you want to change the default number of Worksheets that Excel starts with?

For instance, when Excel starts the default Font is Calibri, the default Font Size is 11, the View is Normal and the number of Worksheets is 1 as shown in the image below.

Home - Font

First of all we must select the File tab in order to move to backstage view, and then from the drop down menu that appears we select the Options category which is located at the bottom left of the drop down menu.

Info - Backstage

Once the category Options is selected, the Excel Options dialog box appears as we can see in the image below. Then from this dialog box we make sure that the General category is selected from the left of the window as shown below.

Excel Options - General

Once we make sure the General category is selected, we locate the area named: When Creating New Workbooks as we can see in the image below.

Under this area we have the following options:

  • Use This As The Default Font:
  • Font Size:
  • Default View For New Sheets:
  • Include This Many Sheets:

When Creating New Workbooks

Use This As The Default Font: If we select the arrow at the right of this command, the drop down menu will appear with all of our available Fonts to select from in order for it to be the Default Font, as we can see in the image below.

Uses This As The Default Font

Font Size: If we select the arrow at the right of this command the drop down menu will appear with all the available Font Sizes to select from in order for it to be the Default Font Size, as we can see in the image below.

Font Size

Default View For New Sheets: If we select the arrow at the right of this command the drop down menu will appear with all the available Views to select from in order for it to be the Default View, as we can see in the image below.

Default View For New Sheets

Include This Many Sheets: If we select the up and down arrows next to the sheet button, we can define how many sheets will appear when we create a New Workbook.

Include This Many Sheets

That is it, we have now customized the options on how Excel will start!!!

Below you can check out the video on how to to Customize Excel Starting Options.

Customize The Way Excel Starts

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on December 9, 2013, in Excel English 2013, Microsoft Office 2013 English and tagged , , , , , , , , , , , , , , , . Bookmark the permalink. Comments Off on Customize The Way Excel Starts.

Comments are closed.