How to use Name Manager

Uploaded time: 2021-08-28 Difficulty: Primary

How to use Name Manager

How to use Name Manager

Graphic skills

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.

GIF.gif


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

GIF_1.gif


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.

GIF_2.gif


Did you get it?