To enter data or edit cells values:
Select the cell and enter the required data.
Double-click in the selected cell area.
Select a cell and press F2, after this enter the data.
The changed values are marked with bold font. The formatting can be overlaid by the other formatting.
On viewing a ready data entry form it is available to save changed parameter values in table area using custom settings.
To finish the data entry:
Press the ENTER key.
Press the TAB key.
Press an arrow key to move to the neighbor cell in specified direction. This method does not work if the cell has been edited using the F2 key or the formula bar.
If data control has been set up, and the On Changing Data option has been selected, entered incorrect values will be highlighted.
When a data entry form is opened for view or edit, cell values calculated by means of connected calculation algorithm are displayed as changed data if it has not been saved before. When values are changed in the cells used in formulas, new values are calculated, if the calculation algorithm is connected for edit, and calculated values are again displayed as changed data.
To make changes to the data entry form, save changes by clicking the Save Changes button.:
If changed data save lock of table area with applied control was set, then on entering incorrect values the information message indicating that entered data is to be modified will be displayed:
If data was changed, but not saved, then on saving, creating a copy, updating, changing parameters values, closing, entering data on approving data entry form; transposing and editing of table area, you will be prompted to save it.If changed data save lock of table area with applied control was set, then the warning indicating than changes will not be saved because do not respect control setting appears. If the operation is agreed, the changed data will be reset and the operation will be applied. On canceling operation the changed data remains in table area.
To undo changes, click the Undo Changes button on the Home ribbon tab.
To fill the table area with data, you can use clipboard.
If data is entered or edited in the form during process steps execution:
Save data.
Finish the step by clicking the Finish button.
When data entry or editing is finished, follow the step if required:
See also: