Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

Keyboard Shortcuts for Entering Data in Excel 2003

Part of the 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
blog comments powered by Disqus
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.