Microsoft Office Tutorials and References
In Depth Information
Chapter 2: Basic Facts about Formulas
To insert a name into a formula, position your cursor in the formula where you want the name
entered and use one of these two methods:
h Press F3 to display the Paste Name dialog box. Select the name and click OK.
h Take advantage of the Formula AutoComplete feature. When you type a letter while
constructing a formula, Excel displays a list of matching options. These options include
functions and names. Use the down-arrow key (
) to select the name and then press Tab to
insert the name in your 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-1 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.
Figure 2-1: This formula contains spaces and line breaks.
A formula can consist of up to about 8,000 characters. In the unlikely event that you need to
create a formula that exceeds this limit, you must break the formula up into multiple formulas. You
also can opt to create a custom function by using Visual Basic for Applications (VBA).
Part VI focuses on creating custom functions.