ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Move cursor to next row (https://www.excelbanter.com/excel-discussion-misc-queries/103270-move-cursor-next-row.html)

Hank

Move cursor to next row
 
Hi, I should make my question simple this time...

I want to move cursor left from column A to G which is end of column of my
list and return to next row and start with column A again when I go left
further.

Thanks a lot for help

Hank

Excelenator

Move cursor to next row
 

If you are using Excel 2003 you can select any cell in your "list" and
click CTL-L to create a LIST. Then select Tools\Options\Edit and
toggle Move on Enter and select Right from the drop down box. Now when
you hit enter and you are in column G your "Cursor" or active cell will
becom e Cell A in the next row.


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=568492



All times are GMT +1. The time now is 06:26 PM.

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