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

View Menu

Excel 2003 Location

Excel 2007 Location

Keyboard Shortcut

View > NormalView > Workbook Views > Normal

In Excel 2003: Alt-V, N

In Excel 2007: Alt-W, L
View > Page Break PreviewView > Workbook Views > Page Break Preview

In Excel 2003: Alt-V, P

In Excel 2007: Alt-W, I
View > Task PaneThe overall task pane is gone in Excel 2007, but some dialog box launchers display task panes.

In Excel 2003: Ctrl-F1

In Excel 2007: not available
View > Tool barsExcel 2007 no longer has tool bars.

In Excel 2003: Alt-V, T

In Excel 2007: not available
View > Formula BarView > Show/Hide > Formula BarAlt-V, F
View > Status BarThe Status Bar is always visible.

In Excel 2003: Alt-V, S

In Excel 2007: not available
View > Header and FooterInsert > Text > Header & FooterAlt-V, H
View > CommentsReview > Comments > Show All CommentsAlt-V, C
View > Custom ViewsView > Workbook Views > Custom Views

In Excel 2003: Alt-V, V

In Excel 2007: Alt-W, C
View > Full ScreenView > Workbook Views > Full ScreenAlt-V, U
View > ZoomView > Zoom > ZoomAlt-V, Z

Return to Excel 2007 Cheat Sheet

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