You are here KNOWLEDGE Microsoft Excel 2007 Tutorials Customize Excel

Query, Share and Manage Excel workbooks on LAN, Internet

Customize Excel

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