View Single Post
 
Old 06-06-2016, 10:58 PM
Daniel Arbeit Daniel Arbeit is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2016
Posts: 5
Daniel Arbeit is on a distinguished road
Default

Sorry "Strg" means "Ctrl".
E.g.:

The cell A1 is selected i press Ctrl+Arrowkeydown and it jumps to A2 (the last cell where there is still data without interrupt by empty cells). Next Ctrl+Arrowkeydown it jumps to A4 (begin of data) then A6 (end of data).

In the colomn C and D this doesn't work. It jumps from C1/D1 to C9/D9 without stopping at the data inbetween (it should stop at C4/D4).

From Microsoft:
"CTRL+ARROW KEY moves to the edge of the current data region in a worksheet."
https://support.office.com/en-us/art...9-9b7213f0040f
Reply With Quote