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

  • lightyellow_01.jpg Click the Name box list arrow on the formula bar.
  • lightyellow_02.jpg 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

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

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

  • lightyellow_01.jpg Select the cells in which you want to apply a name.
  • lightyellow_02.jpg Click the Formulas tab.
  • lightyellow_03.jpg Click the Define Name button arrow, and then click Apply Names.
  • lightyellow_04.jpg Click the name you want to apply.
  • lightyellow_05.jpg Click OK.
  • + Share This
  • 🔖 Save To Your Account