Adding a New Sheet and Working with It

The following operations are available on working with sheets:

Add a sheet.
Delete sheet.

To add a sheet, click the button next to sheet tabs. The sheet named Sheet N, where N is a sequence number of added sheet, will be added.

To delete sheet, click the button at the right on the sheet tab. The sheet will be deleted. At least one sheet must be present in data entry form. The single sheet cannot be deleted.

To work with a cell, select it.

The available operations with cells include:

Add or delete cells.
Cell format.
Edit cell contents.
Setting up cell editor. It is autofitted by default depending on data type.

Adding or Deleting Cells

To insert cell/column/row, select one of the options in the Insert Cells item drop-down menu in the cell's context menu:

Shift cells down.
Shift cells right.
Shift row below.
Shift row above.
Insert column left.
Insert column right.

To delete cell/column/row, select one of the options in the Delete Cells item drop-down menu in the cell's context menu:

Shift cells up.
Shift cells left.
Delete rows.
Delete columns.

Cell Format

To open the Format Cells dialog box, select one or several cells:

Click the Set Formatting button on the Format ribbon tab.

The specified formatting will be applied to the area selected in the drop-down list in the Current Section group on the Format ribbon tab.

The dialog box includes the following tabs:

Editing Cell Contents

To edit cell contents:

Select a cell in the report sheet and enter required data.
Double-click in the selected cell area.
Select a cell and press F2, after this enter the data.

The following operations can be performed with selected cells:

To work with a column, select it by clicking the header.

The available operations with columns include:

Changing column width.
Adding or deleting column.
Hiding or showing column.

Changing Column Width

To change column width:

Use mouse. Move the mouse cursor to column border in the header area and drag the border to the required distance holding left mouse button. When the mouse pointer appears as a two-headed arrow, you can click and drag an item.
Select the Column Width context menu item. A dialog box with the same name opens after executing the command:

Enter value in the dialog box that opens.

Adding or Deleting Column

To add or delete a column, select the following items in the command header context menu:

Insert Column Left.
Insert Column Right.
Delete Column.

NOTE. To add or delete column in table area, use the Create Record/Delete Record buttons.

Hiding or Showing Column

If it is required to hide or show hidden column, select the following header context menu item:

Hide.
Show. The item becomes active if the sheet contains any hidden columns.

To work with rows, select them by clicking the header.

The available operations with rows include:

Change row height.

Add or delete cell.
Hide or show row.

Changing Row Height

To change row height:

Use mouse. Move the mouse cursor to row border in the header area and drag the border to the required distance holding left mouse button. When the mouse pointer appears as a two-headed arrow, you can click and drag an item.
Select the Row Height context menu item. A dialog box with the same name opens after executing the command:

Enter value in the dialog box that opens.

Adding or Deleting Row

To add or delete a row, select the following items in the command header context menu:

Insert Row At the Top.
Insert Row On the Bottom.
Delete Row.

NOTE. To add or delete row in table area, use the Create Record/Delete Record buttons.

Hiding or Showing Row

If it is required to hide or show hidden row, select the following header context menu item:

Hide.
Show. The item becomes active if the sheet contains any hidden rows.