As a bonus, Ill reveal some fast ones using the Menu Key as well.

When you type one, you go to the ribbon tab its centered over just as if you clicked on that tab with your mouse.

In the case of the Quick Access Toolbar, the effect is as if you clicked on the QAT icon).

Since the Sort options are available on the Data tab, Ill hit the A key after I hit (and release) the Alt key.

That takes me to the Data tab (see below), where I see three sort options and their corresponding keyboard accelerators.

The graphic below is of the far right side of the Home tab).

When I hit Alt-H, the S shows up on the far right of the Home tab for the Sort option.

When I then type S, the Sort options open up underneath (as shown).

Below, after Ive hit the Alt key, you can see that the 1, 2 and 3 key tips are hovering over the Sort options Ive placed on the QAT.

If I placed them on the right side of the QAT, the key tips would be different (08, 07 and 06, for example).

You may want to put something else there to take advantage of the fast Alt-123 shortcuts something which you use often and which has no good shortcuts.

The Sort option is at the bottom, and if I hover or click on it, I get the sub-menu showing to the right.

The Alt and Menu Key techniques above can be applied to a multitude of other Excel tasks.

Once you understand the mechanics, youre on your way to becoming a shortcut guru.

Shortcut For Format Painter Excel Mac