Options and Settings in Excel 2013 - part I
In this tutorial I will try to explain the absolute beginners where the dialog boxes where users can change the basic and advanced settings to work in Microsoft Excel 2013
Settings for operation in MS Excel 2013 is done on Excel Options dialog box. So, click on the File menu => Options
I will not go into detail (remember this is a tutorial for absolute beginners).
A new dialog window where we can make some adjustments and changes to default settings when you start Excel 2013.
In the menu on the left to the Excel Options dialog window, the first option is the General. By selecting options in the General right of the window of the dialog box have the option of setting general options for working with Excel
The main groups of settings in Excel Options dialog box are:
- Customize Ribbon
- Quick Acces Toolbar
- Trust Center
General Options in Excel 2013
In general settings note that subgroups and all settings can be adjusted: eg: in this section we can determine how many worksheets will appear when you start Excel 2013 or a new workbook, or change the background color themes working window in MS Office 2013.
- User Interface options
- When creating new workbooks
- Personalize your copy Microsoft Office
- Start up options
Formulas Options in Excel 2013
The formulas options notice subgroups and that all settings can be adjusted: eg: if you ask a question to ask us the number of the column headers are in this part of us that we can set the columns in the worksheet have the tag numbers instead of letters (settings R1C1 references).
- Calculation options
- Working with formulas
- Error checking
Proofing Options in Excel 2013
In the Proofing options and subgroups note that all settings can be adjusted: for example, in this section we set the language settings dictionary for text or checking grammar errors via AutoCorrect Options...
- AutoCorrect options (automatic corrections in the text and settings)
- When correcting spelling in Microsoft Office programs
Save Options in Excel 2013
The Save options subgroups and note that all settings can be adjusted: for example, in this section we can set the default location (folder) in which Excel will automatically offer to take a workbook which sometimes can be a good thing because if we want to change the location of the recording on the D partition of our hard disk for possible future security of data loss or automatic recording workbook after a certain time (Save AutoRecovery).
- Save workbooks
- AutoRecover exception for:
- Preserve visual appearance of the workbook
Language Options in Excel 2013
In the Save options subgroups note that all settings can be adjusted: eg here we can add other languages if you use Excel workbooks from other sources with different language settings.
- Choose editing Languages
- Choose Display and Help Languages
- Choose ScreenTip Language
To continue the examination of tutorials please see "Part II"