Skip to main content

Data Editing

Activate Cell Editor

Do one of the following:

  • Focus a cell and then click it again.
  • Focus a cell (for instance, via the keyboard), and press ENTER or F2.
  • Focus a cell and press any alpha-numeric key. The editor will be invoked and its contents will be replaced with the pressed character.

If a cell editor provides a dropdown, you can activate the editor and open its dropdown by pressing ALT+DOWN ARROW or F4.

Select and Deselect Cell Text

Press F2 or CTRL+A.

Close Cell Editor and Accept Changes

Do one of the following:

  • Press ENTER.
  • Click any other grid cell.
  • Focus any other control.

Discard Changes

To discard changes made in a cell, press ESC.

Open Cell Editor’s Dropdown

Focus a cell and do one of the following:

  • Press F4.
  • Click the editor’s dropdown button:


Close Cell Editor’s Dropdown

For all editors providing a dropdown, you can close the dropdown by pressing ALT+DOWN ARROW.

If the calculator is displayed in the dropdown, it can be closed via CTRL+ENTER.

Change Values

Change Numeric Values

To increment the value, press UP ARROW. To decrement the value, press DOWN ARROW.

See Also