This guide will help you if your keyboard shortcuts are not working in Excel. Learn how to fix it quickly and easily!
We love Excel Keyboard Shortcuts and other time-saving features! However, you want to apply your favorite shortcut, but nothing happens. How to deal with it?
One of the most frustrating things: your keyboard shortcuts are not work in Excel. This post will provide a workaround for why your shortcuts are not working in Microsoft Excel and how to fix them.
Table of contents
- Excel Shortcuts not working because any macro shortcut is assigned
- Check add-ins (programs) with hard-coded shortcut keys
- Shortcuts are not working due to Media Keys
- Differences between Keyboard Layouts
- Excel Shortcuts are not working on Mac
Excel Shortcuts not working because any macro shortcut is assigned
Basic, but many people forget to check macros. Take a closer look at the macros to see if you have used the same shortcut for any other macro records.
For example, you want to add a custom macro to your Personal.xlsb workbook and place it on the ribbon or Quick Access Toolbar.
When you add a new shortcut key for your macro; – the keys are available in Excel.
Here is an example. In the previous article, we’ve added a new macro to implement an improved Save As Shortcut using the Ctrl + Shift + S keys.
It’s okay and looks good.
The recorded small macro will perform the task. Pick the shortcut key carefully! The new shortcut is not assigned any operation yet. So, it will work and never conflict with any other shortcuts. If you are in trouble, take a closer look at your macros and clean up the personal macro Workbook.
Check add-ins (programs) with hard-coded shortcut keys
Some add-ins come with hard-coded shortcuts. These add-ins override your existing shortcuts and cause conflicts between the built-in Excel shortcuts and the 3rd party software shortcuts.
Please read the software documentation and the technical guide carefully if you want to add a new program.
Look at the picture below: we are working with the most popular screen capturing program. There are two hard-coded shortcuts:
- Ctrl + S for scrolling capture
- Ctrl + T for grabbing text
While both programs are running, the Ctrl + T shortcut (create a new Table shortcut in Excel) will start capturing.
When your default shortcuts are not working, edit the 3rd party program shortcuts to eliminate issues.
Shortcuts are not working due to Media Keys
Most of the modern keyboards come with pre-defined hardware media keys as the primary command.
Good to know that media keys are triggered. For example, from F1 to F12, all media keys have different functions, like increasing or decreasing the volume. Let us see the possible workarounds to fix the multimedia keys issues.
Use the Fn button to fix the Excel Shortcut
If you have problems with your keyboards media keys regarding shortcuts in Excel, use the Fn key to fix them.
For example, if Shift + F11 for Insert new Worksheet shortcut key is not working, your media keys are set up as the primary. To fix the shortcut, press Shift + Fn + F11, and your shortcut will work again.
Let us suppose that you press F4 to switch between relative and absolute references. Then, if the dollar sign ($) does not appear, try to use the Fn + F4 combination. It will work!
Here are some function key-based examples with Fn key:
- Press Fn + F1 to open Help in Office programs
- Press Fn + F12 to use the Save As Shortcut
Function lock for the media keys on your Laptop
Okay, now you want to switch to media keyboard back. Here is a quick tip: lock your media keys on your keyboard.
- Solution 1: If you are using a laptop, hold the Fn button for one second. You’ll get the defaults back.
- Solution 2: On USB / Bluetooth keyboards, you can activate the Function Lock shortcut: press Fn + Esc.
Differences between Keyboard Layouts (international)
In some cases, you need to use more than one language settings on your Workstation. For example, multiple language bars can override your favorite shortcuts.
It is important to adjust your language bar settings.
Let’s see how to do that:
- Click on the language bar
- Switch between languages using the Windows key + Space shortcut
Excel Shortcuts are not working on Mac
What a surprise. Excel assign the keyboard shortcuts for Windows PC keyboards with US language settings. In most cases. That is the point! Take a quick look at the differences!
How to find the proper shortcut key on Mac? We integrated the Mac Excel shortcuts into our definitive guide.
For example, here are the Windows and Mac versions of the ‘Get help on selected control’ shortcut:
- Command + W on a Mac keyboard
- Ctrl + W on a Windows keyboard
As you see, most of the keyboard shortcuts as the same or similar to each other.
In some cases, Mac shortcuts are required more keystrokes.
Toggle absolute, or relative references work by pressing F4 on a Win keyboard. To do that the same command in Mac, use the Command + T shortcut.
Learn more about the shortcut differences on Mac!