Microsoft Office Tutorials and References
In Depth Information
The formula bar appears below the Ribbon (Figure 1–12a). As you type, Excel displays
the entry in the formula bar . You can make the formula bar larger by dragging the sizing
handle (Figure 1–7) on the formula bar or clicking the expand button to the right of the
formula bar. Excel also displays the active cell reference in the Name box on the left side
of the formula bar.
The Mini toolbar , which appears automatically based on tasks you perform (such as
selecting text), contains commands related to changing the appearance of text in a work-
sheet. All commands on the Mini toolbar also exist on the Ribbon. The purpose of the Mini
toolbar is to minimize mouse movement. For example, if you want to format text using a
command that currently is not displayed on the active tab, you can use the command on the
Mini toolbar — instead of switching to a different tab to use the command.
When the Mini toolbar appears, it initially is transparent (Figure 1–12a). If you do not use
the transparent Mini toolbar, it disappears from the screen. To use the Mini toolbar, move the
mouse pointer into the toolbar, which causes the Mini toolbar to change from a transparent to
bright appearance (Figure 1–12b).
Mini toolbar are
also on Ribbon
(a) Transparent Mini Toolbar
(b) Bright Mini Toolbar
A shortcut menu , which appears when you right-click
an object, is a list of frequently used commands that relate
to the right-clicked object. If you right-click an item in the
document window such as a cell, Excel displays both the
Mini toolbar and a shortcut menu (Figure 1–13).