The A1 reference display style is used in MyOffice Spreadsheet by default.
In A1 style, the cell address consists of the letter name of the column and the number name of the row. For example, A1, C12, G37, ND185, and so forth.
When you create the file, the sheets contain:
–300 rows with names from 1 to 300.
–26 columns with names from A to Z.
When you add columns to a table, the new elements are named using two letters: AA, AB, AC...AZ, then BA, BB, BC...BZ, and so forth. If two-letter combinations run out, three-letter names are given to the columns.
When you add rows to the table, the new elements continue the numbering.
Relative reference |
A1 |
Absolute reference |
$A$1: The column and row remain unchanged when copied. |
Mixed references |
$A1: The column remains unchanged when copied. A$1: The row remains unchanged when copied. |