When you start typing text, you will notice that it does not immediately appear in the active cell. Instead, it is shown in the formula bar. This means that you can make changes to it more easily, as it is slightly larger and easier to see.
When you have finished typing the text, do one of the following:
Click on the Confirm button on the formula bar. The text will be inserted into the active cell.
Press one of the arrow keys. Your text will be entered and the active cell will move according to which arrow key you pressed. This saves having to use a keystroke if you’re entering a long column or row of information.
Press the Enter key - the text will be entered and the active cell will move down one row.
Click the Cancel button on the formula bar to abandon the text entry.
Ability will display the word "Text" in the Cell Type box on the formula bar.
The following section shows you how to enter text that is wider than the cell.
See: