« FTEST FUNCTION | Difference Between Excel and PowerPivot? » |
Shortcut Keys Used in PowerPivot
Shortcuts, Excel2013, powerpivotHowdy,
This article will help you to find the shortcuts used in PowerPivot. But, the tragedy is there is no shortcut to open PowerPivot as of now. (if there is any, please teach me using below comments.) Now, lets go ahead with the shortcuts.
...
CTRL + A | Select Entire Table |
CTRL + C | Copy Selected Data |
CTRL + D | Delete Table |
CTRL + M | Move a Table |
CTRL + R | Rename a Table |
CTRL + S | Save the File |
CTRL + Y | Redo the Last Action |
CTRL + Z | Undeo the Last Action |
CTRL + SPACE | Select the Current COLUMN |
SHIFT + SPACE | Select the Current ROW |
SHIFT + PgUp | Select the Cells from Current Selection to the First Cell of the COLUMN |
SHIFT + PgDn | Select the Cells from Current Selection to the Last Cell of the COLUMN |
SHIFT + End | Select all Cells from Current Location to the Last Cell of the ROW |
SHIFT + HOME | Select all Cells from Current Location to the First Cell of the ROW |
CTRL + PgUp | Move to the Previous Table |
CTRL + PgDn | Move to the Next Table |
CTRL + HOME | Move to the First Cell of the Upper Left Corner of the Selected Table |
CTRL + END | Move to the Last Cell in the Lower Right Corner of the Selected Table |
CTRL + LEFT | Move to the First Cell of Selected ROW |
CTRL + RIGHT | Move to the Last Cell of the Selected ROW |
CTRL + Up | Move to First Cell of Selected COLUMN |
CTRL + Down | Move to Last Cell of Selected COLUMN |
CTRL + ESC | Close Dialog Box or Cancel the Process |
ALT + DOWN | Open AutoFilter Menu Dialog Box (important) |
F5 | Open the GoTo Dialog Box |
F9 | Recalculate ALL FORMULAS in PowerPivot Window |
Right-Click (before CTRL button, last row) |
Open the Context Menu for the Selected Cell or Row or COLUMN |
Note: Mr. Excel Guru (KenPuls) has written a short VBA code to open PowerPivot using keyboard shortcut. And, he has a valid reason for why he is using it. Please go through his blog and say ''thanks'' www.excelguru.ca
DO YOU ADD MORE SHORTCUTS?
Please do share your shortcuts to powerpivot, if you have any which I have missed here, using below comments section.
If you like this post, please do share it on your social networking sites by clicking on the icons placed around the blog.
If you want to be a member of our family, JOIN OUR FAMILY,.
SOME IMPORTANT LINKS:
New DAX Functions Added in PowerPivot
Difference Between Excel and PowerPivot
Thanks,
You must be logged in to see the comments. Log in now!
If you have no account yet, you can register now! (It only takes a few seconds)
Recent comments