Flash fill – Microsoft Excel shortcut
When you have a patterned column and wish to have the same pattern repeat in the next column, use this useful shortcut. Simply select the first cell in the new column adjacent to that which has been completed. Use this shortcut, and Excel will attempt to repeat the same pattern in the new column. This is unfortunately only available on a PC.
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 E
We don’t know a Mac shortcut for this.
Table of contents
Worksheets and Workbooks View Row and Column Selection Ribbon Control Pivot Tables Operating within a Cell Navigating and Selecting Cells Help and Menus Group Selection General Excel General Cell Control Formulas and Functions Formatting Text and Numbers Dialog Boxes Borders Advanced Selection Adding Content to CellsGet more Reference tips and tricks
Subscribe to our email updates and get Reference tips direct to your inbox.
