Brothersoft.comWindows|Mac|Mobile|Games

|Message

Solve software problem quickly Share experience to help others Improve the ability of solving problem
How to Manage Range Names in Excel

11/15/2011 07:22 by SaideeDay

First answer posted by BrianHimlie at 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
1 Answers
  • BrianHimlie
    1. Start Microsoft Excel and open an existing spreadsheet that contains range names that you would like to manage, filter, edit, delete or create additional range names.

    2. Choose the "Formulas" tab to display the "Formulas" ribbon. Click the "Name Manager" button to open the "Name Manager" dialog box.

    3. Click the "New" button in the "Name Manager" dialog box to open the "New Name" dialog box. In this dialog box, you can provide a name, scope, comment, and cell reference for the new range name that you create.

    4. Select a range name you would like to edit from the "Name Manager" list and click "Edit" to open the "Edit Name" dialog box. Here you can rename the range, change the scope, edit the comment or change the cell reference.

    5. Identify a range name you would like to delete from the "Name Manager" list and click the "Delete" button. A dialog box will come up and ask you to confirm that you want to delete the name range. Click the "OK" button to delete the name range from the "Name Manager" dialog box.

    6. Highlight and click the "Filter" button on the top right of the "Name Manager" dialog box to display the filter options available for the name manager. You can filter to find range names that are located in the current workbook, that are located in the current worksheet, that have errors, that don't have any errors, defined names and table names.

    7. Complete the process by clicking on the "Close" button. This will close the "Name Manager" dialog box after you have finished managing the range names.

  • Was this answer helpful? 00 · 11/15/2011 07:22
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:How to Send a Microsoft Excel 2007 Worksheet As an Email

A:Sending an Excel File Via E-mail Power on your computer and open your e-mail server or log in to your online e-mail. Click the button "New...(more)

Q:How to Hide a Column in Microsoft Excel 2007

A: Click on the column heading located along the top of the worksheet to select the column you want to hide. Go to the "Cells" group on the "...(more)

Q:How to Format Date Strings

A: Open Excel and then open the workbook to which you would like to apply format date strings. Highlight the range of cells you want to forma...(more)

Q:How to Sort by Date

A: Write down an organized list of the information you want to put into Excel and the corresponding dates. Open Excel. Type in the informatio...(more)

Q:How to Insert Scatter Plot Excel Into a Word Document

A: Open Word. To insert a scatter plot Excel chart into an existing Word document, click the "File" tab, select "Open," browse to the document ...(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
License:Freeware
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?

NoYes

×

Are you sure to choose it as the best answer?

NoYes

×

Voted Successfully!

×

You can't vote for yourself

×

You can't choose your own answer

×