Modify Excel Default Options

Excel Tips & Tricks

Modify default options — Click on the File tab or the Widows symbol in upper left of excel. Click on Excel Options on bottom of pop window. The following will come up.

With the above window you can set preferred default options. Look at the menu on left and navigate through and see what options best works for you.

1. For example:

a. Change the default on the type of font and size of font on workbooks. Set to Arial with 8 pt font for Beanstalk SOP. You can define the number of sheets that are in a new “created” workbook.

b. Click on Customize your Ribbon bar to change your ribbon to show the options you prefer. Just add or remove to update.

c.