יום חמישי, 2 בנובמבר 2023

Twenty KB shortcuts In Excel 365 using the SHIFT key


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).

 


אין תגובות:

הוסף רשומת תגובה