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

B

Bustasinclair

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
 
G

Gord Dibben

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
 
Top