The A1 reference style is used in MySpreadsheet by default.
In the A1 reference style, the cell address consists of a column letter name and a numeric row name. For example, A1, C12, G37, ND185 and so forth.
When creating a sheet, the workspace contains:
•20 rows numbered from 1 to 20.
•10 columns named from A to J.
When you expand the workspace, new columns continue single-letter naming followed by two-letter naming: AA, AB, AC, then BA, BB, BC and so forth. If the two-letter combinations end, the columns will be given three-letter names.
When you add rows to a table, the new items continue to be numbered.
Relative reference |
А1 |
|---|---|
Absolute references |
$A$1 (the column and row are not changed during copying) |
Mixed references |
$A1 (the column is not changed during copying) A$1 (the row is not changed during copying) |