Move to next row??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

L. - 03 May 2006 22:06 GMT

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.

Reply to this Message

L... - 04 May 2006 02:09 GMT

Moving to another group.
Thanks,

> Have a spread sheet with several columns.
> Would like be able to hit a key (i.e. Enter) to return to next row and
[quoted text clipped - 3 lines]
>
> L.

Reply to this Message

David McRitchie - 04 May 2006 05:14 GMT

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

Signature

---
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

> Moving to another group.
> Thanks,
[quoted text clipped - 6 lines]
> >
> > L.

Reply to this Message

Gord Dibben - 05 May 2006 20:43 GMT

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

Gord Dibben MS Excel MVP

>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
[quoted text clipped - 3 lines]
>
>L.

Reply to this Message

L... - 06 May 2006 03:47 GMT

Thanks for all the suggestions.

L.

> Tab, Tab, Tab, Enter will move you down one row and back to original
> column.
[quoted text clipped - 9 lines]
>>
>>L.

Reply to this Message