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?