The program uses spreadsheets extensively for data input and output. It offers multiple ways to navigate within a spreadsheet as specified in the following table.
Key |
Action |
---|---|
up arrow |
Moves active cell up one row |
down arrow |
Moves active cell down one row |
right arrow |
Moves active cell right one column |
left arrow |
Moves active cell left one column |
Shift+arrow key |
Extends selection in direction of arrow key |
Page Up |
Moves active cell one page up |
Page Down |
Moves active cell one page down |
Ctrl+Page Up |
Moves active cell one page left |
Ctrl+Page Down |
Moves active cell one page right |
Home |
Moves active cell to first cell in row |
End |
Moves active cell to last cell in row that contains data |
Ctrl+Home |
Moves active cell to first row, first column |
Ctrl+End |
Moves active cell to last row and column that contain data |
Tab |
Moves active cell to next cell to the right (or at end of row moves to beginning of next row) |
Shift+Tab |
Moves active cell to next cell to the left (or at beginning of row moves up to end of row above) |
Shift+space |
Selects current row |
Ctrl+space |
Selects current column |
Shift+Ctrl+space |
Selects entire sheet |
Ctrl+X or Shift+Del |
Cuts current selection or active cell's data to Clipboard |
Ctrl+V or Shift+Ins |
Pastes Clipboard contents into active cell |
Ctrl+C or Ctrl+Ins |
Copies current selection or active cell's data to Clipboard |
Enter |
Active cell moves down |
Esc |
If sheet is in edit mode, previous cell value replaces new value and edit mode is turned off |
F2 |
If edit mode is on, cell value is cleared |