115k views
2 votes
edit the currentsalaries named range so it refers to cells b2:b6 on the salaries worksheet. close the name manager when you are finished

User Glenis
by
8.2k points

2 Answers

5 votes

The changes will be applied, and you can close the Name Manager.

Go to the Formulas tab.

In the Defined Names group, click on the Name Manager button.

In the Name Manager dialog box, find and select "currentsalaries" in the list of named ranges.

Click on the "Refers to" box to edit the reference.

Change the reference to

Click the check mark to the left to accept the changes.

Click OK to close the Name Manager.

After completing these steps, the "currentsalaries" named range will now refer to cells B2:B6 on the "Salaries" worksheet. The changes will be applied, and you can close the Name Manager.

User Theduck
by
8.2k points
3 votes

We can edit the current salaries named range so it refers to cells b2:b6 on the salaries worksheet as follows:

  1. Formulas tab - defined names group
  2. Go to the Name Manager button
  3. Click current salaries
  4. Click the check mark to the left to accept changes
  5. Ok

How to edit the named range

To edit the named range, some measures that would be taken would be to go to the formulas tab, under the defined names group, access the Name manager button, click on current salaries, and the check mark to accept all the changes made.

Finally, press ok and the changes are effected. Whent this is done, the named range would have been edited.

User Lapk
by
7.8k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.