Office 2010 - Excel

Lesson 5 : Options in “Excel” (2)

5/87 Lessons 

“Save” Category

In the “Save” category, we determine where “Excel” stores the auto-recovery file (1) and the default file location (2). The auto-recovery file is a temporary backup file which saves worksheet file every x number of minutes. The default setting is 10 minutes, but if you wish to change this, type the number of minutes in the space provided (3). If you save your file, this will overwrite the backup that was created by “Excel”.


“Language” Category

If you need to use “Excel” in another language, you can change it here. The selected language will be the language of the buttons in “Excel”. The application does not change, but only runs the grammar check in this language.

“Advanced” Category

In the “Advanced” category, you find a number of options that you can set when you’re used to working with “Excel”. For example, the direction in which the cursor moves when the Enter key is pressed. There are a wide variety of editing and display options, most of them self-explanatory and many of them more advanced than what you’ll even need when working with “Excel”.


“Customize Ribbon” Category

This is new in “Excel” 2010 and will be explained in the next lesson.

“Quick Access Toolbar” Category

This is not new in “Excel” 2010, but also extensively discussed in a subsequent lesson.

“Add-ins” Category

Add-ins” are custom commands with new features that can be added to “Excel”.
When “xcel 2010 is installed on your computer, there are several of these “Add-ins” already installed. Some are labeled “active” (1) and some are “inactive” (2). We find, for example, in the active add-ins the PDF Maker (3) which is used to convert our “Excel” file into a pdf file.
The active plugins are installed on your computer and used by “Excel”. The inactive ones are only installed on your computer, but are not used by “Excel”.

If you wish to make an “inactive” “Add-in” “active”, select it from the list of “inactive” “Add-ins” and click the “Start” button (4).


“Trust Center” Category

In the “Trust Center” you will find the security settings for “Excel” files

When you change settings in the “Trust Center”, the security of your computer and other computers in the network is either significantly improved or deteriorated. So please first contact your system administrator or consider the risks before you change settings for the Trust Center.

You've completed Lesson 5