Excel Tutorial
Options for Customizing Excel
A click on Options in Tools tab in Menubar opens Options pop-up as shown below to customize Excel on your PC.
Customize View
Click on View tab in the Options pop-up to
|
|
Customize General
Click on General tab in the Options pop-up to
- Change Cell Reference style : Change Column headers from Alpha-numeric to Numeric and Cell address to R1C1 style (e.g. Cell address "B6" will change to "R6C2").
- Enable / Disable other applications.
- Enable / Disable Display of Function tooltips.
- Enable / Disable Prompt for Worksheet properties at the time of saving the workbook.
- Set the number for display of recently used files in file menu.
- Enable / Disable Zoom on roll with IntelliMouse.
- Set the default number ofworksheets in a workbook. Default is 3..
- Set default font and font size for Excel.
- Define path for saving of workbooks.
- Set opening of all files from a defined location on startup.
- Set user name.
Customize Edit
Click on Edit tab in the Options pop-up to
- Disable editing directly in cells (You will be able to edit the contents of selected cell in the formula bar).
- Disable dragging and dropping of cells.
- Disable display of alerts before overwriting cell (by merging of cells).
- Set direction (default is 'Down') for movement of selection on pressing "Enter" key.
- Set fixed decimal places (default is '0').
- Disable Cut, Copy and Sorting of objects with cells.
- Disable asking of update of links (when a workbook with links is opened, Excel, by default, asks for updating links.).
- Enable providing feedback by animation.
- Disable Auto-Complete for Cell values.
Customize AutoRecover / AutoSave
Click on Save tab in the Options pop-up to enable or disable Auto Recover / Auto Save and / or to set time interval for Auto Save.
Customize Calculation
Click on Calculation tab in the Options pop-up to customize calculation by Excel.
Calculation Process
Excel recalculates those cells that are dependent on other cells that contain changed values. This type of calculation helps to avoid unnecessary calculations. Excel also calculates workbooks each time they are opened.
As calculation proceeds, you can choose commands or perform actions such as entering numbers or formulas. Excel temporarily interrupts calculation to carry out the other commands or actions and then resumes calculation. The calculation process may take more time if the workbook contains a large number of formulas, or if the worksheets contain data tables or functions that automatically recalculate every time the workbook is recalculated. Also, the calculation process may take more time if the worksheets contain links to other worksheets or workbooks. You can control when calculation occurs by changing the calculation process to manual calculation.
Customize Calculation Precision
Excel stores and calculates with 15 significant digits of precision. When a formula performs calculations, Excel usually uses the values stored in cells referenced by the formula. For example, if two cells each contain the value 10.005 and the cells are formatted to display values in currency format, the value $10.01 is displayed in each cell. If you add the two cells together, the result is $20.01 because Excel adds the stored values 10.005 and 10.005, not the displayed values. You can change the precision of calculations so that Excel uses the displayed value instead of the stored value when it recalculates formulas.
Customize Custom List
Click on Custom Lists tab in the Options pop-up to add custom lists to Excel. The default lists are Day and Month names in short and full.
Customize Spell Check
Click on Spelling tab in the Options pop-up to
- Set language for Spell Check
- Add dictionaries for spell check
- Add words to dictionaries
- Specify dictionary for suggestions
- Enable / disable ignoring words in Upper-case, words with numbers and web address in spell check
- Customize AutoCorrect
Customize Security
Click on Security tab in the Options pop-up to set a password for opening Excel and / or modifying the workbooks or make the your workbooks 'Read-only'.