ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   Move to next row?? (https://www.excelbanter.com/setting-up-configuration-excel/86692-move-next-row.html)

L.

Move to next row??
 
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.



L...

Move to next row??
 
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.




David McRitchie

Move to next row??
 
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.






Gord Dibben

Move to next row??
 
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.



L...

Move to next row??
 
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.






All times are GMT +1. The time now is 09:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com