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 ).
Search JabSto ::




Custom Search