Favorite Excel Keyboard Shorcut Survey Results
- 4 Comment
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.
Random Posts
4 Comments on this post
Trackbacks
-
strugar said:
I don’t understand purpose of this post? When I saw title, I thought there would be something like “shortcut 1 – 25%”, “shortcut 2 – 22%”, and so on; instead, you just listed all the entries and let us count which one is most popular? It seems that many people voted for ctrl+c / ctrl+v, but what is the second most popular shortcut? You expect me to read carefully bunch of lines above and count the shortcuts?
In addition, it seems that Ctrl+C/Ctrl+V is your favourite shortcut as well, as you seem to simply had copied all the entries with their typing errors… You could have put a bit more efforts into this article!
January 20th, 2015 at 2:55 am -
ExcelHints said:
You are correct. Once the survey has been closed to new entries we will do a summary of the listings. For now this is simply to show the detail on what has been posted. For now we are sharing what has been entered. Check back later for a second post which has the analysis of the entries.
January 20th, 2015 at 12:02 pm -
Ben said:
This survey is a great idea and I certainly hope you will publish what these shortcuts actually do after you have them all tallied up so I don’t blow up my spreadsheet experimenting
January 20th, 2015 at 1:36 pm
[…] Source: Excel Hints […]