Edit Data

• Dec 25, 2019

Activate a Cell Editor

Do one of the following:

• Click a cell.
• Focus a cell with the arrow keys, and press ENTER or F2.
• 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:

1. Activate a Cell Editor,
2. Press CTRL+RIGHT/LEFT ARROW to select a portion of a date/time value,
3. 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.