Edit Data

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.