How to use Name Manager

Uploaded time: August 28, 2021 Difficulty Beginner

A free Office suite fully compatible with Microsoft Office

Free Download

How to use Name Manager

How to use Name Manager

We can use the Name Manager to set a fixed name for the cell area, which can be more simple and intuitive in function calculations and it can be also used in Microsoft Office Excel and Openoffice.

Take this spreadsheet as an example. We can select the cell range from A2 to A10 and click the Name Manager in the Formulas tab. Its shortcut key is Ctrl+F3.

In the pop-up dialog box, click New, enter a custom name, select the scope of use, and finally click OK.

In this way, we will give the cell area a name, and later when we edit complex formulas, you can directly enter the name for reference.


To facilitate the demonstration, we choose theSUM functionin sum this area. Enter =SUM (fruit), then we can get the calculation result.


After understanding the usage of the function, we can enter the Name Manager interface again, where we can view all the stored names and filter them on the far right. If you want to modify the name, click Edit after choosing it.


Did you get it?