Microsoft Office Tutorials and References

In Depth Information

**Meet the formula bar**

Excel allows you to expand and contract the formula bar to display or hide long formulas.

The formula bar split handle helps a bit, but for really long formulas the formula bar is

vertically expandable, as shown in Figure 2-16.

When you select a cell containing a long formula, you see only part of the formula in the

formula bar. If there is more of the formula to be seen, Excel displays a set of up and down

arrows at the right end of the formula bar that you can use to scroll through the formula

one line at a time. At the far right end of the formula bar is the Expand Formula Bar button

(down arrow), which when clicked expands the formula bar as shown in Figure 2-16. If you

need to see more, drag the bottom border of the formula bar as far as you need to. (This

particular 100-cell formula is good for illustrating the expanding formula bar, but failure to

use the SUM function in this situation might get you drummed out of the Sensible

Formulas Guild.) The next time you click the Expand Formula Bar arrow, the bar expands to the

last size you specified.

Figure 2-16
The formula bar expands and contracts to show or hide long formulas.

To return the formula bar to its regular size, click the Collapse Formula Bar button. (The

Expand Formula Bar button changes its name when the formula bar is expanded.) Note

that in the bottom screen shot in Figure 2-16, the pointer turns into a double-headed

arrow when you position it over the lower border of the formula bar. You can also drag this

border to expand the formula bar.