-
Ctrl
+Arrow keys
-
If the selected cell is occupied then move the
cell cursor 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 cell cursor 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 cell cursor 10 cells down.
-
Page Up
-
Move the cell cursor 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.
