Keyboard Shortcuts in Variables Worksheets

 

In the variables worksheet, the following default keyboard shortcuts can be used to perform frequently required operations.

Shortcut

Operation

Condition

<INS>

Insert a new variable declaration below the present line

<TAB>

Move to the first cell in the next row

End of row reached

Create a new variable row at the end of the grid and move to the first cell of this new row

End of grid is reached

Move to the next cell to the right

Default

<ENTER>

Move to the first cell in the next row

End of row reached

Create a new variable row at the end of the grid and move to the first cell of this new row

End of the grid reached

Move to the next cell to the right

Default

Select marked entry in a drop-down combo box

Drop-down combo box opened

<Shift> + <ENTER>

Create a new variable row at the end of the grid and move to the first cell of this new row

End of grid reached

Move to the first cell in the next row

Default

<Del>

Delete the content of the cell

<Ctrl> + <Home>

Move to the first cell in the first row of the grid

<Ctrl> + <End>

Move to the first cell in the last row of the grid

<PageUp>/<PageDown>

Scroll one page up/ down

<ESC>

Cancel selection

One or more cells selected

Leave cell without modification

Cell in edit mode

Close drop-down combo box without selecting an entry

Drop-down combo box opened

<ArrowUp>

Move to the previous row

Browse through the entries of an opened drop-down combo box

Drop-down combo box opened

<ArrowDown>

Move to the next row

Present row is variable

Browse through the entries of an opened drop-down combo box

Drop-down combo box opened

<ArrowLeft>

Move to the previous column

Collapse the group (if not empty)

Present row is group

<ArrowRight>

Move to the next column

Present row is variable

Expand the group (if not empty)

Present row is group

<Ctrl> + <ArrowUp>

Move to the first row

<Ctrl> + <ArrowDown>

Move to the last row

<Ctrl> + <ArrowLeft>

Move to the first column

<Ctrl> + <ArrowRight>

Move to the last column

<Shift> + <ArrowUp>

Move to the previous row and extend the selection

<Shift> + <ArrowDown>

Move to the next row and extend the selection

<Shift> + <ArrowLeft>

Move to the previous column and extend the selection

<Shift> + <ArrowRight>

Move to the next column and extend the selection

<Shift> + <Space>

Select the present row

<Ctrl> + <C>

Copy the content of the cell to the clipboard

One cell selected

Copy the content of the rows to the clipboard

Row(s) selected

<Ctrl> + <X>

Move the content of the cell to the clipboard and clear the cell content

One cell selected

Move the content of the rows to the clipboard and delete the rows

Row(s) selected

<Ctrl> + <V>

Paste the content of the clipboard into the cell

One cell selected

Insert the content of the clipboard into the grid

Row(s) selected

<Home>

Change to edit mode and move the caret to the beginning of the cell contents

<End>

Change to edit mode and move the caret to the end of the cell contents

<Alt> + <ArrowDown>

Open a drop-down combo box

Cell contains drop-down combo box

<Space>

Activate/deactivate a checkbox

Cell contains checkbox