ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   need enter key to move to the next column beginning (https://www.excelbanter.com/excel-worksheet-functions/58786-need-enter-key-move-next-column-beginning.html)

j pantozzi

need enter key to move to the next column beginning
 
I know how to change the direction up down left right but I need it to go
back to column A next row.

RagDyeR

need enter key to move to the next column beginning
 
Simplest way is to use <Tab to move your cursor (focus) right, then hit
<Enter after the last data entry, which *automatically* moves the focus to
the cell *under* the first cell that you used <Tab on.

So, if you start in A10, and tab across to K10, hitting <Enter brings you
to A11.

Start in J100, and you'll be brought back to J101.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"j pantozzi" <j wrote in message
...
I know how to change the direction up down left right but I need it to go
back to column A next row.



j pantozzi

need enter key to move to the next column beginning
 
Maybe I said it wrong. In the past every time I press enter the cell that it
goes back to ir the next row column A In other words it will go from column
F4 to A5.

I am a novice at this but this is confounding me.

"RagDyeR" wrote:

Simplest way is to use <Tab to move your cursor (focus) right, then hit
<Enter after the last data entry, which *automatically* moves the focus to
the cell *under* the first cell that you used <Tab on.

So, if you start in A10, and tab across to K10, hitting <Enter brings you
to A11.

Start in J100, and you'll be brought back to J101.

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"j pantozzi" <j wrote in message
...
I know how to change the direction up down left right but I need it to go
back to column A next row.





All times are GMT +1. The time now is 08:25 AM.

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