Do one of the following:

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

  The Settings > Options > Editing > First Enter starts editing option can override Enter behavior globally. The AutoScroll Range toolbar button can override Enter behavior for specific ranges. The shortcut Alt+Enter displays the corresponding context menu which changes global settings or local AutoScroll settings if active in the current location:

  

  You can enter up to 1024 characters. To accept changes, press Enter, any cursor key, or click another cell. To insert a new line, press Ctrl+Enter. To cancel changes, press Esc. If a cell has the Date format, the Date and Time Picker control is activated instead of the usual plain edit control.

  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 position within the edited cell.

  

  To hide the List of Functions permanently, clear 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 cursor keys or the left mouse button. You can also enter a given range in the Go To edit field on the main toolbar and press Enter. The list of 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 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 does not have any drop-down list attached at the same time. This feature can be turned off by clearing the Settings > Options > Use Date Picker checkbox.

The following shortcut keys can be used with that control:

Arrow keys	Changing the active control field and changing control field values
End and Home	Setting the maximum 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