If you’re working with a large spreadsheet, using names can save you a lot of time.
But it can also get very confusing.
What did you call that range? Which cells does this name refer to? It’s easy to forget.
The Name Manager is exactly what it sounds like: a central place for managing the named cells and ranges in your spreadsheet.
Let’s take a look at the Name Manager for the example spreadsheet.
Click to the Formula tab, then click Name Manager:
You’ll see a simple pop-up window that has, in our case, two names listed.
If you have more than a handful of names, you can find them all right here. And that’s extremely convenient.
Let’s select the first name, “Sales,” and click Edit.
This brings up a small window that lets you change the name and referent cells of any named range.
For example, we could rename our range to “SalesTotal”.
And if we added more sales totals, we could change the Refers to field to include them by editing the range.
You can also save yourself a click by editing the range directly from the Name Manager main window:
The Name Manager also lets you create new ranges and delete ones you don’t need anymore.