|Entering data: Editing, selecting and filling cells
To enter new cell contents
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.
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:
To select a range of cells
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.
To delete cell contents and/or attributes
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
Alternatively you can press Backspace to delete both the content and any other data at once.
To move/copy cell contents or a range
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.
To paste cells choosing data from a list of recent Copy command results
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.
To fill a given range with some values, use one of the follwing:
To use a drop-down list to enter data
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.
To use a "Date and Time Picker" control to enter data
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:
|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
|Displays the "Month Calendar" control. Same as clicking the "drop-down" arrow
|If the "Month Calendar" control is active, moves to the previous/next month