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 |
dummies
Source:http://www.dummies.com/how-to/content/keyboard-shortcuts-for-entering-data-in-excel-2003.html
No comments:
Post a Comment