Working with Data

A form sheet contains cells, which values can be specified explicitly, get on setting up an attribute or table area from source or calculate by formula.

The following operations are available when working with sheet data:

Data Entry and Editing Cell Contents

To enter or edit data in a cell, select a cell on a report sheet and enter necessary data.

After you have entered data, to exit the cell contents edit mode:

Copying and Pasting Data

Data copying, moving, and pasting from the selected cell or area is similar to working with data via clipboard for table area. To correct pasted data, use special paste.

Deleting Data

To delete cell or cell range contents, select the required cell or cell range and press the DELETE key.

Adding Comments

To add explanations, remainders, or comments for a sheet cell, use the comments function..

Adding Named Ranges

To quickly search for the required cell range and also when creating formulas, use named ranges..

Using Formulas

Formulas are expressions, by which data is co converted to the other data.

A formula starts with the = sign and can include constants, statements, and cell references.

Constants

Statements

Cell references

Operations with Formulas

The following operations are available when working with formulas:

Create a formula

Edit formula

See also:

Adding a New Sheet and Working with It