Working with Report Sheet Elements

The 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.

Sheet Cell Addresses

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.

Operations on Working with Sheet Elements

Selecting Element

To select an a cell:

Click the cell.
Go to the cell by using the UP, DOWN, RIGHT/TAB, LEFT/SHIFT+TAB keys.

To select the outermost cell:

The leftmost cell in the current row. Press CTRL+LEFT.
The rightmost cell in the current row. Press CTRL+RIGHT.
The topmost cell in the current column. Press CTRL+UP.
The bottommost cell in the current column. Press CTRL+DOWN.

To select a column:

Click the column header.
Click any cell in the required column and press CTRL+SPACE.

To select several columns:

Click the required column header, hold down the mouse button and drag the cursor to the required column header.
Click the required column header, hold down the SHIFT key and click the required column header.
Select the random cell range contained in the required column range and press CTRL+SPACE.

To select a row:

Click the row header.
Select any cell of the required row and press SHIFT+SPACE.

To select several rows:

Click the required row header, hold down the mouse button and drag the cursor to the required row header.
Click the required row header, hold down the SHIFT key and click the required row header.
Select the random cell range contained in the required row range and press SHIFT+SPACE.

To select a cell range:

Click the required cell at the beginning of the range, hold down the mouse button and drag the cursor to the required cell and the end of the range:
Select the required cell at the beginning of the range, hold down the SHIFT key and click the required cell at the end of the range.
Select the required cell at the beginning of the range, hold down the SHIFT key and go to the required cell at the end of the range using the UP, DOWN, LEFT, RIGHT keys.

To select a range from the current cell to the outermost cell:

To the leftmost cell in the current row. Press CTRL+SHIFT+LEFT.
To the rightmost cell in the current row. Press CTRL+SHIFT+RIGHT.
To the topmost cell in the current column. Press CTRL+SHIFT+UP.
To the bottommost cell in the current column. Press CTRL+SHIFT+DOWN.

To select all cells on a report sheet, press CTRL+A.

A compound range is a range consisting of several uncrossed ranges and/or single cells.

To get a compound range:

Select the required cell range or a single cell.
Hold down the CTRL key and select other required ranges or single cells.

After executing the specified operations a compound range is selected.

To select the entire data sheet:

Click the top left corner of the table at the intersection of row and column headers.
Press CTRL+SHIFT+SPACE.

After executing one of the operations the entire data sheet is selected.

NOTE. To navigate by cells of the selected non-compound range, use the ENTER key. In this case the contour of the selected range is kept.