To Enter Data:

Action

Result

Step 1.

Select cell

The Status bar shows the word Ready. The cell border is dark and wide. The Formula bar shows the cell's contents.

Step 2.

Type text and numbers.

The Status bar changes to Enter. Characters you type appear in the cell, overwriting any previous contents. Navigation keys -Arrows, home, end- now move the cursor within the cell.

Step 3.

Press ENTER or
click the checkmark button on the Formula bar.

What you typed is entered into cell. The selected cell is changed to the cell below when enter is pressed (by default) but not when is clicked.

To Edit Data:

Action

Result

Step 1.

Double-click cell or
select cell and then click in the Formula bar.

The Status bar shows the word Edit. The cell border is dark and wide. The Formula bar shows the cell's contents.

Step 2.

Edit cell contents.

Arrow keys, home, and end now move cursor inside the cell. You can select a single word by double-clicking it. You can drag to select phrases or characters. You can insert new characters. Delete and Backspace will apply to the cell contents.

Step 3.

Press ENTER or
click the checkmark button on the Formula bar.

Revised contents entered into cell. Selected cell is changed to cell below when enter is pressed. (by default) but the selection is not changed when
is clicked.

To Clear Data:

Do one of these:

Result:

Before pressing ENTER --

Press ESC key.
or
Click the X button on the Formula bar.
or
Click the Undo button.

The cell's contents are deleted but the cell remains as does the formatting applied to the cell.

After pressing ENTER—

Select the cell and...

Press DELETE.
or
Use menu  Edit  |  Clear  |  Contents .
or
Use right click menu Clear Contents... .