Keyboard Shortcuts for Entering Data in Excel 2003 - dummies

Keyboard Shortcuts for Entering Data in Excel 2003

By Greg Harvey

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

Filling in all those empty Excel 2003 cells may seem daunting, but keyboard shortcuts ease the pain. Use these Excel 2003 keyboard shortcuts to enter data quickly. You’ll find Excel a much more enjoyable, and a lot less fatiguing, experience.

Press To
An arrow key Complete cell entry and move cell pointer one cell in direction
of the arrow
Enter Complete cell entry and move cell pointer down one row
Shift+Enter Complete cell entry and move cell pointer up one row
Ctrl+Enter Complete cell entry in all cells in selected range
Alt+Enter Begin a new line in a cell entry
Tab Complete cell entry and move cell pointer right one column
Shift+Tab Complete cell entry and move cell pointer left one column
Esc Cancel current cell entry
Ctrl+’ (apostrophe) Copy formula in cell above into current cell entry
Ctrl+Shift+” (quotation) Copy value from formula in cell above into current cell
entry
Ctrl+` (accent) Toggle between displaying cell values and cell formulas in
worksheet
Ctrl+; Insert current date into current cell entry
Ctrl+Shift+; Insert current time into current cell entry