- Understanding Formulas
- Creating a Simple Formula
- Creating a Formula Using Formula AutoComplete
- Editing a Formula
- Understanding Cell Referencing
- Using Absolute Cell References
- Using Mixed Cell References
- Using 3-D Cell References
- Naming Cells and Ranges
- Entering Named Cells and Ranges
- Managing Names
- Simplifying a Formula with Ranges
- Displaying Calculations with the Status Bar
- Calculating Totals with AutoSum
- Calculating Totals with Quick Analysis
- Performing One Time Calculations
- Converting Formulas and Values
- Correcting Calculation Errors
- Correcting Formulas
- Auditing a Worksheet
- Locating Circular References
- Performing Calculations Using Functions
- Creating Functions
- Creating Functions Using the Library
- Calculating Multiple Results
- Using Nested Functions
- Using Constants and Functions in Names
Entering Named Cells and Ranges
After you define a named cell or range, you can enter a name by typing, using the Name box, using Formula AutoComplete, or selecting from the Use in Formula command. As you begin to type a name in a formula, Formula AutoComplete displays valid matches in a drop-down list, which you can select and insert into a formula. You can also select a name from a list of available from the Use in Formula command. If you have already entered a cell or range address in a formula or function, you can apply a name to the address instead of re-creating it.
Enter a Named Cell or Range Using the Name Box
- Click the Name box list arrow on the formula bar.
- Click the name of the cell or range you want to use.
The range name appears in the Name box, and all cells included in the range are highlighted on the worksheet.
Enter a Named Cell or Range Using Formula AutoComplete
- Type = (equal sign) to start a formula, and then type the first letter of the name.
- To insert a name, type the first letter of the name to display it in the Formula AutoComplete drop-down list.
- Scroll down the list, if necessary, to select the name you want, and then press Tab or double-click the name to insert it.
Enter a Named Cell or Range from the Use in Formula Command
- Type = (equal sign) to start a formula.
- Click the Formulas tab.
- When you want to insert a name, click the Use in Formula button.
Use one of the following menu options:
- Click the name you want to use.
- Click Paste Names, select a name, and then click OK.
Apply a Name to a Cell or Range Address
- Select the cells in which you want to apply a name.
- Click the Formulas tab.
- Click the Define Name button arrow, and then click Apply Names.
- Click the name you want to apply.
- Click OK.