Jan 19 2015
Favorite Excel Keyboard Shorcut Survey Results
- 0 Comments
This survey simply asked what are your five favorite keyboard shortcuts for Microsoft Excel. So far 31 people have responded, their detailed results are below. Take the time to review them, and you will learn at least one more shortcut that you can use. Note, this is a raw data dump so you can see what is actually submitted. We will present a clean summary when the survey closes.
Still want to take the survey, then click here.
| First Preference | |
| 1 | alt-= |
| 2 | Ctrl-C Ctrl-V |
| 3 | strg+a |
| 4 | ctr + z |
| 5 | alt-i-r |
| 6 | cntl-c (and v) |
| 7 | Control & c |
| 8 | cut |
| 9 | |
| 10 | <ctrl>; |
| 11 | ctrl c |
| 12 | Alt + F11 |
| 13 | ctrl-c |
| 14 | Ctrl-S |
| 15 | ctrl * |
| 16 | ctrl+c |
| 17 | ctrl c / ctrl v |
| 18 | Ctrl+D |
| 19 | Ctrl + C |
| 20 | ctrl + ; |
| 21 | Ctrl+C & Ctrl+V |
| 22 | CTRL S |
| 23 | control + |
| 24 | Cntrl+Shift+* |
| 25 | ctr + c |
| 26 | CTRL+SHIFT+L |
| 27 | Ctrl+C |
| 28 | ctrl+c |
| 29 | Crl+C/Crl+V copy/paste |
| 30 | control+c |
| 31 | Ctrl+1 (Format Cells) |
| Second Preference | |
| 1 | alt-f11 |
| 2 | Ctrl-T |
| 3 | strg+c |
| 4 | ctr + c |
| 5 | alt-i-c |
| 6 | end-cursor up (and down, left, right) |
| 7 | control & v |
| 8 | copy |
| 9 | |
| 10 | <shift><ctrl>: |
| 11 | ctrl v |
| 12 | Ctrl + C |
| 13 | ctrl-v |
| 14 | Ctrl-F6 |
| 15 | ctrl home |
| 16 | ctrl+p |
| 17 | ctrl shift end |
| 18 | Ctrl+C |
| 19 | Ctrl + V |
| 20 | ctrl + c |
| 21 | F4 & F2 |
| 22 | F12 |
| 23 | control space |
| 24 | Cntrl+Shift+Down arrow |
| 25 | ctr + v |
| 26 | CTRL+Arrow keys |
| 27 | Ctrl+V |
| 28 | ctrl+v |
| 29 | Crl+shift+L to turn on/off filters |
| 30 | control+v |
| 31 | Alt+F11 (VBA Editor) |
| Third Preference | |
| 1 | alt+shift+drag border to move/insert range |
| 2 | Alt-N V T |
| 3 | strg+v |
| 4 | ctr + v |
| 5 | F2 |
| 6 | end-home (with shift as needed) |
| 7 | end & arrow |
| 8 | past |
| 9 | |
| 10 | <ctrl>c |
| 11 | ctrl d |
| 12 | Ctrl + V |
| 13 | ctrl-tab |
| 14 | Ctrl-C |
| 15 | |
| 16 | ctrl+f |
| 17 | ctrl home |
| 18 | Ctrl+V |
| 19 | Shift + END + Arrow Keys |
| 20 | ctrl + v |
| 21 | Ctrl+A |
| 22 | CTRL D |
| 23 | shift space |
| 24 | Cntrl+Shift+D |
| 25 | ctr + x |
| 26 | ALT+N+V+T |
| 27 | Ctrl+F |
| 28 | |
| 29 | F2 to edit cell |
| 30 | control+A |
| 31 | F12 (SaveAs) |
| Fourth Preference | |
| 1 | ctrl-arrows |
| 2 | Alt-W-I |
| 3 | strg+f |
| 4 | ctr + x |
| 5 | F4 |
| 6 | cntl-home (with shift as needed) |
| 7 | control & h |
| 8 | |
| 9 | |
| 10 | <ctrl>v |
| 11 | ctrl : |
| 12 | F4 in absolute range cycling |
| 13 | alt ind |
| 14 | Ctrl-V |
| 15 | |
| 16 | ctrl+a |
| 17 | ctrl page down / ctrl page up |
| 18 | Ctrl+Z |
| 19 | Ctrl + Z |
| 20 | ctrl + x |
| 21 | Alt+F11 & Alt+F8 |
| 22 | ALT U U |
| 23 | control L |
| 24 | |
| 25 | |
| 26 | CTRL+- |
| 27 | |
| 28 | |
| 29 | Crl+1 to format |
| 30 | control+F |
| 31 | Ctrl+Shift+v (Format Paste) |
| 1 | Fifth Preference |
| 2 | Application.Onkey shortcuts for various macros in PERSONAL.XLSB |
| 3 | Ctrl Shft L |
| 4 | strg+1 |
| 5 | shift + ctr + enter |
| 6 | alt-e-d |
| 7 | cntl-break |
| 8 | control & home |
| 9 | save |
| 10 | |
| 11 | <ctrl>home |
| 12 | ctrl s |
| 13 | Ctrl + +/- to insert/delete |
| 14 | alt dp |
| 15 | Alt-F8 |
| 16 | |
| 17 | alt+F4 |
| 18 | ctrl tab |
| 19 | Ctrl+Y |
| 20 | F2 |
| 21 | ctrl + p |
| 22 | Alt+Enter while editing cell |
| 23 | CTRL F |
| 24 | control ` |
| 25 | |
| 26 | |
| 27 | ALT+H+B+A |
| 28 | |
| 29 | |
| 30 | F4 to change cell references |
| 31 | |
| Ctrl+H (Replace) |
| Open-Ended Response | |
| 1 | Also: highlight range + ctrl-. ; f3; shift-space & ctrl-space & ctrl-a; alt-n-v; alt-a-s-s; ctrl-t; alt-e-s-v; |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | I don’t use any keyboard shortcuts. I would love to know the results of this survey so I can learn to use the most common/popular ones. |
| 10 | |
| 11 | |
| 12 | |
| 13 | alt ind for names (old menus), alt dp for pivot table |
| 14 | The first and second were easy. It was fun to figure out the order of the second three since I use so many keyboard shortcuts. |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | I use a lot of keyboard shortcuts as well as mouse shortcuts. These 5 are the ones I use the most. |
| 20 | I also have several keyboard shortcuts for macros I developed. |
| 21 | |
| 22 | and anorher and another |
| 23 | Hard to choose, I extensively use keyboard shortcuts as they make your work in Excel so much faster. |
| 24 | In no particular order of preference. Can’t recall any others I use regularly. |
| 25 | now I ussially use only copy-past shortcuts |
| 26 | |
| 27 | |
| 28 | |
| 29 | There are so many… |
| 30 | all these very usefl |
| 31 | I love excel and still I feel I know little about the power of excel. Among the many applications which I used, no doubt, it is excel that excels everything. Hats off. |
Here are a few of our favorite pages on the web on this topic.