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

Edit Menu

Excel 2003 Location

Excel 2007 Location

Keyboard Shortcut

Edit > UndoQuick Access tool bar > Undo iconCtrl-Z
Edit > RedoQuick Access tool bar > Redo iconCtrl-Y
Edit > CutHome > Clipboard > CutCtrl-X
Edit > CopyHome > Clipboard > CopyCtrl-C
Edit > Office ClipboardHome > Clipboard dialog box launcher

In Excel 2003: Alt-E, B

In Excel 2007: Alt-H, FO
Edit > PasteHome > Clipboard > PasteCtrl-V
Edit > Paste Special

Home > Clipboard > Paste > Paste Special

In Excel 2003: Alt-E, S

In Excel 2007: Alt-E, S or Alt-Ctrl-V
Edit > Paste as HyperlinkHome > Clipboard > Paste > Paste as HyperlinkAlt-E, H
Edit > FillHome > Editing > Fill

In Excel 2003: Alt-E, I

In Excel 2007: Alt-H, FI
Edit > ClearHome > Editing > Clear

In Excel 2003: Alt-E, A

In Excel 2007: Alt-H, E
Edit > DeleteHome > Cells > Delete

In Excel 2003: Alt-E, D

In Excel 2007: Alt-H, D
Edit > Delete SheetHome > Cells > Delete > Delete Sheet

In Excel 2003: Alt-E, L

In Excel 2007: Alt-H, D, S
Edit > Move or Copy SheetHome > Cells > Format > Move or Copy Sheet

In Excel 2003: Alt-E, M

In Excel 2007: Alt-H, O, M
Edit > FindHome > Editing > Find & Select > FindCtrl-F
Edit > ReplaceHome > Editing > Find & Select > ReplaceCtrl-H
Edit > Go ToHome > Editing > Find > Find & Select > Go ToCtrl-G

Return to Excel 2007 Cheat Sheet

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