You are here LEARN EXCEL & VBA Microsoft Excel 2007 Tutorials Customize Excel

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

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

This feature allows you to modify calculation options, working with formulas, error checking, and error checking rules.

Formula Options

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

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

This feature allows you to specify options for editing, copying, pasting, printing, displaying, formulas, calculations, and other general settings.

Advanced Options

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