Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
| [ LiB ] |
Typing and Editing Cell Data
When you are typing data, you can save time with these shortcut keys:
| To execute this command | Do this |
|---|---|
| Edit the current cell | Press F2 |
| Start a new formula | Press = (equal sign) |
| Start an AutoSum formula | Press Alt+=(equal sign) |
| Start a new line in the same cell | Press Alt+Enter |
| Insert today's date | Press Ctrl+' (apostrophe) |
| Insert the current time | Press Ctrl+Shift+: ( colon ) |
| Cancel typing entry | Press Esc |
| Undo the last action | Press Ctrl+Z |
| Repeat last action | Press Ctrl+Y |
| Cut | Press Ctrl+X |
| Copy | Press Ctrl+C |
| Paste | Press Ctrl+V |
| Clear cell contents | Press Delete |
| Delete the selected cells | Press Ctrl+- (hyphen) |
| Insert blank cells. | Press Ctrl+Shift++ (plus sign) |
| Insert a hyperlink | Press Ctrl+K |
| Fill down | Press Ctrl+D |
| Fill right | Press Ctrl+R |
| Insert a new worksheet | Press Shift+F11 |
| [ LiB ] |