Microsoft Office Tutorials and References
In Depth Information
Tip 26: Resizing the Formula Bar
The Excel 2013 Formula bar displays a small arrow on the right; click the arrow, and the Formula bar
expands. You can also drag the bottom border of the Formula bar to change its height. Also useful is
a shortcut key combination: Ctrl+Shift+U. Pressing this key combination toggles the height of the
Formula bar to show either one row or the previous size. If the expanded Formula bar isn’t tall
enough to display all of the text in the active cell, a scrollbar displays to the right of the Formula bar.
Figure 26-2 shows an example of the resized Formula bar. As you can see, increasing the height of
the Formula bar doesn’t obscure the information in the worksheet. Instead, the worksheet
information is displayed below the Formula bar. You can make the formula bar almost as tall as the
workbook window (one worksheet row always remains visible).
Figure 26-2: Changing the height of the formula bar makes it much easier to edit lengthy formulas and text,
and you can still view all cells in your worksheet.
You can also resize the width of the Formula bar. Click and drag the three dots to the right of the
Name box. When the Name box gets wider, the Formula bar gets narrower.