Is there a way to have the cursor move to next cell on the right after entering data? I am using Excel 7 and 10.
I have a row where I enter a number (minimum is 1 and maximum is 29) in a cell and then continue to the next cell on the right. I repeat this over a row of 18 cells. Then, I want to jump down to the next row (actually two rows down), and repeat the process. Then after I enter data in that row using 18 cells, I have to jump down 4 rows and repeat the process.
Simply put, I want to have the cursor move without hitting enter or arrow keys, to next cell to the right. I currently have the "enter" key set to move right in the options.
Row D8 thru L8 and then P8 thru X8
Row D10 thru L10 and then P10 thru X10
Row D14 thru L14 and then P14 thru X14
Row D16 thru L16 and then P16 thru X16
I have to repeat this process on a total of 7 identical sheets. And I am trying to avoid using the enter and/or arrow keys as much as possible to save time.
I'm guessing this may be a macro question. Since I don't have much experience with macros, I'm not sure.
Bookmarks