To enter data or edit cells values:
Select the cell and enter the required data.
Double-click the selected cell.
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.
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 change data in the form, save changes. To do this:
Click the Save Data button on the toolbar.
Select the Data > Save Data main menu item.
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, it will be prompted to be saved on saving, refreshing, changing parameter values of data entry form, transposing and editing table area. 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 Data changes button on the toolbar.
Select the Data > Undo Data Changes main menu item.
Press CTRL+Z.
To fill the table area with data, you can use clipboard.
When data entry or editing is finished, follow the step if required:
See also: