You would expect that Excel would offer a convenient keyboard shortcut to make this quick and easy, but, at least by default, it doesnt Dont 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.

Key Tips is covered in more depth in our Essential Skills course.

After a short delay, letters and numbers appear on the Ribbon.

The letters change, offering all of the options on the Home tab.

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.

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.

This also makes it much easier to access Merge Center with your keyboard.

If you hold down the key (as shown above), youll see that numbers appear over the Quick Access Toolbar.

Theres no need to hold down the key first; you can now execute the Merge Center command by simply pressing on the keyboard This doesnt 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.

In previous versions, the only way to create new keyboard shortcuts was to record a macro and assign it to a shortcut key combination.

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 another program is already using the keyboard shortcut, for example, it may override the one you have created in Excel.

If you find that your keyboard shortcuts arent working, you should try closing any other programs that are running and then try again.

This article explains why this e-book format is optimal for learning and includes screen grabs from the Kindle PC reader application.

Commands added to your Quick Access Toolbar automatically create AltNumber shortcut keys.

If you think that might be the problem, try closing any programs that are running in the background to see if the shortcut keys start working after they have been closed.

I was so tired of one boring excel task but your post help me saved a lot of time.

Excel Shortcut For Merge And Center Mac