Microsoft Office Tutorials and References
In Depth Information
Excel’s User Interface
h Split buttons: A split button control combines a one-click button (on the top) with a
drop-down (on the bottom). If you click the button part, the command is executed. If you
click the drop-down part, you choose from a list of related commands. You can identify a
split button because it displays in two colors when you hover the mouse over it. An
example of a split button is the Paste command in the Clipboard group of the Home tab.
Clicking the top part of this control pastes the information from the Clipboard. If you click
the bottom part of the control, you get a list of paste-related commands (see Figure 2-6).
h Check boxes: A check box control turns something on or off. An example is the Gridlines
control in the Show/Hide group of the View tab. When the Gridlines check box is
checked, the sheet displays gridlines. When the control isn’t checked, the sheet gridlines
h Spinners: An example of a spinner control is in the Scale to Fit group of the Page Layout
tab. Click the top part of the spinner to increase the value; click the bottom part of the
spinner to decrease the value.
Figure 2-6: The Paste command is a split button control.
Refer to Chapter 22 for information about customizing Excel’s Ribbon.
Some of the Ribbon groups contain a small icon in the lower-right corner, known as a dialog
launcher. For example, if you examine the Home ➜ Alignment group, you’ll see this icon (refer to
Figure 2-7). Click it, and it displays the Format Cells dialog box, with the Number tab preselected.
This dialog box provides options that aren’t available in the Ribbon.