Version: Next

Names

Names can be used instead of cell references. This comes in handy if you regularly reference the same cells or cell ranges. Name them in a way you can better remember them and use them within functions. A name is defined by a label and a cell reference.

Settings

Declare Names:

Name1 = S1!A1
Name2 = S1!A1:A2

Use them in the sheet:

=SUM(Name1)
=SUM(Name2)