Enter data by using shortcut keys:Enter data by using shortcut keys:The following is a table of shortcut keys available for entering data into a Microsoft Excel spreadsheet. The left column gives the desired action and the right column gives the associated shortcut key.
| Desired Action | Shortcut Key |
|---|---|
| Complete a cell entry. | ENTER |
| Cancel a cell entry. | ESC |
| Repeat the last action. | F4 or CONTROL+Y |
| Start a new line in the same cell. | ALT+ENTER |
| Delete character to the left of the insertion point, or delete the selection. | BACKSPACE |
| Delete character to the right of the insertion point, or delete the selection. | DELETE |
| Delete character to the end of the line. | CONTROL+DELETE |
| Move one character up, down, left, or right. | ARROW KEYS |
| Move to the beginning of the line. | HOME |
| Edit a cell comment. | SHIFT+F2 |
| Create names from row and column labels. | CONTROL+SHIFT+F3 |
| Fill down. | CONTROL+D |
| Fill to the right. | CONTROL+R |
| Fill the selected cell range with the current entry. | CONTROL+ENTER |
| Complete a cell entry and move down in the selection. | ENTER |
| Complete a cell entry and move up in the selection. | SHIFT+ENTER |
| Complete a cell entry and move to the right in the selection. | TAB |
| Complete a cell entry and move to the left in the selection. | SHIFT+TAB |
| Start a formula. | = |
| Cancel an entry in the cell or fomula bar. | ESC |
| Edit the active cell. | F2 |
| Edit the active cell and then clear it,or delete the preceding character in the active cell as you edit the cell contents. | BACKSPACE |
| Paste a name into a formula. | F3 |
| Define a name. | CONTROL+F3 |
| Calculate all sheets in all open workbooks. | F9 |
| Calculate the active worksheet. | SHIFT+F9 |
| Insert the AutoSum formula. | ALT+= |
| Enter the date. | CONTROL+; |
| Enter the time. | CONTROL+SHIFT+: |
| Insert a hyperlink. | CONTROL+K |
| Complete a cell entery. | ENTER |
| Copy the value from the cell above the active cell into the cell or the formula bar. | CONTROL+SHIFT+" |
| Alternate between displaying cell values and displaying cell formulas. | CONTROL+" |
| Copy a formula from the cell above the active cell into the cell or the formula bar. | CONTROL+' |
| Enter a formula as an array formula. | CONTROL+SHIFT+ENTER |
| Display the Formula Palette after you type a valid function name in a formula. | CONTROL+A |
| Insert the argument names and parentheses for a function, after you type a valid function name in a formula. | CONTROL+SHIFT+A |
| Display the AutoComplete list. | ALT+DOWN ARROW |
Contact us at infotechaccess@server.rehab.uiuic.edu