How Do You Refer To A Range Name In Excel?
A range name is a name that is given to a group of cells within Microsoft Excel 2007. Once you have created a range name you can then reference the range name instead of the cell reference inside of a formula. Follow the steps below to find out how you can use a range name inside of an Excel formula. Start Microsoft Excel 2007 and open an existing workbook that contains range names that you would like to use in a formula. Click on the cell where you would like to enter a formula using one of the range names you have already identified. Begin typing the formula you want to use inside of the cell until you come to the part of the formula that requires you to reference a group of cells that you have created a range name for. Choose the “Formulas” tab to display the “Formulas” ribbon. Click the “Use in Formula” drop-down list button in the “Defined Names” category. You will see the range names that you have defined in your current Excel workbook. Select the range name that you would like t
