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