enter?
B Bustasinclair Sep 21, 2006 #3 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
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 Sep 21, 2006 #4 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
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