Do one of the following:

• Press Enter, F2, any letter/digit key or double-click a given cell.

  Note: The Settings > Options > Editing > First Enter starts editing can override the Enter key bahavior globally. Similarily, the AutoScroll Range table toolbar button can override the Enter key bahavior for individual cell ranges. The shortcut is Alt+Enter - it displays the corresponding context menu which changes the global settings or local AutoScroll settings if it's active in the current location:

  

  You can enter up to 1024 characters. To accept changes, press Enter or any of the cursor keys or click another cell.
  To enter a new line in the edited cell, press Ctrl+Enter.
  To cancel changes, press Esc.
  If a given cell has the "Date" format, the "Date and Time Picker" control is activated instead of the usual plain edit control. For more information, see the "Date and Time Picker" section below.
  

  GS-Calc displays an additional button above the edited cell which:
  - shows the current location,
  - enables you to display a menu with options that control how the List of Functions dialog box is displayed:

  

  If the edited cell contains the leading "=" indicating a formula, clicking or selecting other cells causes adding their addresses to the edited text or replacing the address pointed by the current cursor/selection position within the edited cell.

  

  To hide the List of Functions permanently, clearing all the menu check marks.

  To compose a formula you can use the fx edit field on the toolbar. The + and fx toolbar buttons enable inserting functions, various types of cell ranges, existing formulas, single values or values as arrays.
  
  Clicking the "Enter" button inserts the created formula in the current cell(s).

  To add or replace cell references directly in the edited worksheet cell, select a given range using the left mouse button. Selected ranges or cells will be added to the edited formula or will replace the reference pointed by the edit cursor.

• Edit the cell contents in the Formula edit field on the toolbar. The cell contents is loaded by clicking the "Sigma" button and the new value is accepted by clicking the "Enter" button (or by pressing Enter). Previously entered values are available via the attached menu. To clear the history of the entered values use the Settings > Clear Lists of Used Files and Data command.

If you set some numeric or date/time format for a given cell, GS-Calc will try to interpret the data according to that format. If this fails, all the remaining formats will be tried out.

If a given cell is unformatted, GS-Calc will try out all subsequent standard formats. The date/time format has precedence over the fractional format.

If the Auto-formatting option is turned on, the matching format will become the new format of the edited cell unless the cell was formatted using a user-defined style.

To enter numeric values as text labels use one of the following:

• Press and hold down the Shift key before pressing Enter.
• Enter the apostrophe ' as the first character in a cell:

  

  If a given text string actually contains ' as the first character, you need to double it.
  Alternatively you can also use enclosing ".

Use the SHIFT key with coursor keys or the left mouse button. You can also enter a given range in the "Go To" edit field on the main tooblar and press the Enter key or button. The list of the recently entered selections is attached to that Enter toolbar button.

Select a given cell or a range of cells and press Del. By default, GS-Calc displays a dialog box enabling you to choose which data should be deleted: numeric data, textual data, formulas, formatting, drop-down lists or comments. You can you turn it off and display that dialog only when Ctrl+Del is pressed.
Alternatively you can press Backspace to delete both the content and any other data at once.

Place the mouse cursor on the top border of the selection and drag the entire cell/range to the desirable location.
If you want to copy the selection, press and hold down the Ctrl key.

Use the Settings > Options command and specify the Copy/Paste Level. The valid range is 1-16. Subsequent Copy command results will be retained in memory up to that level in a cycling manner. The list of data available for pasting is attached to the Paste button.
To paste only textual data, press and hold down the Shift key when choosing a given item to paste.

1. Copy the source cell or range, select the destination range and paste the copied data.
2. Select the destination range and enter the value in the toolbar combo box.
3. Select the destination range and use the Insert > Series command. See Inserting Series

Use the Tools > List command and specify which list should be used for a given cell(s). The same list can be shared by any number of cells in any number of worksheets in one document. One workbook can contain up to 255 lists. The number of list items is unlimited.

The control is displayed by default for each cell that is formatted as "Date" and doesn't have any drop-down list attached to it at the same time. This feature can be turned off by clearing the Settings > Options > Use Date Picker checkbox. The following shortcuts key be used with that control:

Arrows keys	Changing the active control field and changing control field values
End and Home	Setting the maksimum and minimum values for the current field of the control
Plus and Minus	Incrementing/decrementing the value of the current control field
Alt+Down	Displays the "Month Calendar" control. Same as clicking the "drop-down" arrow
PageUp, PageDown	If the "Month Calendar" control is active, moves to the previous/next month