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

Insert Menu

Excel 2003 Location

Excel 2007 Location

Keyboard Shortcut

Insert > CellsHome > Cells > Insert > Insert CellsAlt-I, E
Insert > Rows

Home > Cells > Insert > Insert Sheet Rows

Alt-I, R
Insert > ColumnsHome > Cells > Insert > Insert Sheet ColumnsAlt-I, C
Insert > WorksheetHome > Cells > Insert > Insert SheetAlt-I, W
Insert > ChartInsert > ChartsAlt-I, H
Insert > SymbolInsert > Text > Symbol

In Excel 2003: Alt-I, S

In Excel 2007: Alt-I, S or Alt-N, U
Insert > Page BreakPage Layout > Page Setup > Breaks > Insert Page BreakAlt-I, B
Insert > FunctionFormulas > Function Library > Insert Function

In Excel 2003: Alt-I, F

In Excel 2007: Alt-I, F or Alt-M, F

Insert > NameFormulas > Defined Names

In Excel 2003: Alt-I, N

In Excel 2007: Alt-M, M
Insert > CommentReview > Comments > New Comment

In Excel 2003: Alt-I, M

In Excel 2007: Alt-I, M or Alt-R, C
Insert > PictureInsert > Illustrations

In Excel 2003: Alt-I, P

In Excel 2007: Alt-N, [letter depends on type of art inserted]
Insert > DiagramInsert > Illustrations > SmartArt

In Excel 2003: Alt-I, G

In Excel 2007: Alt-N, M
Insert > ObjectInsert > Text > ObjectAlt-I, O
Insert > HyperlinkInsert > Links > HyperlinkCtrl-K

Return to Excel 2007 Cheat Sheet

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