1.8.6. Operations with Spreadsheet Documents

Go to Cell

Ctrl + G

Move from cell to cell

Up, Down, Left, Right

Move to the next filled or empty cell

Ctrl + (Up, Down, Left, Right)

Move to the next filled or empty cell and select cells

Ctrl + Shift + (Up, Down, Left, Right)

Select a cell

Shift + (Up, Down, Left, Right)

Select cells from the current one up to the beginning of the row

Shift + Home

Select cells from the current one to the end of row

Shift + End

Select rows

Alt + Shift + (Up, Down)

Select rows to the next filled or empty cell

Ctrl + Alt + Shift + (Up, Down)

Select columns

Alt + Shift + (Left, Right)

Select columns up to the next filled or empty cell

Ctrl + Alt + Shift + (Left, Right)

Select cells from the current one up to the beginning of the document

Ctrl + Shift + Home

Select cells from the current one to the end of the document

Ctrl + Shift + End

Scroll up one page

PgUp

Scroll down one page

PgDn

Scroll page to left

Alt + PgUp

Scroll page to right

Alt + PgDn

Edit cell contents

Enter

Toggle edit mode/cell entry

F2

Go to the beginning of the line

Home

Go to the end of the line

End

Go to the beginning of the text

Ctrl + Home

Go to the end of the text

Ctrl + End

Set a name to the current area

Ctrl + Shift + N

Expand group

Ctrl + Num+

Collapse group

Ctrl + Num-

Expand groups and all subordinate

Ctrl + Alt + Num+

Collapse groups and all subordinate

Ctrl + Alt + Num-

Select value from a cell

F4

Clear a value from the cell (for a composite data type cell a predefined data type is cleared)

Shift+F4