Monday, May 2, 2011

Customize Excel - II


Excel 2007 offers a wide range of customizable options that allow you to make Excel work the best for you.  To access these customizable options:
  • Click the Office Button
  • Click Excel Options


Excel Options Menu 
Popular
These features allow you to personalize your work environment with the mini toolbar, color schemes, default options for new workbooks, customize sort and fill sequences user name and allow you to access the Live Preview feature.  The Live Preview feature allows you to preview the results of applying design and formatting changes without actually applying it.
Popular Customize Items
Formulas
This feature allows you to modify calculation options, working with formulas, error checking, and error checking rules.
Formula Options
Proofing
This feature allows you personalize how word corrects and formats your text. You can customize auto correction settings and have word ignore certain words or errors in a document through the Custom Dictionaries.
Proofing Options
Save
This feature allows you personalize how your workbook is saved.  You can specify how often you want auto save to run and where you want the workbooks saved.
Save Options
Advanced
This feature allows you to specify options for editing, copying, pasting, printing, displaying, formulas, calculations, and other general settings.
Advanced Options
Customize
Customize allows you to add features to the Quick Access Toolbar.  If there are tools that you are utilizing frequently, you may want to add these to the Quick Access Toolbar.
Customize Options

No comments:

Post a Comment