The cell edit box is located at the top of the worksheet window just above the column letter bar. The cell edit box shows the contents of the active cell and is used for editing cells. Use the cell edit box to see the contents of a worksheet cell when the column is too narrow to display all of the cell contents.
To begin editing the selected cell, press the F2 key. Alternatively, highlight the contents of the cell edit box to edit the cell. To overwrite the current cell contents, simply begin typing without pressing F2. If the mouse is clicked on a new cell, the new cell becomes the active cell.
Special key functions when editing the active cell are:
ESC cancels edit mode and restores the original contents of the active cell.
ENTER stores the contents of the cell edit box and then moves the active cell down one cell.
CTRL+ENTER completes the entry and keeps the current cell active.
Left and right ARROWS move within the cell's text if the F2 key has been pressed. Otherwise, these keys store the contents of the cell edit box and then move the active cell to the left or right.
DELETE deletes the character to the right of the cursor if the F2 key has been pressed. Otherwise, pressing the delete key deletes the entire contents of the cell.
BACKSPACE deletes the character to the left of the cursor if the F2 key has been pressed. Otherwise, pressing the backspace key deletes the entire contents of the cell.
Up and down ARROWS store the contents of the cell edit box in the active cell and move the active cell above or below.
PAGE UP and PAGE DOWN store the contents of the cell edit box in the active cell and move one page up or down.
TAB and SHIFT+TAB store the contents of the cell edit box in the active cell and move the active cell to the right or left.