How to easily edit name range and the scope in Excel?
Usually, a workbook may include multiple name ranges in it, and in sometimes you have updated the data in the workbook as below screenshot shown, and now you need to reedit the name ranges and change the range scopes, too, how can you quickly solve it in Excel?
Edit name range with Name Manager
Edit name range with Kutools for Excel
Edit name range with Name Manager
In Excel, you can go to the Name Manager dialog to reedit and change the range scope.
1. Click Formulas > Name Manager. See screenshot:
2. Then in the Name Manager box, select the name range you want to edit from the list, and click Edit button. See screenshot:
3. Then in the Edit Name dialog, you can reedit the Name, and reselect the range scope in the Refers to section. See screenshot:
4. Click OK. And this name range has been reedit successfully. And if you want to other name ranges, just repeat above steps to edit them one by one.
And after finishing editing name ranges, please close the Name Manager dialog.
Edit name range with Kutools for Excel
If you have Kutools for Excel – a handy Excel add-in, you can easily edit name range and change range scope.
| Kutools for Excel, with more than 300 handy functions, makes your jobs more easier. |
After free installing Kutools for Excel, please do as below:
1. Click Kutools > Navigation, and click Name Manager 
to go to the Name Manager pane. See screenshot:
2. Then you can see all the name ranges in the right section, and you can click at the name range to toggle to the name range, and then go to the below section to edit the name and scrope as you need, then click 
to save the change. See screenshot:
With Kutools for Excel’s Navigation, and you can list all name ranges, workbooks, sheets, and find and replace value across workbooks and so on. Click here to know more.
Edit Name Range
Relative Articles:
- How to find named range reference in Excel?
- How to quickly select named range cells in Excel?
- How to search a value in multiple sheets or workbooks in Excel?
Best Office Productivity Tools
Easy to Uninstall Completely | Supports Office/Excel 2007-2021 and 365 | Available in 44 Languages
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need Is Just A Click Away...
Supercharge Your Spreadsheets: Experience Efficiency Like Never Before with Kutools for Excel
(Full-Featured 30-Day Free Trial)
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
