Other Shortcuts
In this section we added few Macros and VBA Editor Shortcuts and Power Query Shortcuts
Macros and VBA Editor
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Open the VBE window (edit VBA code) |
Alt + F11 |
Fn + Alt + F11 |
Open the Macro window to run or edit a macro |
Alt + F8 |
Fn + Alt + F8 |
Record Macro |
Alt, L, R |
N/A |
Open Excel Add-ins Window |
Alt, L, R |
N/A |
Open COM Add-ins Window |
Alt, L, J |
N/A |
Power Query
Command | Windows Shortcuts | Mac Shortcuts |
---|---|---|
Open the Power Query Editor |
Alt, A, P, L, N |
|
Press any button in the Power Query Ribbon |
Alt, Letter Sequence |
|
Quick Access Toolbar (QAT) in Power Query |
Alt + Number |
|
Rename Column |
F2 |
|
Remove Column(s) |
Delete |
|
Select All Columns |
Ctrl + A |
|
Select First Column |
Home |
|
Select Last Column |
End |
|
Select Multiple Adjacent Columns |
Shift + → or ← |
|
Select Multiple Non-Adjacent Columns |
Ctrl + → or ←, Space |
|
Open Filter Drop-down Menu |
Alt + ↓ |
|
Open Right-click Menus |
Menu Key |
|
Open Table Options Menu |
Select First Column, ← , Space |
|
Select Task Panes & Ribbon |
Tab & Shift + Tab |
|
Close Power Query Window |
Alt + F4 |
|
Close & Load |
Alt, F, Enter |