Menu
In Excel, you can go to the Name Manager dialog to reedit and change the range scope. 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.
Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 More. Less Use the Name Manager dialog box to work with all the defined names and table names in a. MS Excel 2016: Add a Named Range This Excel tutorial explains how to define a named range in Excel 2016 (with screenshots and step-by-step instructions).
See screenshot: 4. 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. Never need to worry about long long formulas in Excel anymore!
Kutools for Excel's Auto Text can add all formulas to a group as auto text, and liberate your brain! 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. With more than 120 handy Excel functions, enhance your working efficiency and save your working time. After 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 you want to edit, and then edit and change its scope in the button of the pane. See screenshot: 3. And after finishing the edit, click to save it. And now when you click at a name range in the pane, the relative cells are selected as screenshot shown: 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. Edit Name Range.
![Excel Excel](https://www.howtogeek.com/wp-content/uploads/2016/02/10_delete_confirmation.png)
Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! 300 New Features for Excel, Make Excel Much Easy and Powerful:. Merge Cell/Rows/Columns without Losing Data. Combine and Consolidate Multiple Sheets and Workbooks. Compare Ranges, Copy Multiple Ranges, Convert Text to Date, Unit and Currency Conversion.
Count by Colors, Paging Subtotals, Advanced Sort and Super Filter,. More Select/Insert/Delete/Text/Format/Link/Comment/Workbooks/Worksheets Tools.
Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel Starter 2010 Use the Name Manager dialog box to work with all the defined names and table names in a workbook. For example, you may want to find names with errors, confirm the value and reference of a name, view or edit descriptive comments, or determine the scope. You can also sort and filter the list of names, and easily add, change, or delete names from one location. To open the Name Manager dialog box, on the Formulas tab, in the Defined Names group, click Name Manager.
The Name Manager dialog box displays the following information about each name in a list box: Column Name Description Name One of the following:. A defined name, which is indicated by a defined name icon. A table name, which is indicated by a table name icon. Note: Names can be up to 255 characters in length. The scope automatically defaults to Workbook. To change the name’s scope, in the Scope drop-down list box, select the name of a worksheet. Optionally, in the Comment box, enter a descriptive comment up to 255 characters.
In the Refers to box, do one of the following:. Click Collapse Dialog (which temporarily shrinks the dialog box), select the cells on the worksheet, and then click Expand Dialog. To enter a constant, type = (equal sign) and then type the constant value. To enter a formula, type = and then type the formula. To finish and return to the worksheet, click OK.
![2016 2016](/uploads/1/2/5/6/125635297/534667089.png)
If you modify a defined name or table name, all uses of that name in the workbook are also changed. On the Formulas tab, in the Defined Names group, click Name Manager. In the Name Manager dialog box, double-click the name you want to edit, or, click the name that you want to change, and then click Edit. In the Edit Name dialog box, in the Name box, type the new name for the reference. In the Refers to box, change the reference, and then click OK.
In the Name Manager dialog box, in the Refers to box, change the cell, formula, or constant represented by the name. On the Formulas tab, in the Defined Names group, click Name Manager. In the Name Manager dialog box, click the name that you want to change.
Select one or more names by doing one of the following:. To select a name, click it. To select more than one name in a contiguous group, click and drag the names, or press SHIFT and click the mouse button for each name in the group.
To select more than one name in a noncontiguous group, press CTRL and click the mouse button for each name in the group. Click Delete. Click OK to confirm the deletion. Use the commands in the Filter drop-down list to quickly display a subset of names.
Selecting each command toggles the filter operation on or off, making it easy to combine or remove different filter operations to get the results you want. You can filter from the following options: Select To Names Scoped To Worksheet Display only those names that are local to a worksheet. Names Scoped To Workbook Display only those names that are global to a workbook. Names With Errors Display only those names with values containing errors (such as #REF, #VALUE, or #NAME). Names Without Errors Display only those names with values that do not contain errors. Defined Names Display only names defined by you or by Excel, such as a print area.
Table Names Display only table names.