EXCEL'S DEFAULT OPTIONS
Lesson 10 - Changing the Standard Default Options in Excel
CHANGING THE DEFAULT OPTIONS IN EXCEL
General
Sometimes when working in Excel, it can be handy to set it up in a way that you would most commonly use. In other words, change its default options. To do this, go to File>Options. This will display the Options dialogue box. On this dialogue box you will notice that there are multiple options. If however, there is an option on here anywhere that you would like to know about, but are unsure of, just let us know and we will explain it in detail.
Formulas
By setting this on automatic means Excel will automatically recalculate whenever necessary.
Proofing
Save
Advanced
Go back to:
See also:
See also: Index to Excel VBA Code and Index to Excel Freebies and Lesson 1 - Excel Fundamentals and Index to how to… providing a range of solutions and Index to new resources and reference sheets
Click here to visit our Free 24/7 Excel/VBA Help Forum where there are thousands of posts you can get information from, or you can join the Forum and post your own questions.
Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft.
Gallery
