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 Named Ranges

Named ranges are used to quickly search for the required cell range and during formula creation. To get a detailed description, see the Adding a Named Range section.

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