Select cellsThe regular report sheet contains the following elements: rows, columns and their intercrossing - cells. A lot of rows and columns present data as tables. A value in numeric cell of the table can be specified directly, you can take it from data source, or it can be calculated using a formula. Various objects can be added to the sheet.
Addresses of sheet cells can be absolute or relative:
Absolute addresses assume that the cell address is specified by indicating column name and row number, such as F1, B50, FQD678, and so on.
Relative addresses are used in formulas, when it is necessary to specify a cell relative to the current one, for which the formula is calculated. For example, the formula =R[2]C[-2] means a reference to the cell located 2 columns right and 2 rows up from the current one.
The left sheet edge shows a column with row numbers, the top edge of the table shows a row with column indicators.
Sheet rows are numbered from top to bottom with numbers starting with zero. Table columns are named from left to right with Latin letters: A, B, ... Y, Z. If the number of columns is more than 26, two-letter names are used: AA, AB, … AZ, BA, BB, and so on. up to ZZ, then follow three-letter names from AAA to ZZZ, and so on.
A cell address consists of a column letter and a row number written without spaces; for example: A1, B50, or FQD678.
A rectangular cell area can be specified using a range of cell addresses. A range consists of the addresses of the top left and bottom right cells of the block, separated by a colon. For example, the C12:AB14 range includes the cells between the columns C to AB, and rows 12, 13 and 14.
See also: