Excel 2007 Cheat Sheet: Quick reference charts

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

clear.gif

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

clear.gif

Window Menu

Excel 2003 Location

Excel 2007 Location

Keyboard Shortcut

Window > New WindowView > Window > New WindowAlt-W, N
Window > ArrangeView > Window > Arrange AllAlt-W, A
Window > Compare Side by Side withView > Window > View Side by SideAlt-W, B
Window > HideView > Window > HideAlt-W, H
Window > UnhideView > Window > UnhideAlt-W, U
Window > Split/Remove SplitView > Window > Split/Remove SplitAlt-W, S (toggle)
Window > Freeze Panes/Unfreeze PanesView > Window > Freeze Panes > Freeze Panes/Unfreeze Panes

In Excel 2003: Alt-W, F (toggle)

In Excel 2007: Alt-W, F, F (toggle)
Window > Currently Open WorkbooksView > Window > Switch Windows

In Excel 2003: Alt-W

In Excel 2007: Alt-W, W

Return to Excel 2007 Cheat Sheet

Copyright © 2007 IDG Communications, Inc.

1 2 3 4 5 6 7 8 Page 8
Page 8 of 8
It’s time to break the ChatGPT habit
Shop Tech Products at Amazon