Microsoft Excel
Move to edge of data region
Ctrl+Arrow moves the active cell to the edge of the current data region (the last non-empty cell in that direction).
Ctrl
+
Arrow
When to use it
Use to quickly jump to the boundary of a contiguous block of data in a worksheet, avoiding manual scrolling.
Pro tip
If the active cell is in an empty region, Ctrl+Arrow jumps to the next cell with data in that direction. Combine with Shift to extend the selection.
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
←
↓
→