A question we’re often asked is: What is the keyboard shortcut for Merge and Center?
Merge and Center isn’t a tool that tends to be used very often, but creating a complex layout often means we need to merge and center multiple times. You would expect that Excel would offer a convenient keyboard shortcut to make this quick and easy, but, at least by default, it doesn’t!
Don’t despair though, there are a few ways that Merge & Center can be accessed more easily, and you can even create keyboard shortcuts of your own without needing any external tools.
Accessing Merge & Center using the keyboard
I just said that there isn’t a keyboard shortcut for Merge & Center, but that isn’t completely true. It is possible to access the command using Excel’s Key Tips feature.
Key Tips is covered in more depth in our Essential Skills course.
To do this:
- Hold down the key on the keyboard. After a short delay, letters and numbers appear on the Ribbon.
You can release the key once the key tips have appeared.
- Press the key to select the Home tab.
The letters change, offering all of the options on the Home tab. Notice M next to Merge & Center.
- Press the key.
The Merge & Center menu opens, offering key tips for each item.
- Press the key to choose Merge & Center.The Merge & Center command is executed.
This works, but it’s very long-winded and certainly isn’t going to speed up your work. Fortunately, there are quicker ways to do this.
Adding Merge & Center to the Quick Access Toolbar
The Quick Access Toolbar offers an easy way to get quick access to your favorite commands with a single click, but it also makes them easily accessible via the keyboard.
The Quick Access Toolbar is also covered in more depth in our Essential Skills course.
Too add Merge & Center to your Quick Access Toolbar, simply right-click it on the Ribbon and click Add to Quick Access Toolbar from the shortcut menu.
An icon appears on your Quick Access Toolbar at the top of the screen, making it easy to access this command with a single click, no matter which tab is selected.
This also makes it much easier to access Merge & Center with your keyboard. If you hold down the <Alt> key (as shown above), you’ll see that numbers appear over the Quick Access Toolbar.
In the screenshot above, you can see that that number 4 is appearing over the Merge & Center icon on the Quick Access Toolbar. There’s no need to hold down the <Alt> key first; you can now execute the Merge & Center command by simply pressing <Alt>+<4> on the keyboard!
This doesn’t just work for Merge & Center. You could do this with absolutely any Excel command, allowing you to create keyboard shortcuts for any command that you need.
Adding the command to your Quick Access Toolbar is definitely the best way to make something keyboard-accessible in the latest versions of Excel, but it wasn’t possible to do this in older versions. In previous versions, the only way to create new keyboard shortcuts was to record a macro and assign it to a shortcut key combination.
You can see this technique used in our Expert Skills course, but it’s not the best solution if you are using a modern version of Excel. Using Macros means you will need to use a macro-enabled workbook, which is a potential problem as macro-enabled workbooks can contain macro viruses.
If this doesn't work for you
If keyboard shortcuts don’t work for you, it’s almost certainly because another program on your computer has already ‘claimed’ them for its own use. If another program is already using the <Alt>+<4> keyboard shortcut, for example, it may override the one you have created in Excel.
If you find that your keyboard shortcuts aren’t working, you should try closing any other programs that are running and then try again.
These are the only up-to-date Excel books currently published and includes the new Dynamic Arrays features.
They are also the only books that will teach you absolutely every Excel skill including Power Pivot, OLAP and DAX.