Enter an array formula – Microsoft Excel shortcut
Once you have added a function name (I.E. "SUM") to your cell, this shortcut will insert closed brackets ready to be filled with the required information needed to execute. This is used to create array functions which can perform one or more calculations at once. For more information on array functions, see this Microsoft guide: http://bit.ly/1QYqMQP.
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
PrtSc
ScrLk
Pause
~
`
`
!
1
1
@
2
2
#
3
3
$
4
4
%
5
5
^
6
6
&
7
7
*
8
8
(
9
9
)
0
0
_
-
-
+
=
=
Insert
Home
PgUp
Tab
Q
W
E
R
T
Y
U
I
O
P
{
[
[
}
]
]
Del
End
PgDn
Caps
Lock
Lock
A
S
D
F
G
H
J
K
L
:
;
;
"
'
'
Shift
Z
X
C
V
B
N
M
<
,
,
>
.
.
?
/
/
↑
Ctrl
Alt
Alt
←
↓
→
esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
~
`
`
!
1
1
@
2
2
#
3
3
$
4
4
%
5
5
^
6
6
&
7
7
*
8
8
(
9
9
)
0
0
_
-
-
+
=
=
delete
tab
Q
W
E
R
T
Y
U
I
O
P
{
[
[
}
]
]
|
\
\
caps lock
A
S
D
F
G
H
J
K
L
:
;
;
"
'
'
returnenter
shift
Z
X
C
V
B
N
M
<
,
,
>
.
.
?
/
/
shift
fn
control
optionalt
command⌘
⌘command
optionalt
▲
◄
▼
►
Ctrl Shift Enter
Control Shift Enter
