Have a spread sheet with several columns.
Would like be able to hit a key (i.e. Enter) to return to next row and back
to column #1.

thanks,

L.

Moving to another group.
Thanks,

"L." wrote in message
...
Have a spread sheet with several columns.
Would like be able to hit a key (i.e. Enter) to return to next row and
back to column #1.

thanks,

L.

Don't know where you moved to but you can use Sheet protection, or you can
use a Selection Event macro.

Worksheet_SelectionChange to prevent entry past a column
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"L..." wrote in message ...
Moving to another group.
Thanks,

"L." wrote in message
...
Have a spread sheet with several columns.
Would like be able to hit a key (i.e. Enter) to return to next row and
back to column #1.

thanks,

L.

Tab, Tab, Tab, Enter will move you down one row and back to original column.


Gord Dibben MS Excel MVP

On Wed, 3 May 2006 16:06:56 -0500, "L." wrote:

Have a spread sheet with several columns.
Would like be able to hit a key (i.e. Enter) to return to next row and back
to column #1.

thanks,

L.

Thanks for all the suggestions.

L.

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Tab, Tab, Tab, Enter will move you down one row and back to original
column.


Gord Dibben MS Excel MVP

On Wed, 3 May 2006 16:06:56 -0500, "L." wrote:

Have a spread sheet with several columns.
Would like be able to hit a key (i.e. Enter) to return to next row and
back
to column #1.

thanks,

L.