View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Return to next row in first column when entering data in Excel

One small point here Howard that can be useful in some cases.

Returns to the next row in the first column.


Should read.............

Returns to the next row in the column from which you started.

Might be a user wants to start Tabbing across from Column D for example.


Gord Dibben MS Excel MVP

On Mon, 25 Jan 2010 15:15:10 -0800, "L. Howard Kittle"
wrote:

Try this. When you enter data in a cell use TAB to go to the next cell and
when you get to the last cell in that row, enter your data and then hit
ENTER.



HTH
Regards,
Howard

"DaddyRay" wrote in message
...
I am creating a list that that uses more columns than can be covered on the
screen. The problem is when the data is entered in the cell in the last
column, I need to return to the next row in the first column. Yet this
cell
and row is not visible to click onto. Is there a command like in Acess
that
will take me to the end of my list, ready to start another row of data. if
not, are there any suggestions to accomplish this?