Edit Data
Activate a Cell Editor
Do one of the following:
- Click a cell.
- Focus a cell with the arrow keys, and press
ENTER
orF2
. - Focus a cell and enter a new value. The editor replaces the cell’s content with the entered value.
Select a Cell’s Text
Press ENTER
or F2
if a cell is focused, or CTRL
+A
if a cell editor is active.
Close a Cell Editor and Accept Changes
Do one of the following:
- Press
ENTER
. - Click or focus another cell.
- Focus another control.
Discard Changes
To discard changes in a focused cell, press ESC
.
Open a Cell Editor’s Drop-down
Do one of the following:
- Press
ALT
+DOWN ARROW
. - Click a editor’s drop-down button.
Change Values
Change Date/Time Values
Open a cell’s drop-down calendar, or:
- Activate a Cell Editor,
- Press
CTRL
+RIGHT/LEFT ARROW
to select a portion of a date/time value, - To increment a value, press
CTRL
+UP ARROW
, to decrement -CTRL
+DOWN ARROW
.
Change Numeric Values
To increment a value, press CTRL
+UP ARROW
, to decrement - CTRL
+DOWN ARROW
.
Change Cell’s Editor Dropdown Values
To select a previous value, press CTRL
+UP ARROW
, a next value - CTRL
+DOWN ARROW
.