Other Shortcuts

This section describes those KSpread shortcut keys used for operations that do not appear in any of the menus.

Ctrl+Arrow keys

If the selected cell is occupied then move the selection to the start or end of the occupied block in the current row or column. If the selected cell is not occupied then move the selection to the start or end of the block of unoccupied cells in the current row or column.

Ctrl+Shift+Arrow keys

If the selected cell is occupied then select all occupied cells to the start or end of that block of occupied cells in the current row or column. If the selected cell is not occupied then select all unoccupied cells to the start or end of that block of unoccupied cells in the current row or column.

Page Down

Move the selection 10 cells down.

Page Up

Move the selection 10 cells up.

Ctrl+Page Down

Move to the next sheet.

Ctrl+Page Up

Move to the previous sheet.

F4

Change cell reference between normal and absolute reference types.

Ctrl+&

Add a border to the selected cell(s).

Ctrl+$

Display the value of the selected cell(s) in Money format.

Ctrl+%

Display the value of the selected cell(s) in Percentage format.

Ctrl+^

Display the value of the selected cell(s) in Scientific format.

Ctrl+#

Display the value of the selected cell(s) in Date format. The value is taken as the number of days since 1 January 1900.

Ctrl+@

Display the value of the selected cell(s) in Time format. The value is taken as the number of seconds since midnight.

Ctrl+!

Display the value of the selected cell(s) in normal Number format.