Excel Question...

[ridge]

I have some spread sheets that I use on a daily basis in Excel. I have to enter numbers<br>in columns A thru H, and rows 1 thru several hundred. Is there a way to get the highlighted cell to automaticaly move down to the next row in column A after entering column H's info? Thanks

 

[Dreamboat]

Generally, if you beging typing in (for instance) A6, then type and tab through H6, after entering H6, hit enter and it should auto-return to A6. If you've got blank cells, just select (for instance) a2:H200, then start entering. All tabs should go to the next cell in the selected range, whether it's on the next row or not. <p> <br><a href=mailto:techsupportgirl@home.com>techsupportgirl@home.com</a><br><a href=

http://www.wedomanuals.com>

</a><br>

 

[ridge]

Thanks for your help Dreamboat. However, it works ok as I continue to use the same row. But I wish to simply move&nbsp;&nbsp;from one row down to the next row, and then back to column &quot;A&quot;. Example: I wish to move from cell # H10 to cell # A11. When i hit &quot;TAB&quot;, I move one cell to the right. When I hit &quot;Enter&quot;, I move one cell down, but not to column 'A&quot;. You mentioned to select the cells?...How do I do that?...<br>Thanks again...

 

[dsi]

You could also write a small VBA routine to monitor cell activity. Then, whether you move down a row or leave column H, the program can set focus to column A on the next row.

 

[BigDgiB]

If you highlight the range you're going to be in, you can tab from &quot;H10&quot; to &quot;A11.&quot; Say you highlight a range from A1 to C10.&nbsp;&nbsp;You start entering data at address A1, then tab through the row entering data. When you reach A10, then tab, you will move to B1, as long as the range remains highlighted during your data entry...&nbsp;&nbsp;