Mastering Excel shortcut keys can significantly enhance your productivity and efficiency. These keyboard combinations can save you time and reduce the strain of repetitive tasks. Here, we've compiled an alphabetical list of Excel shortcut keys, from A to Z, to help you streamline your workflow.

Whether you're a seasoned Excel user or just starting out, this comprehensive guide will serve as a handy reference. Let's dive into the world of Excel shortcuts and unlock your full potential.

Basic Navigation and Editing Shortcuts
Before we delve into more complex shortcuts, let's familiarize ourselves with the basics.

These fundamental shortcuts will help you navigate and edit your spreadsheets with ease:
Undo and Redo

The Ctrl + Z (Windows/Linux) or Cmd + Z (Mac) shortcut is your best friend when you need to undo an action. To redo an action, use Ctrl + Y (Windows/Linux) or Cmd + Shift + Z (Mac).
For multiple undos or redos, you can use the Ctrl + Alt + Z (Windows/Linux) or Cmd + Alt + Z (Mac) shortcut to cycle through your actions.
Cut, Copy, and Paste

These essential shortcuts allow you to manipulate data quickly:
- Ctrl + X (Windows/Linux) or Cmd + X (Mac) to cut selected data
- Ctrl + C (Windows/Linux) or Cmd + C (Mac) to copy selected data
- Ctrl + V (Windows/Linux) or Cmd + V (Mac) to paste data
Formulas and Functions

Excel's power lies in its formulas and functions. These shortcuts will help you work with them more efficiently.
Remember to press Enter after typing a formula to apply it:




















AutoSum and AutoFill
Use the Alt + = (Windows/Linux) or Cmd + T (Mac) shortcut to automatically sum a range of cells. For AutoFill, select the cell with the formula and drag the small square in the bottom-right corner to copy the formula to other cells.
Alternatively, you can use the Ctrl + D (Windows/Linux) or Cmd + D (Mac) shortcut to copy the formula down to the selected cells.
Insert Function
The Ctrl + Shift + A (Windows/Linux) or Cmd + Shift + A (Mac) shortcut opens the Insert Function dialog box, allowing you to choose from a list of functions to insert into your formula.
You can also use the Alt + F1 (Windows/Linux) or Cmd + F1 (Mac) shortcut to insert a function based on the selected cell's content.
Formatting and Viewing Shortcuts
These shortcuts help you format and view your data more effectively.
Remember to select the cells you want to format before using these shortcuts:
Bold, Italic, and Underline
Use the following shortcuts to apply formatting to selected text:
- Ctrl + B (Windows/Linux) or Cmd + B (Mac) to make text bold
- Ctrl + I (Windows/Linux) or Cmd + I (Mac) to make text italic
- Ctrl + U (Windows/Linux) or Cmd + U (Mac) to underline text
Freeze Panes
To freeze the top row or column, select the cell below or to the right of the row or column you want to freeze, then use the Ctrl + Alt + F1 (Windows/Linux) or Cmd + Alt + F1 (Mac) shortcut. To unfreeze panes, use the same shortcut.
You can also use the Alt + A (Windows/Linux) or Cmd + A (Mac) shortcut to access the Freeze Panes dialog box.
Embracing these Excel shortcuts will transform the way you work with spreadsheets. Practice them regularly to build muscle memory and watch your productivity soar. Happy Exceling!