Now that you have seen the power that using named ranges can add to your worksheets, here are ways you can maintain your list of names.
Follow along with the Names_Multiple_Result file if you like.
If you have a lot of names in a workbook, you can paste your list of names to a separate sheet. First, insert a blank sheet. Then go to the menu at the top and select Insert, then Names, then Paste. Up comes the dialog box.
You recall from before when creating formulas that you could highlight a name and then click OK to paste the name into a formula.
In this case, we want to review our list of names, so click Paste List.
What you get then is a list of the names and the reference. You can use this list to see if there are any outdated names to delete or names with a broken reference (will show REF in the reference).
Suppose you wanted to delete a name. Go the menus at the top and select Insert, then Name, then Define. This gets you to the Define Name dialog box.
There you could highlight a name and then click Delete.
You would also follow the same steps to rename a name, except that instead of clicking the Delete button, you would move your cursor to the top text box (under Names in workbook:), change the name, then click OK.
Finally, you could also change the reference in the Refers to text box at the bottom.
Notice when you put your cursor in the Refers to box, it will take you to the reference area. You can always manually change the reference in the text box, but in some cases you can change it by clicking onto the new reference area that uyou want on the worksheet.
Errors in names can happen when:
you delete a sheet, column or row where a name was contained
you additional data to the end of a range and forget to extend the named range
Use these tips to keep your names in shape and your new, more powerful workbooks in top form.