Click on the desired cell of the table in which you want to enter data. This cell is now the active cell.
Enter your data now. You can control the input in the edit line.
Correctors can be done immediately with the Reject button or with the back button, as with any data input.
Complete the data entry with Enter or use the confirm switch.
If you want to cancel the input, either press the ESC button or click the cancel button.
If the cell already has a content, it is overwritten when you enter new data.
If you want to change the contents of a cell, select the cell in question and alternatively press the function key (F2): Double click on the cell. The insertion mark is now in the selected cell and you can correct the content (a correction in the edit line is also possible).
The cell address indicates the cell that is currently active (black bordered).
Particular features of figures:
If only digits are entered in a cell, Excel interprets this input as a number. A negative number must be preceded by a minus sign.
Numbers shall be entered without thousands separator or other accessory. For example, if you put a currency symbol (€, $) in front of the number by hand, Excel interprets the input as text and can no longer count on this value. For decimal numbers, however, the comma must be set.
Numbers are placed in the default setting of Excel right aligned in the cell.
The last decimal place completes Excel commercially from 0 – 4, from 5 – 9. For calculations, however, Excel uses the unrounded content of a cell.
Large numbers are represented in the exponential notation.
8,37593E+13
Excel recognizes by the entered characters whether it is numbers, text or formulas.
Text in a cell is placed left aligned.
If the column width of a cell is not sufficient for the input text, the right adjacent cells are covered. However, if the neighboring right cell is not empty, Excel cuts the text to the right and displays the complete text only in the edit line at the top.