Microsoft Excel
Extend Selection to Last Nonblank Cell
Extends the selection from the active cell to the last nonblank cell in the same column or row. If the next cell is blank, extends to the next nonblank cell.
Ctrl
+
Shift
+
Arrow
When to use it
Use to quickly select a range of data in a column or row without dragging.
Pro tip
Press Ctrl+Shift+Arrow again to extend selection further in the same direction.
Esc
F1
F2
F3
F4
F5
F6
F7
F8
F9
F10
F11
F12
PrtSc
Scroll
Pause
`
~
1
!
2
@
3
#
4
$
5
%
6
^
7
&
8
*
9
(
0
)
-
_
=
+
⌫
Ins
Home
PgUp
Tab
Q
W
E
R
T
Y
U
I
O
P
[
{
]
}
\
|
Del
End
PgDn
Caps
A
S
D
F
G
H
J
K
L
;
:
'
"
Enter
Shift
Z
X
C
V
B
N
M
,
<
.
>
/
?
Shift
↑
Ctrl
Win
Alt
Space
Fn
Alt
Ctrl
←
↓
→