Microsoft Office Tutorials and References
In Depth Information
Figure 2-1 shows Formula AutoComplete in use. In this case, GrandTotal is a defined range name. This name
appears in the drop-down list, along with worksheet function names.
Figure 2-1: Using Formula AutoComplete to enter a range name into a formula.
Spaces and line breaks
Normally, you enter a formula without using any spaces. However, you can use spaces (and even line breaks)
within your formulas. Doing so has no effect on the formula's result, but can make the formula easier to read. To
enter a line break in a formula, press Alt+Enter. Figure 2-2 shows a formula that contains spaces and line
To make the Formula bar display more than one line, drag the border below the Formula
bar downward. Or click the downward-pointing icon at the extreme right of the Formula