WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


How to use Name Manager

Uploaded time: August 28, 2021 Difficulty Beginner

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?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.