Jan 19 2015

Favorite Excel Keyboard Shorcut Survey Results

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 print
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.

Excel Made Easy

Vbaexpress.Com

ExcelConsultant.Net

 

 

 

 

 

 

 

 

 

Random Posts

Did you find this post helpful? Try signing up for our free daily tips.

Enter your email address: 

          

4 Comments on this post

Trackbacks

  1. Favorite Excel Keyboard Shorcut Survey Results - Get Excel Help wrote:

    […] Source: Excel Hints […]

    January 21st, 2015 at 1:00 am
  1. 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
  2. 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
  3. 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

LEAVE A COMMENT

Subscribe Form

Subscribe to Blog

Sign Up for Excel Hints

Free updates with Excel Hints, Tips & Tricks

Categories

Archives