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

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.
Formulas
This feature allows you to modify calculation options, working with formulas, error checking, and error checking rules.
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.
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.
Advanced
This feature allows you to specify options for editing, copying, pasting, printing, displaying, formulas, calculations, and other general settings.
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.