When editing a table each cell can be specified using cell address consisting of row and column numbers.
A column with numbers of rows is located at the left border of the table pane, the row with numbers of columns – at the upper border. As it is usual for programs working with spreadsheets, table rows are numbered from top to bottom beginning from number 1, and columns – from left to right by Latin letters A, B, … , Y, Z. If the number of columns exceeds 26, two-letter numbers are used further: AA, AB, … AZ, BA, BB and so on up to ZZ, then come three-letter numbers from AAA to ZZZ and so forth.
The cell address consists of the number of column and the number of row written without spaces, for example, A1, B50 or FQD678.
A rectangular block of cells can be specified using the range of addresses. The range is made up of addresses of top left and bottom right cells of the block separated by a colon. For example, the range C12:AB14 denotes all cells lying in columns from C to AB and in rows 12, 13, 14.
 |  |
