Keyboard Shortcuts for Editing Cells in Excel 2003

By Greg Harvey

Part of Excel 2003 All-in-One For Dummies Cheat Sheet

Editing information within a cell in Excel 2003 can get confusing without some guidance. Excel 2003 has plenty of keyboard shortcuts to make editing cells a breeze:

Press To
F2 Edit current cell entry and position insertion point at the end
of cell contents
Shift+F2 Edit comment attached to current cell and position insertion
point in comment box
Backspace Delete character to left of insertion point when editing cell
Delete Delete character to right of insertion point when editing cell
entry; otherwise, clear cell entries in current range
Esc Cancel editing in current cell entry
Enter Complete editing in current cell entry
Ctrl+CC Open Clipboard Task pane
Ctrl+C Copy cell selection to Clipboard
Ctrl+X Cut cell selection to Clipboard
Ctrl+V Paste last copied or cut cells from Clipboard
Ctrl+hyphen (-) Open Delete dialog box to delete cell selection and shift
remaining cells left or up
Ctrl+Shift+plus (+) Open Insert dialog box to insert new cells and shift existing
cells right or down
Ctrl+Z Undo last action
Ctrl+Y Redo last action