Here's a cheat sheet of some commonly used Excel shortcuts for power users:
- Ctrl + C: Copy selected cells
- Ctrl + V: Paste copied cells
- Ctrl + X: Cut selected cells
- Ctrl + Z: Undo last action
- Ctrl + Y: Redo last action
- Ctrl + A: Select all cells
- Ctrl + F: Open find and replace dialog box
- Ctrl + H: Open find and replace dialog box with replace tab selected
- Ctrl + N: Create a new workbook
- Ctrl + O: Open an existing workbook
- Ctrl + S: Save the current workbook
- Ctrl + P: Print the current workbook
- Ctrl + W: Close the current workbook
- Ctrl + F1: Hide or show the ribbon
- Ctrl + F4: Close the current workbook window
- Ctrl + Tab: Switch to the next workbook window
- Ctrl + Shift + L: Turn on or off the filter
- Alt + Enter: Insert a line break within a cell
- F2: Edit the active cell
- F4: Repeat the last action
- F11: Create a chart based on the selected data
- F12: Save the current workbook with a new name
These shortcuts can save you a lot of time and improve your productivity while working with Excel.
