Operations with Cells

Various operations with cells are available when working with a regular report sheet.

Adding Cells

To add a cell to a range, select the

Insert >Move Cells Down item or the

Insert > Move Cells Right item in the cell's context menu.

After executing this operation a cell is added to the sheet. In this case cells located below or to the right are moved down or to the right. If a cell range is selected, the same number of cells is added as it is in the selected range.

Selecting Cells

To select an arbitrary 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 cell range:

Click the required cell at the beginning of the range, hold down the mouse button and drag the mouse button to 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 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.

Deleting Cells

To delete the selected cells from the range, select the

Delete > Move Cells Up item or the

Delete > Move Cells Left item in the cell's context menu.

After executing one of the operations, the cell range is deleted. In this case the cells located below or to the right are moved up or to the left.

Merging and Unmerging Cells

Selected adjacent cells can be merged into one cell. The merged cell acquires the address of the cell in the top left corner of the merged range.

The merged cell contains data from the first cell in the selected range. After the merge, data of other cells does not disappear, it is only hidden. Thus, after unmerging, data of all cells in the range is restored.