ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you make the cursor go to a designated spot after pressing. (https://www.excelbanter.com/excel-discussion-misc-queries/110857-how-do-you-make-cursor-go-designated-spot-after-pressing.html)

Bustasinclair

How do you make the cursor go to a designated spot after pressing.
 
enter?

RagDyeR

How do you make the cursor go to a designated spot after pressing.
 
Does this old post help?

http://tinyurl.com/39vzv

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Bustasinclair" wrote in message
...
enter?



Bustasinclair

How do you make the cursor go to a designated spot after pressing.
 
I actually just need to know if you can data enter in A1,B1,C1,D1 and after
D1 you press enter and the cursor go back to A2. It may not be possible and I
need this to be done for a large range of data entry. Thanks

"Bustasinclair" wrote:

enter?


Gord Dibben

How do you make the cursor go to a designated spot after pressing.
 
Yes it is possible but using the Tab key also.

Start in A1 and Tab across to D1.

When leaving D1 hit the ENTER key and you will drop back to A2.

Rule is.......you will go back the starting column one row down.


Gord Dibben MS Excel MVP

On Wed, 20 Sep 2006 16:55:02 -0700, Bustasinclair
wrote:

I actually just need to know if you can data enter in A1,B1,C1,D1 and after
D1 you press enter and the cursor go back to A2. It may not be possible and I
need this to be done for a large range of data entry. Thanks

"Bustasinclair" wrote:

enter?




All times are GMT +1. The time now is 02:21 AM.

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