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

breaks.

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

bar.