The active cell is displayed with a heavy border surrounding the cell. The contents of this cell are displayed in the cell edit box. You can enter or edit data in the active cell. To edit existing data, activate the desired cell and press the F2 key or highlight the information in the cell edit box.
Special Key Functions when editing the active cell :
Keyboard Command |
Action |
ESC |
ESC cancels edit mode and restores the original contents of the active cell. |
ENTER |
ENTER stores the contents of the cell edit box and then moves the active cell down one cell. |
CTRL+ENTER |
CTRL+ENTER completes the entry and keeps the current cell active. |
ARROWS (left and right) |
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. |
ARROWS (up and down) |
Up and down ARROWS store the contents of the cell edit box in the active cell and move the active cell above or below. |
DELETE |
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 |
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. |
PAGE UP and PAGE DOWN |
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 |
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. |
See Also