Active Cell Functions
Enter or edit data in the active cell. The contents of the active cell are displayed in the active cell edit box. To edit existing data, activate the desired cell and press the F2 key or highlight the information in the active cell edit box.
Special key functions when editing the active cell are:
-
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.
-
TAB stores the contents of the cell edit box in the active cell and moves the active cell to the right.
-
SHIFT+TAB store the contents of the cell edit box in the active cell and moves the active cell to the left.