Navigate through Excel 2007 in seconds

When you're adjusting to Excel 2007's drastic interface changes, you might find yourself lost more often than you'd like. Experienced Excel users accustomed to earlier versions can suddenly feel as if they're novices. Talk about frustrating!
Instead of stopping to look in the Help files or on the Internet every couple of minutes, find your way to frequently used Excel tasks in seconds with our handy reference table. Cut it out and keep it by your computer for fewer headaches.



Excel task Old location 2007 location

AutoFilter Data | Filter | AutoFilter Home tab, Editing group, Sort & Filter button

(or Data tab, Sort & Filter group, Filter button)

Conditional Formatting Format | Conditional Formatting Home tab, Styles group, Conditional Formatting button

Page Setup File | Page Setup Page Layout tab, Page Setup group (click lower-right corner in the group to open the Page Setup dialog box)

Charts Insert | Chart Insert tab, Charts group (select chart type)

Options Tools | Options Click the Office button and click the Excel Options button

Protection Tools | Protection | Protect Sheet (or Protect Workbook) Review tab, Changes group, Protect Sheet button or Protect Workbook button

Hyperlink Insert | Hyperlink Insert tab, Links group, Hyperlink button

PivotTable Data | PivotTable And PivotChart Report Insert tab, Tables group, PivotTable button

Named Ranges Insert | Name | Define Formulas tab, Defined Names group, Name Manager button

Formula Auditing Tools | Formula Auditing | Evaluate Formula Formulas tab, Formula Auditing group, Evaluate Formula button

Sorting Data | Sort Home tab, Editing group, Sort & Filter button (or Data tab, Sort & Filter group, Sort button)

Add-Ins Tools | Add-In Name Add-Ins tab displays custom add-ins; built-in installed addins on the Formula tab in Solutions group or on the Data tab in the Analysis group
Number

Formatting Format | Cells (click on the Number tab) Home tab, Number group, Number Format dropdown list (click lower-right corner of the Number group to open the Format Cells dialog box)
AutoShapes

(Shapes in 2007) Click AutoShapes button on the Drawing toolbar (or Insert | Picture | AutoShapes) Insert tab, Illustrations group, Shapes button

Comments Insert | Comment Review tab, Comments group, New Comment button

Tired of that color scheme? Give Excel a new color scheme

Excel 2007 and 2010 give you a lot of new visual options when it comes to building a spreadsheet.

You can apply themes to your data and use new shape effects and conditional formatting looks. But what about your Excel application itself? Believe it or not, you don't need to stick with Microsoft's traditional blue color scheme in 2007, or the silver color scheme in 2010.

To change your Excel application's color scheme:Launch Excel and click the Office button (Home in 2010).
Click the Excel Options button to open the Excel Options dialog box (Options in 2010).
If necessary, choose Popular in the left pane.
Choose either Blue, Black, or Silver from the Color Scheme dropdown list.
Click OK to apply the new color scheme.