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 edit cell contents.
Copy and paste data.
Delete data.
Add named ranges.
Use formulas.
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:
Press the ENTER key.
Press the TAB key.
Press an arrow key to move to the neighbor cell in the specified direction.
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.
To delete cell or cell range contents, select the required cell or cell range and press the DELETE key.
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.
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.
The following operations are available when working with formulas:
See also: