software

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,

quot;L.quot; gt; wrote in message
...
gt; Have a spread sheet with several columns.
gt; Would like be able to hit a key (i.e. Enter) to return to next row and
gt; back to column #1.
gt;
gt; thanks,
gt;
gt; L.
gt;
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
www.mvps.org/dmcritchie/excel/event.htm#ws_sc
--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;L...quot; gt; wrote in message ...
gt; Moving to another group.
gt; Thanks,
gt;
gt; quot;L.quot; gt; wrote in message
gt; ...
gt; gt; Have a spread sheet with several columns.
gt; gt; Would like be able to hit a key (i.e. Enter) to return to next row and
gt; gt; back to column #1.
gt; gt;
gt; gt; thanks,
gt; gt;
gt; gt; L.
gt; gt;
gt;
gt;
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, quot;L.quot; gt; wrote:

gt;Have a spread sheet with several columns.
gt;Would like be able to hit a key (i.e. Enter) to return to next row and back
gt;to column #1.
gt;
gt;thanks,
gt;
gt;L.
gt;Thanks for all the suggestions.

L.

quot;Gord Dibbenquot; lt;gorddibbATshawDOTcagt; wrote in message
...
gt; Tab, Tab, Tab, Enter will move you down one row and back to original
gt; column.
gt;
gt;
gt; Gord Dibben MS Excel MVP
gt;
gt; On Wed, 3 May 2006 16:06:56 -0500, quot;L.quot; gt; wrote:
gt;
gt;gt;Have a spread sheet with several columns.
gt;gt;Would like be able to hit a key (i.e. Enter) to return to next row and
gt;gt;back
gt;gt;to column #1.
gt;gt;
gt;gt;thanks,
gt;gt;
gt;gt;L.
gt;gt;
gt;