• Excel Book Excerpt

Excel Long Formulas in the Formula Bar

This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.

Long Formulas in the Formula Bar

Problem: In legacy versions of Excel a long formula would spill out of the formula bar, covering part of the grid. This is particularly annoying in row 1 because the formula covers the value from the formula.

Strategy: In Excel 2007, you can expand or collapse the formula bar. If you choose to expand the formula bar (with Ctrl+Shift+U), the grid actually shifts downward so that you can see the formula bar and the cell in the grid.

Here the formula bar is collapsed. You see only the first line of the formula.

LE10000147.jpg 

Figure 178 Only one part of the formula appears.

If you press Ctrl+Shift+U or click the down arrow icon at the right edge of the formula bar, Excel will shift the grid down and show more lines of the formula.

LE10000148.jpg 

Figure 179 Excel lowers the grid.

Gotcha: With a particularly long formula, the formula might not fit in the expanded formula bar. Grab the bar at the bottom edge of the formula bar to make the formula bar even taller.

 

<-Previous Topic Next Topic->

For more resources for Microsoft Excel: