Microsoft Excel
Move to next nonblank cell in End mode
Press End then Arrow key to enter End mode and jump to the next nonblank cell in the same column or row. If cells are blank, moves to the last cell in the row or column. End mode turns off after the move.
End
,
Arrow
When to use it
Use to quickly navigate to the last filled cell in a data range, skipping empty cells.
Pro tip
Press End repeatedly to toggle End mode on/off. The status bar shows 'End Mode' when active.
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
←
↓
→