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

Excel Data Entry Shortcut Keys

Part of the Excel Workbook For Dummies Cheat Sheet

When you're working in Excel and entering data in a cell, it's essential to complete the entry either by clicking another cell with the mouse pointer or by using one of the handy shortcut keys shown here to move the cell cursor:

Press To
Arrow keys (↑, ↓, ←, →) Complete cell entry and move cell cursor one cell in direction of the arrow
Enter Complete cell entry and move cell cursor down one row
Shift+Enter Complete cell entry and move cell cursor 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 cursor right one column
Shift+Tab Complete cell entry and move cell cursor 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 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

SERIES
Excel Workbook For Dummies Cheat Sheet

Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.