Microsoft Office Tutorials and References
In Depth Information
Selecting Options from a Gallery
When you choose a ribbon tab, the KeyTips on the Quick Access Toolbar dis-
appear, so Microsoft is free to use the letters A through Z and the numbers 0
through 9.
On very busy ribbon tabs, some commands require two keystrokes: for ex-
ample, A+C for Align Center in the Alignments group of the Home tab, as shown
in Figure 6.3 . Note that after you press Alt to display the accelerators in
the tooltips, you do not have to continue holding down the Alt key.
Figure 6.3.
Figure 6.3. After pressing the letter to switch to the ribbon, type the letter
After pressing the letter to switch to the ribbon, type the letter
or letters to invoke a particular command.
or letters to invoke a particular command.
Some shortcut keys seem to make sense: AT for Align Top, AM for Align
Middle, AB for Align Bottom, AL for Align Left, W for Wrap Text, and M for
Merge. Other shortcut keys seem to be assigned at random. Some take a little
pondering: FA for the dialog launcher in Figure 6.3 makes sense in that it
opens the legacy Format dialog and moves to the Alignment tab. Others have
a historical precedent. In Excel 2003, F was used for F ile, so O was used
for F o rmat. Similarly, in the Home tab, O now opens the Format drop-down.
However, because Microsoft no longer underlines the accelerator key in the
menu name, O will never make sense to someone new to Excel. There might be
some arcane, logical reason why 5 and 6 are used for increase and decrease
indent, but it is unknown by most people.
Selecting Options from a Gallery
Selecting Options from a Gallery
Figure 6.4 shows the results of pressing Alt+H+J, which is the equivalent of
selecting Home, Cell Styles. This opens the gallery of cell styles. As you
can see in Figure 6.4 , you can invoke the New Cell Style and Merge Styles
commands at the bottom of the gallery by pressing N and M, respectively.
However, there are no letters on the table style choices in the gallery.
Search JabSto ::




Custom Search