How to manage named ranges

you might easily do this by using a feature called the “Name Manager.”

you’re able to find the Name Manager on the Formulas tab of the ribbon.

Just click to open.

you’re able to also initiate the Name Manager using the keyboard shortcut Control + F3.

Once the Name Manager is open, you have several options.

you’re free to create a new name with the New button.

you’re free to also edit an existing named range with the Edit button.

Finally, you’ve got the option to delete named ranges using the Delete button.

The Name Manager works well as a way to review all of the named ranges in a workbook.

It also has a handy Filter button that allows you to see just the names you’re interested in.

First, select an empty cell on the worksheet.

Next, tap the “Use in Formula” menu, and select Paste Names.

When the Paste Names dialog box appears, nudge the button called “Paste List.”

Excel will generate a full list of all names and references.

This is a static list, so it won’t change as you add or update named ranges.