View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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.