Excel 365 - 20 KB shortcuts using the SHIFT
key
1. SHIFT+PAGE
UP
Extends selection one screen upwards. For example, if your active cell
is N31, this action selects cells N1:N31.
2. SHIFT+PAGE
DOWN
Extends selection one screen downwards. For example, if your active
cell is C1, this action selects cells C1:C31.
3. SHIFT+HOME
Selects from active cell to first column on the same row. For example,
if your active cell is G4, this action selects cells A4:G4.
4. SHIFT+SPACEBAR/CTRL+SPACEBAR
In a table:
a. Pressing SHIFT+SPACEBAR when
the active cell is in a table – selects the entire record.
b. If you now press CTRL+SPACEBAR
- selects the entire table
c. you can select the whole
table by pressing: CTRL+SHIFT+SPACEBAR in any cell within the table
Outside a table:
a. Pressing SHIFT+SPACEBAR when
the active cell is not in a table - selects the entire row.
b. Pressing CTRL+SPACEBAR when
the active cell is not in a table - selects the entire column.
c. you can select the whole sheet by pressing:
CTRL+SHIFT+SPACEBAR in any cell in the sheet.
5. SHIFT+F11
Inserts
a new worksheet
6. ALT+SHIFT+F1
Inserts
a new worksheet (same as 5.)
7. CTRL+SHIFT+9
Unhides hidden
rows within selection
8. SHIFT+F7
Opens the Thesaurus pane
9. CTRL+SHIFT+F1 (toggle)
Hides/unhides the Title bar, QAT (Quick Access Toolbar), Menu bar and Ribbon
10. SHIFT+F6 (or:
F6)
Toggles between: Menu bar, Active sheet and Name box
11. CTRL+SHIFT+F6
Toggles between open workbooks (when two or more workbooks are open).
12. CTRL+SHIFT+O
Select all cells with comments
13. CTRL+SHIFT+Home
Extends selection from the active cell to A1. For example, if the active cell
is G17,the range: A1:G17 is selected.
14. END->SHIFT->Home
Selects the last non-empty cell in the sheet
15. END->SHIFT->Enter
Selects the intersection of the last non-empty column in the sheet
with the active
cell’s row.
For example, if the active cell is A19 and the last non-empty cell is S26, then this keyboard combination will select cell: S19.
16. SHIFT+BACKSPACE
Selects the first
cell In a selected range
17. CTRL+SHIFT+[
Selects all
Precedents (Direct & Indirect)
(same as: Formulas->Formula Auditing-> Trace Precedents, but without the
arrows)
18. CTRL+SHIFT+]
Selects all Dependents (Direct & Indirect)
(same as: Formulas->Formula Auditing-> Trace Dependents, but without the
arrows)
19. SHIFT+Enter
After
entering a cell address in the Name Box, selects the entire range: from the
active cell to the cell whose address was entered in the Name Box.(for example, if
your active cell is A2 and you key: A20 in the Name Box and then press SHIFT+Enter
– Excel selects the range A2:A20)
20. SHIFT+F2
Adds a new
comment/edits an existing comment in the active cell (bear in mind: this refers to “comments”,
not to “notes” which are new to Excel 365).
