Solve software problem quickly Share experience to help others Improve the ability of solving problem
How to Refer to a Range Name in Excel

11/15/2011 07:22 by KevinHan

First answer posted by TommyB at 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
1 Answers
  • TommyB
    1. Start Microsoft Excel 2007 and open an existing workbook that contains range names that you would like to use in a formula.

    2. Click on the cell where you would like to enter a formula using one of the range names you have already identified.

    3. 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.

    4. 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.

    5. Select the range name that you would like to use in the formula you are typing. The range name will be inserted into the formula you are typing.

    6. Continue typing the rest of your formula. Press the "Enter" key when you are finished to enter the formula into Excel. The result of your calculation will now be displayed.

  • Was this answer helpful? 00 · 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:How to Do Payroll in Excel

A: Open a new workbook in Microsoft Excel. Click Office > New. Type "Payroll" in the "Search Microsoft Office Online for a Template" text fie...(more)

Q:How to Create a Form Using Microsoft 2007 Excel

A: Click the drop-down arrow at the right end of the "Quick Access Toolbar," which is to the right of the "Microsoft Office" button at the top ...(more)

Q:How to Convert Microsoft Excel 2007 to Excel 1997

A: Launch Microsoft Excel 2007. Click "File," "Open" and select the file you need to down-convert from the browse window. Click "OK" and the ...(more)

Q:How to Program Excel Interfaces

A: Start Microsoft Excel, then open any worksheet or workbook. Click on the "Developer" tab. If you don't have this tab, click on the "Micros...(more)

Q:In Microsoft Word, How Do I Display the WordArt Gallery?

A:Insert Option Click the "Insert" tab on the main ribbon. Insert is located on the left side of the ribbon, next to the "Home" tab. When "Ins...(more)

0 people are following

Ask a question now
Write a title for your question

Microsoft Excel Viewer 2003

open, view, and print Excel workbooks, even if you have example excel formula.
Latest version:1.0
OS:Windows 2003,Windows XP,Windows 2000
Total downloads:445,228
Rank:1 in Spreadsheets
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Added Successfully!


Are you sure to delete your answer?



Are you sure to choose it as the best answer?



Voted Successfully!


You can't vote for yourself


You can't choose your own answer