How do I move from cell A 10 to cell B1 with one move or click
 

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.

How do I move from cell A 10 to cell B1 with one move or click
 

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.

How do I move from cell A 10 to cell B1 with one move or click
 

Of course you can also insert a hyperlink in the cell but i prefer not to
have to grab the mouse.

"Bill Kuunders" wrote in message
...
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.

How do I move from cell A 10 to cell B1 with one move or click
 

Hi,

Suppose the range you want to work with is A1:D10 and everytime you get to
the bottom of a column you want to move to the top of the next column
automatically.

Hightlight the whole range A1:D10 as you press Enter your cursor will move
down the column, when you arrive in A10 and press Enter you will be in B1.

This works while the range remains highlighted. In addition you can use the
Tab, Shift+Tab and Shift+Enter keys in this highlighted mode. You can't use
the four cursor keys or the PgDn or PgUp keys though.

Finally, while in this mode you can press Ctrl . (Control Period) to move
around the outer corners of the selected range.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"chipsdad" wrote:

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.