Selecting Cells

Table cells and table sheet cells are selected in the same way. Table heading and sidehead are identical to headers of columns and rows of regular report table sheet.

NOTE. Working with selected range is available only in the edit mode of the report.
When the Deny Selection checkbox is selected in the Protection group of elements of the Other tab, the cell becomes unselectable on opening the report in the view mode. The context menu for this cell will not be called.

To select an arbitrary cell:

Click the cell
Go to the cell by using the UP, DOWN, RIGHT, LEFT keys.

To select the top left table cell, press CTRL+HOME.

To select the leftmost cell of the current row, press:

HOME.
CTRL+LEFT.

To select the rightmost cell of the current row, press CTRL+RIGHT.

To select the topmost cell of the current column, press CTRL+PAGE UP.

To select the bottommost cell of the current column, press CTRL+PAGE DOWN.

To select the rightmost non-empty cell, press END.

To select the entire row:

Click the row header with the main button of the mouse.
Select any cell of the required row and press SHIFT+SPACE.

After this the row is selected:

To select the entire column:

Click the column header with the main mouse button.
Select any cell of the required column and press CTRL+SPACE.

After this the column is selected:

To select several rows, execute one of the operations:

Click the required row header with the main button of the mouse, hold down the button and drag the cursor to the required row header.
Click the required row header with the main button of the mouse, hold down the SHIFT key and click the required row header with the main button of the mouse, after which release the SHIFT key.

After that several rows are selected:

To select several columns, execute one of the operations:

Click the required column header with the main button of the mouse, hold down the button and drag the cursor to the required column header.
Click the required column header with the main button of the mouse, hold down the SHIFT key and click the required column header with the main button of the mouse, after which release the SHIFT key.

After that several columns are selected:

To select the range, double-click the required cell with the main button of the mouse and:

Hold down the main button of the mouse and drag the mouse cursor to the opposite corner, then release the mouse button:

Hold down the SHIFT key and click the required cell.
Hold down the SHIFT key and press the UP, DOWN, LEFT, RIGHT keys.

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.

NOTE. This method of selection is relevant only for regular report.

Press CTRL+A or CTRL+SHIFT+SPACE.

NOTE. If the focused cell does not belong to any data area, all cells in the spreadsheet are selected. The data range area is selected in the beginning if focused cell is within the data range. Press the hotkey combination again to select all cells in the sheet.

After this the entire data sheet is selected:

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

Fill Marker

Fill marker is a square marker at the corner of the selected range or single cell contour.

Depending on the chosen cell selection method, fill marker may be positioned differently:

Available Operations with Selected Ranges

NOTE. On moving the selected range to any merged cell a warning appears. Moving is cancelled.

NOTE. On copying the selected range to any merged cell a warning appears. Copying is cancelled.

Features of Working with Selected Ranges

On executing the specified actions the following is copied from the selected range along with data: