Excel 2007 Cheat Sheet: Quick reference charts

Find your favorite Excel 2003 commands in the new Excel 2007 interface

Related Topics
clear.gif

File Menu  |  Edit Menu  |  View Menu  |  Insert Menu  |  Format Menu  |  Tools Menu  |  Data Menu  |  Window Menu

clear.gif

Data Menu

Excel 2003 Location

Excel 2007 Location

Keyboard Shortcut

Data > Sort

Data > Sort & Filter > Sort

or

Home > Editing > Sort & Filter > Sort

In Excel 2003: Alt-D, S

In Excel 2007: Alt-A, S
Data > Filter

Data > Sort & Filter > Filter

or

Home > Editing > Sort & Filter > Filter

In Excel 2003: Alt-D, F

In Excel 2007: Alt-A, T
Data > FormAdd to Quick Access tool bar: Office button > Excel Options > Customize > All Commands > Form

In Excel 2003: Alt-D, O

In Excel 2007: Alt-[number of position in Quick Access tool bar]
Data > SubtotalsData > Outline > Subtotal

In Excel 2003: Alt-D, B

In Excel 2007: Alt-D, B or Alt-A, B
Data > ValidationData > Data Tools > Data Validation

In Excel 2003: Alt-D, L

In Excel 2007: Alt-D, L or Alt-A, V
Data > TableData > Data Tools > What-If Analysis > Data TableAlt-D, T
Data > Text to ColumnsData > Data Tools > Convert Text to Table

In Excel 2003: Alt-D, E

In Excel 2007: Alt-D, E or Alt-A, E
Data > ConsolidateData > Data Tools > Consolidate

In Excel 2003: Alt-D, N

In Excel 2007: Alt-D, N or Alt-A, N
Data > Group and OutlineData > Outline

In Excel 2003: Alt-D, G

In Excel 2007: Alt-A, [letter depends on group/outline selection]
Data > PivotTable and PivotChart ReportInsert > Tables > PivotTable > PivotTable/PivotChartAlt-D, P
Data > Import External DataData > Get External Data

In Excel 2003: Alt-D, D

In Excel 2007: Alt-A, [letter depends on data source]
Data > ListData > Get External DataCtrl-L
Data > XMLDeveloper > XML

In Excel 2003: Alt-D, X

In Excel 2007: Alt-L, X (when Developer tab is showing)
Data > Refresh DataData > Connections > Refresh All > Refresh All

In Excel 2003: Alt-D, R

In Excel 2007: Alt-A, R, A

Return to Excel 2007 Cheat Sheet

1 2 3 4 5 6 7 8 Page 7
Page 7 of 8
  
Shop Tech Products at Amazon