Edit data by using shortcut keysEdit data by using shortcut keysThe following three tables give keyboard commands available in Microsoft Excel for:
In each table, the left column gives the desired action and the right column gives the associated keyboard shortcut.
| Desired Action | Keyboard Shortcut |
|---|---|
| Edit the active cell. | F2 |
| Cancel an entry in the cell or formula bar. | ESC |
| 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 |
| Complete a cell entry. | ENTER |
| 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 |
| Desired Action | Keyboard Shortcut |
|---|---|
| Copy the selection. | CONTROL+C |
| Paste the selection. | CONTROL+V |
| Cut the selection. | CONTROL+X |
| Clear the contents of the selection. | DELETE |
| Insert blank cells. | CONTROL+SHIFT+= |
| Delete the selection. | CONTROL+- |
| Undo the last action. | CONTROL+Z |
| Desired Action | Keyboard Shortcut |
|---|---|
| Move from top to bottom within the selection (down), or in the direction that is selected on the Edit tab (Tools menu, Options command). | ENTER |
| Move from bottom to top within the selection (up), or opposite to the direction that is selected on the Edit tab (Tools menu, Options command). | SHIFT+ENTER |
| Move from left to right within the selection, or move down one cell if only one column is selected. | TAB |
| Move from right to left within the selection, or move up one cell if only one column is selected. | SHIFT+TAB |
| Move clockwise to the next corner of the selection. | CONTROL+. |
| Move to the right between nonadjacent selections. | CONTROL+ALT+RIGHT ARROW |
| Move to the left between nonadjacent selections. | CONTROL+ALT+LEFT ARROW |
Contact us at infotechaccess@server.rehab.uiuic.edu