Keyboard shortcuts. Operations with Spreadsheet Documents

Merge cells (lines / columns)

Action

Keyboard Shortcut

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

Ctrl + M

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-

Spreadsheet Document in a Form

Action

Keyboard Shortcut

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

Action

Keyboard Shortcut

Move from cell to cell

Up, Down, Left, Right

Move to the next filled or empty cell

Ctrl + (Up, Down, Left, Right)

Scroll up one page

PgUp

Scroll down one page

PgDn

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

Expand group

Ctrl + Num+

Collapse group

Ctrl + Num-

Expand groups and all subordinate

Ctrl + Alt + Num+

Collapse groups and all subordinate

Ctrl + Alt + Num-

1C:Enterprise Developer's Community