one way..................
enter a macro activated by a shortcut

this macro will cause the cell selection to go to the top of the next column

Sub shiftup()
'
' Keyboard Shortcut: Ctrl+i
'
If ActiveCell.Row = 1 Then Exit Sub
ActiveCell(0, 2).Select
Selection.End(xlUp).Select
End Sub

Greetings from New Zealand


"chipsdad" wrote in message
...
I need to be able to, in one quick move, go from the last entry in a
spreadsheet column to the top of the next column and be able to do this
repeatedly.