Data Editing

• May 03, 2018

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

Cell Editors Overview