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

Format Menu

Excel 2003 Location

Excel 2007 Location

Keyboard Shortcut

Format > CellsHome > Cells > Format > Format CellsAlt-O, E
Format > RowHome > Cells > Format

In Excel 2003: Alt-O, R

In Excel 2007: Alt-H, O
Format > ColumnHome > Cells > Format

In Excel 2003: Alt-O, C

In Excel 2007: Alt-H, O
Format > SheetHome > Cells > Format

In Excel 2003: Alt-O, H

In Excel 2007: Alt-H, O
Format > AutoFormatHome > Styles > Format as Table

In Excel 2003: Alt-O, A

In Excel 2007: Alt-O, A or Alt-H, T
Format > Conditional FormattingHome > Styles > Conditional Formatting

In Excel 2003: Alt-O, D

In Excel 2007: Alt-O, D or Alt-H, L
Format > StyleHome > Styles > Cell Styles

In Excel 2003: Alt-O, S

In Excel 2007: Alt-O, S or Alt-H, J

Return to Excel 2007 Cheat Sheet

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