Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

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

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

  • yellow-01.jpg Type = (equal sign) to start a formula, and then type the first letter of the name.
  • yellow-02.jpg To insert a name, type the first letter of the name to display it in the Formula AutoComplete drop-down list.
  • yellow-03.jpg 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

  • yellow-01.jpg Type = (equal sign) to start a formula.
  • yellow-02.jpg Click the Formulas tab.
  • yellow-03.jpg When you want to insert a name, click the Use in Formula button.
  • yellow-04.jpg 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

  • yellow-01.jpg Select the cells in which you want to apply a name.
  • yellow-02.jpg Click the Formulas tab.
  • yellow-03.jpg Click the Define Name button arrow, and then click Apply Names.
  • yellow-04.jpg Click the name you want to apply.
  • yellow-05.jpg Click OK.
  • + Share This
  • 🔖 Save To Your Account