Popular options

Top options for working with Excel

Show Mini Toolbar on selection     Shows the Mini toolbar when you select text. The Mini toolbar provides quick access to formatting tools.

Enable Live Preview     Select to preview the effects of selected options in the worksheet.

Show Developer tab in the Ribbon     Selected by default, shows the Developer tab on the Ribbon, which is a component of the Microsoft Office Fluent user interface. The Developer tab includes macro and form authoring tools, as well as XML-related features. Clear this check box to hide the Developer tab.

Always use ClearType     Selected by default, this option turns on ClearType to make the text easier to read. If you change this setting, you must restart all Microsoft Office programs for the setting to take effect.

Notes: 

• This setting applies to all Office programs.

• On computers running Microsoft Windows XP, turning this option on overrides the ClearType setting in Windows. This option is not available on computers running Windows Vista.

Color scheme    Allows you to change the color scheme of the program. Select the color scheme that you want in the Color Scheme box.

ScreenTip style     Select an option in the box to choose whether and how to display ScreenTips. Select Show feature descriptions in ScreenTips to display button names and helpful information, Don't show feature descriptions in ScreenTips to display button names only, and Don't show ScreenTips to hide ScreenTips.

Create lists for use in sorts and fill sequences     Click Edit Custom Lists to add lists that you can use to sort data easily and to fill data into cells in the worksheet.

When creating new workbooks

Use this font     Select the font that you want to use as the default font for new worksheets and workbooks. This font is applied when you restart Excel and create a new worksheet or workbook.

Font size     Sets the size of the default font.

Default View for new sheets     Select the view that you want Excel to display by default when you start Excel. You can select Normal View, Page Break Preview, or Page Layout View.

Include this many sheets     Sets the number of worksheets that you want to use when you create a new workbook.

Personalize your copy of Office

User name     Type a name in the Name box to change your user name.

Choose the languages you want to use with Office     Click Language Settings to set your editing language preferences for the 2007 Microsoft Office system.