View Single Post
  #5   Report Post  
Max
 
Posts: n/a
Default

Agreed, but you could just keep holding down CTRL,
and continue to tap the Up / Down arrow ?

Alternatively,
press CTRL+End, then use Left arrow
press CTRL+Home, then use Right arrow

Not sure if there's a direct keystroke combo to do as you want

Try browsing Chip's:
http://www.cpearson.com/excel/KeyboardShortcuts.htm

and Debra's:
http://www.contextures.com/excel.htm
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"piddilin" wrote in message
...
Some cells in the column are blank so CTRL+Up arrow, etc. only goes to the
next nonblank cell.