Active Cell

 

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

Worksheet Document