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

  • Thread starter Thread starter chipsdad
  • Start date Start date
C

chipsdad

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.
 
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
 
Of course you can also insert a hyperlink in the cell but i prefer not to
have to grab the mouse.
 
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.
 
Back
Top