docs / articles / Excel Shortcut Keys A-Z: Master the List

Excel Shortcut Keys A-Z: Master the List

Sara Jul 09, 2026 2026-07-09 04:40:45

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.

the excel shortcut keys list is shown in pink and blue, with numbers on each side
the excel shortcut keys list is shown in pink and blue, with numbers on each side

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.

the keyboard shortcuts list is shown here
the keyboard shortcuts list is shown here

Basic Navigation and Editing Shortcuts

Before we delve into more complex shortcuts, let's familiarize ourselves with the basics.

Excel Keyboard Shortcuts Every Office User Should Know
Excel Keyboard Shortcuts Every Office User Should Know

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

Undo and Redo

Excel shortcut key
Excel shortcut key

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

Computer tricks๐Ÿ˜‰
Computer tricks๐Ÿ˜‰

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

an excel shortcut key is shown in green and white
an excel shortcut key is shown in green and white

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:

a poster with the words 70 important computer and excel shortcut keys
a poster with the words 70 important computer and excel shortcut keys
Excel shortcut ...โœ…
Excel shortcut ...โœ…
Microsoft Excel Shortcut key
Microsoft Excel Shortcut key
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
20 Excel Shortcut Keys Every Student & Professional Must Know | Excel Tips & Tricks
Excel Shortcut Keys Cheat Sheet
Excel Shortcut Keys Cheat Sheet
20 Advanced Excel Shortcut Keys Every Professional Should Know | Excel Productivity Cheat Sheet
20 Advanced Excel Shortcut Keys Every Professional Should Know | Excel Productivity Cheat Sheet
excel useful shortcuts
excel useful shortcuts
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
the excel shortcut keys chart sheet is shown in green and has instructions for how to use
the ultimate guide to excel shortcut keys
the ultimate guide to excel shortcut keys
top 10p excel shortcut keys .
top 10p excel shortcut keys .
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
Microsoft Excel Cheat Sheet | Essential Formulas, Shortcuts & Productivity Tips
the advanced excel shortcuts guide for windows and macosk, with instructions on how to use them
the advanced excel shortcuts guide for windows and macosk, with instructions on how to use them
Excel Home Tab Shortcuts for Beginners & Professionals
Excel Home Tab Shortcuts for Beginners & Professionals
Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...
Microsoft Excel Laminated Shortcut Card - Over 200 Keyboard Shortcuts for Windows and Mac Side-by...
20excal shortcut keys. easy too remember
20excal shortcut keys. easy too remember
Excel shortcuts
Excel shortcuts
๐Ÿ“ˆ Master Excel Like a Pro: 100+ Essential Shortcuts
๐Ÿ“ˆ Master Excel Like a Pro: 100+ Essential Shortcuts
Top 20 Advanced Excel Shortcut Keys You Should Know
Top 20 Advanced Excel Shortcut Keys You Should Know
1M Views On Excel Shortcut Keys
1M Views On Excel Shortcut Keys

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!