Shortcults
Navigate within a table
Maintain Ctrl pressed and use the arrow keys to go to the last non empty cell in the desired direction.
In this example, first go to the Values cell, then will pressing Ctrl, press down, right, up and left.
Select a range
Maintain Shift pressed and use the arrow keys to select the range.
In this example, starting from the Values cell, maintain the Shift key and press down, down, right, right, right.
Select a table
Maintain both the Ctrl and the Shift keys pressed and use the arrow keys to select a table.
In this example, starting from the Values cell, maintain both the Shift and the Ctrl keys and press down, right.
Insert a row or a column
Select a column (row), then press Ctrl, Shift and +, a column (row) will be inserted on its left (above).
Delete a row or a column
Select a column (row), then press Ctrl and -.
Lock a cell, a row or a column
When copying and pasting formulas, you may want to lock cells that refer to constants that apply to all subsequent cells.
Excel allows you to do that using the $ sign:
-
Lock the cell: $ sign before and after the letter of the cell ($A$1)
-
Lock the row: $ sign after the letter of the cell (A$1)
-
Lock the column: $ sign before the letter of the cell ($A1)
By pressing the F4 key in your keyboard when selecting the reference to lock, you can add the $ signs automatically:
-
Press once: lock the cell
-
Press twice: lock the row
-
Press three times: lock the column
Lock the cell
Lock the row
Lock the column
Switch between spreadsheets
To move quickly from the current spreadsheet to the previous or the next one, hold down Ctrl and Press either Page Up (for next) or Page Down (for previous).
