This is a mammoth work. Contains all short cut keys published by Microsoft and also all ALT keys which are not published by Microsoft.
Download it from Excel - Shortcuts Bible
In Excel 2013, we have a new feature called Quick Analysis Tool. If you select a range and press CTRL, you are presented with Quick Analysis Tool. It offers various commonly used functions which you can perform.
Few people don't like this. To disable it permanently -
File > Options > Uncheck the Red Zone
0 of 10 questions completed
This is a quiz on shortcuts in Excel. We use shortcuts in Excel very often like CTRL+C for copy, CTRL+V for pasting etc. Let's test our knowledge of Excel shortcuts.
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
0 of 10 questions answered correctly
Time has elapsed
You have reached 0 of 0 points, (0)
You can create your own shortcuts in Excel
The shortcut to display Find and Replace dialog box is
Shortcut to edit active cell is
SHIFT+F2 is shortcut for
The shortcut to display the list of macros
The shortcut to display Format Cells dialog box
To display Go To dialog box, CTRL+G shortcut is used. Another shortcut for the same is
The shortcut for Autosum is
ALT+F11 is shortcut for
CTRL+U is the shortcut for
You have a need to select A1 to A10. This is a very easy job to do. Suppose, you need to select A1 to A10000. Now, it becomes more cumbersome. Suppose you need to select E23 to AB4325. It is all the more cumbersome job for you.
Approach 1 - Put the range in Name Box and Press Enter
1. Press F5 (or CTRL+G)
2. Specify the range in Reference:
3. OK and you range is selected.