View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Kevin B Kevin B is offline
external usenet poster
 
Posts: 1,316
Default Hit Enter - cursor to beginning of next row?

In addition to Bob I's reply, you can also select the rows and columns you're
entering data into, starting at the first cell and selecting down to the last
cell.

Typing and pressing enter moves the cell pointer one cell left to right
until the last column has been encountered, at that point it moves to the
first cell on the next row. Upon reaching the last selected cell, pressing
enter moves you to the start of the selected range.

Use <Shift + Enter to move from right to left
--
Kevin Backmann


"Baldrick" wrote:

I am entering row after row of data. When I hit the Enter key, how do I get
the cursor to return to the beginning of the next row?