docs / articles / Master Excel: Reveal All Shortcut Keys Instantly

Master Excel: Reveal All Shortcut Keys Instantly

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

Ever found yourself wishing you could remember all those handy Excel shortcuts? Instead of hunting through help menus or relying on muscle memory, why not learn how to display them right within your Excel window? Here's a step-by-step guide on how to see all shortcut keys in Excel.

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

Knowing your way around Excel shortcuts can significantly boost your productivity. So, let's dive into the world of keyboard shortcuts and make your Excel experience more efficient.

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

Displaying Shortcut Keys in Excel

Excel provides a built-in feature to display shortcut keys. This function helps you learn and remember the shortcuts as you work.

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

Before we start, ensure you're using Excel 2007 or later, as the feature is not available in earlier versions.

Using the 'Show Shortcuts' Feature

Computer tricks😉
Computer tricks😉

Excel's 'Show Shortcuts' feature is the easiest way to view shortcut keys. Here's how to enable it:

1. Open Excel and click on the 'File' tab.

2. Select 'Options' at the bottom of the menu.

Excel shortcut ...✅
Excel shortcut ...✅

3. In the 'Excel Options' dialog box, click on 'Customize Ribbon' on the left-hand side.

4. Under 'Main Tabs', scroll down and select 'Quick Access Toolbar'.

5. In the 'Choose commands from' dropdown, select 'All Tabs'.

a poster with the words 70 important computer and excel shortcut keys
a poster with the words 70 important computer and excel shortcut keys

6. Scroll down and select 'Show Shortcuts'. Click 'Add' to move it to the 'Customize Quick Access Toolbar' list.

7. Click 'OK' to close the dialog box.

Excel Shortcut Keys Cheat Sheet
Excel Shortcut Keys Cheat Sheet
Excel Home Tab Shortcuts for Beginners & Professionals
Excel Home Tab Shortcuts for Beginners & Professionals
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 useful shortcuts
excel useful shortcuts
the different types of shortcut keys are shown in this chart, which shows how to use
the different types of shortcut keys are shown in this chart, which shows how to use
Top 20 Advanced Excel Shortcut Keys You Should Know
Top 20 Advanced Excel Shortcut Keys You Should Know
23 Excel important Shortcut Key's
23 Excel important Shortcut Key's
173K views | Reel by Harkesh Kumar
173K views | Reel by Harkesh Kumar
Excel shortcuts and tips
Excel shortcuts and tips
Excel shortcuts
Excel shortcuts
an exercise sheet with the words excel shortcuts and how to fill them out
an exercise sheet with the words excel shortcuts and how to fill them out
56 Easiest Excel Shortcut Keys for 2025
56 Easiest Excel Shortcut Keys for 2025
an open notebook with the words all excel shortcuts on it
an open notebook with the words all excel shortcuts on it
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
50 Essential Excel Shortcut Keys Everyone Should Know | Boost Productivity Fast
Excel Shortcut Keys | Easy Tricks for Beginners
Excel Shortcut Keys | Easy Tricks for Beginners
Master Excel faster with these beginner-friendly shortcuts ⌨️
Master Excel faster with these beginner-friendly shortcuts ⌨️
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...
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
an image of a computer keyboard with the words excel ctrl shortcuts
an image of a computer keyboard with the words excel ctrl shortcuts
shortcut keys
shortcut keys

Using the 'Tell Me' Feature

If you're using Excel 2010 or later, you can also use the 'Tell Me' feature to display shortcut keys.

1. Open Excel and click on the 'Tell Me' box in the top-right corner of the window.

2. Type 'Show Shortcuts' and press Enter.

3. The 'Show Shortcuts' feature will be enabled, and you'll see the shortcut keys for the current tab.

Now that you've enabled the shortcut keys, let's explore how to use them effectively.

Using Shortcut Keys in Excel

Once you've enabled the shortcut keys, you'll notice that they appear next to the command buttons in the ribbon. This helps you learn and remember the shortcuts as you work.

To use a shortcut key, simply press the key or key combination while working in Excel. For example, pressing 'Ctrl + C' will copy the selected cells, while 'Ctrl + V' will paste them.

Customizing Shortcut Keys

If you find that Excel's default shortcut keys aren't to your liking, you can customize them. Here's how:

1. Open Excel and click on the 'File' tab.

2. Select 'Options' at the bottom of the menu.

3. In the 'Excel Options' dialog box, click on 'Customize Ribbon' on the left-hand side.

4. Click on 'Customize' next to 'Keyboard shortcuts'.

5. In the 'Press new shortcut key' box, press the key or key combination you want to assign to a command.

6. In the 'Choose commands from' dropdown, select the command you want to assign the shortcut key to.

7. Click 'Assign' to assign the shortcut key to the command.

8. Click 'OK' to close the dialog box.

And there you have it! You're now well on your way to mastering Excel shortcut keys and boosting your productivity. Happy Excel-ing!