Microsoft Excel is a powerful spreadsheet application with many keyboard shortcuts to help you work more efficiently. Here are some commonly used Excel keyboard shortcuts:
Here are some commonly used Excel keyboard shortcuts in a tabular form:
| Action | Shortcut |
|---|---|
| Navigation Shortcuts | |
| Move one cell up | Arrow Up |
| Move one cell down | Arrow Down |
| Move one cell left | Arrow Left |
| Move one cell right | Arrow Right |
| Move to the edge of data region | Ctrl + Arrow Key (Up, Down, Left, Right) |
| Move to the beginning of the row | Home |
| Move to the beginning of the worksheet | Ctrl + Home |
| Move to the last cell of data region | Ctrl + End |
| Move to the last cell of the worksheet | Ctrl + Shift + End |
| Selection Shortcuts | |
| Select the entire worksheet | Ctrl + A |
| Select an entire row | Shift + Space |
| Select an entire column | Ctrl + Space |
| Select adjacent cells | Shift + Arrow Key (Up, Down, Left, Right) |
| Extend the selection | Shift + (Arrow Key or Click) |
| Editing Shortcuts | |
| Cut selected cells | Ctrl + X |
| Copy selected cells | Ctrl + C |
| Paste copied/cut cells | Ctrl + V |
| Undo | Ctrl + Z |
| Redo | Ctrl + Y (or Ctrl + Shift + Z) |
| Insert a new worksheet | Shift + F11 |
| Delete the selected cells/rows/columns | Ctrl + – (minus key) |
| Fill down (copy cell value down) | Ctrl + D |
| Fill right (copy cell value to the right) | Ctrl + R |
| Formatting Shortcuts | |
| Format cells dialog | Ctrl + 1 |
| Bold text | Ctrl + B |
| Italicize text | Ctrl + I |
| Underline text | Ctrl + U |
| Apply number format | Ctrl + Shift + ! (Exclamation Mark) |
| Increase font size | Ctrl + Shift + > (Greater Than) |
| Decrease font size | Ctrl + Shift + < (Less Than) |
| Miscellaneous Shortcuts | |
| AutoSum (Sum selected cells) | Alt + = |
| Toggle formula cell reference style | F4 (when editing a formula) |
| Open the “Save As” dialog | F12 |
| Start a new line within a cell | Alt + Enter |
| Toggle between worksheet tabs | Ctrl + Page Up (Previous Tab) or Ctrl + Page Down (Next Tab) |
These are just a few of the many Excel keyboard shortcuts available. Learning and using keyboard shortcuts can significantly improve your productivity when working with Excel.
Basic Navigation:
- Arrow keys: Move the active cell in the direction of the arrow key.
- Tab: Move to the next cell to the right.
- Shift + Tab: Move to the previous cell to the left.
- Enter: Move to the cell below.
- Shift + Enter: Move to the cell above.
- Ctrl + Arrow keys: Jump to the edge of data regions.
- Ctrl + Home: Go to the beginning of the worksheet.
- Ctrl + End: Go to the last cell containing data.
Selecting Cells:
- Shift + Arrow keys: Select a range of cells.
- Ctrl + Space: Select the entire column of the active cell.
- Shift + Space: Select the entire row of the active cell.
- Ctrl + A: Select the entire worksheet.
Editing Cells:
- F2: Edit the active cell.
- Ctrl + X: Cut selected cells.
- Ctrl + C: Copy selected cells.
- Ctrl + V: Paste copied or cut cells.
- Ctrl + Z: Undo the last action.
- Ctrl + Y: Redo the last undone action.
- Delete: Clear the contents of selected cells.
- Ctrl + Backspace: Clear the contents of the active cell.
- Ctrl + \”-\” (minus key): Delete the selected cells.
Formatting:
- Ctrl + B: Bold text.
- Ctrl + I: Italicize text.
- Ctrl + U: Underline text.
- Ctrl + 1: Format cells dialog box.
- Ctrl + 5: Apply or remove strikethrough.
- Ctrl + Shift + L: Add or remove bullet points.
- Ctrl + 9: Hide selected rows.
- Ctrl + 0 (zero): Hide selected columns.
Working with Worksheets:
- Ctrl + Page Up: Move to the previous worksheet.
- Ctrl + Page Down: Move to the next worksheet.
- Alt + E, S, V: Paste special.
- Ctrl + F6: Switch between open workbooks.
Formulas and Functions:
- = (equals sign): Start a formula.
- F4: Repeat the last action in a formula.
- Ctrl + Shift + Enter: Enter an array formula.
- Alt + Equals: AutoSum.
- Ctrl + ` (backtick): Show or hide formula values.
Miscellaneous:
- Ctrl + S: Save the workbook.
- Ctrl + N: Create a new workbook.
- Ctrl + O: Open an existing workbook.
- Ctrl + P: Print the workbook.
- Ctrl + F: Find text within the worksheet.
- Ctrl + H: Replace text within the worksheet.
These are just a selection of the many keyboard shortcuts available in Excel. Using shortcuts can significantly speed up your work and make you more productive in Excel.
