Excel offers a wide range of keyboard shortcuts to help you work more efficiently. Here are some of the most common Excel shortcuts:
General Shortcuts
- Ctrl+C: Copy
- Ctrl+X: Cut
- Ctrl+V: Paste
- Ctrl+Z: Undo
- Ctrl+Y: Redo
- Ctrl+S: Save
- Ctrl+F: Find
- Ctrl+H: Replace
- Ctrl+P: Print
- Ctrl+O: Open
- Ctrl+N: New
Navigation Shortcuts
- Ctrl+Home: Go to the first cell in the worksheet
- Ctrl+End: Go to the last used cell in the worksheet
- Ctrl+Page Up: Scroll up one page
- Ctrl+Page Down: Scroll down one page
- Alt+Up Arrow: Go to the previous cell in the column
- Alt+Down Arrow: Go to the next cell in the column
- Alt+Left Arrow: Go to the previous cell in the row
- Alt+Right Arrow: Go to the next cell in the row
Editing Shortcuts
- F2: Edit the current cell
- F4: Repeat the last action or command
- Del: Delete the current cell
- Backspace: Delete the character to the left of the cursor
- Enter: Complete a cell entry and select the cell below
- Shift+Enter: Complete a cell entry and select the cell above
- Esc: Exit the current mode or dialog box
Formatting Shortcuts
- Ctrl+B: Bold
- Ctrl+I: Italic
- Ctrl+U: Underline
- Ctrl+Shift+B: Apply bold, italic, and underline formatting
- Ctrl+Shift+F12: Set the font and font size
- Ctrl+Shift+P: Set the paragraph alignment
Formula Shortcuts
- F9: Calculate all formulas in all open workbooks
- Shift+F9: Calculate all formulas in the active worksheet
- Ctrl+Shift+F9: Calculate all formulas in all sheets of the current workbook
- F5: Go to the “Go to” dialog box
- Ctrl+Shift+F12: Define a name for a range or formula
These are just a few of the many Excel shortcuts that are available. For a complete list of Excel shortcuts, you can refer to the Excel Help documentation.