Microsoft Office Tutorials and References

In Depth Information

**Getting the Mini Toolbar Back**

Figure 3.33.

Figure 3.33.
In legacy versions of Excel, the formula bar could obscure

In legacy versions of Excel, the formula bar could obscure

cells on a worksheet.

cells on a worksheet.

Excel 2013 includes a formula bar that prevents the formula from obscuring

the spreadsheet. For example, in
Figure 3.34
,
cell F1 contains a formula that

is longer than the formula bar. Notice the down-arrow icon at the right end

of the formula bar. This icon expands the formula bar.

Figure 3.34.

Figure 3.34.
Initially, Excel shows only the first row of the formula.

Initially, Excel shows only the first row of the formula.

Press Ctrl+Shift+U or click the down arrow icon at the right side of the for-

mula bar to expand the formula bar. The formula bar expands, but the entire

worksheet moves down to accommodate the larger formula bar.

Note

Excel MVP Bob Umlas keeps suggesting the formula bar should change

color when you are not seeing the entire formula. That is a great sug-

gestion that perhaps the Excel team will one day add to Excel.

The formula in this example is too long for the default larger formula bar.

You have to hover your mouse near the bottom of the formula bar until you

see the up/down white arrow cursor. Click and drag down until you can see

the entire formula (see
Figure 3.35
).