MS Excel 2007 - Lesson 2: Customizing in Excel

TipsMake.com - Excel 2007 provides a wide range of customizable options, allowing you to work with Excel in the most convenient way. To access these options:

• Click Office Button

• Click Excel Options

MS Excel 2007 - Lesson 2: Customizing in Excel Picture 1

Popular

These features allow you to define a working environment with a mini toolbar, color combinations, workbook default options, sort and enter user names and allow you to access the Live feature. Preview . The Live Preview feature allows you to preview the results of design and format changes.

MS Excel 2007 - Lesson 2: Customizing in Excel Picture 2

Formulas

This feature allows you to define calculation options, work with formulas, check errors and check rules.

MS Excel 2007 - Lesson 2: Customizing in Excel Picture 3

Proofing

This feature allows you to define how to edit and format words for text. You can customize the settings automatically and ignore words or errors in the document through Custom Dictionaries.

MS Excel 2007 - Lesson 2: Customizing in Excel Picture 4

Save

This feature allows you to determine how a workbook is saved. You can specify how to automatically save when running and where you want the workbook to be saved.

MS Excel 2007 - Lesson 2: Customizing in Excel Picture 5

Advanced

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

MS Excel 2007 - Lesson 2: Customizing in Excel Picture 6

Customize

This option allows you to add features to the Quick Access Toolbar. If there are many tools that you use often, you may want to add them to the Quick Access Toolbar.

MS Excel 2007 - Lesson 2: Customizing in Excel Picture 7

Previous article: MS Access 2007 - Lesson 1: Start with Microsoft Access 2007