Excel TipsThe Best Shortcut Keys in Microsoft Excel
CA Community For CA
| Ctrl+Z | Undo |
| Ctrl+C Enter, Ctrl+V Ctrl+X | Copy, Paste, Multiple Paste, Cut |
| Ctrl+F, Ctrl+H | Find, Find&Replace |
| Ctrl+P, Ctrl+S, Ctrl+F4, Alt+F4 | Print, Save, Close, Close Excel |
| Ctrl+Arrow | Move to edge of region |
| Ctrl+* | Select current region |
| Ctrl+A | Select all cells |
| Ctrl+Home Ctrl+End | Select A1, Select last cell in used range |
| Ctrl+Shift+End | Select from active cell to last cell in used range. |
| Ctrl+Shift+Home | Select from active cell to A1 |
| Ctrl+Page Down Ctrl+Page Up | Move to the next sheet, Move to the previous sheet |
| Ctrl+Tab | Move to next open workbook |
| Ctrl+N | Open new workbook |
| Shift+F11 | Insert new worksheet |
| Shift+F3 | Paste function window |
| =+FunctionName+Ctrl+A | Insert new function |
| Alt+F11 | Open VBE |
| Ctrl+Shift+Enter | Array formula |
| Ctrl+F3, F3 | Define name, Paste name |
| Ctrl+Spacebar Shift+Spacebar | Select columns, Select rows |
| Ctrl+1, Ctrl+B, Ctrl+U | Format cells, Bold, Underline |
| Ctrl+; , Ctrl+shift+: | Current date, Current time |
No comments:
Post a Comment