Names in formulas and functions

When you work with large data sets, you can give names to frequently used cells, cell ranges, constants, and formulas. Names are used in formulas and functions and make them easier to write and understand.

For example, the function =SUM(Sales) is entered and understood more easily than the function =SUM(D2; D20).

Names are divided into two types:

•Defined names: Names manually given by the user to cells, ranges, constants, and formulas.

•Table names: Names of tables created in MySpreadsheet or third-party applications.

In addition, names are varied by their area of application:

•Global: Can be used on any spreadsheet sheet.

•Local: Can be used only on the sheet on which they were set.

The following interface elements are used to work with names:

•Range field: The field is located to the left of the Formula bar. You can expand the range field if necessary. To do this, move the cursor to the right border of the field so that it looks like a bidirectional arrow, and while keeping the left mouse button pressed, move the field boundary to the right.

•Name manager: It opens when you click the  Name manager button on the Sidebar.