×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Excel Question...

Excel Question...

Excel Question...

(OP)
I have some spread sheets that I use on a daily basis in Excel. I have to enter numbers
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

RE: Excel Question...

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.


techsupportgirl@home.com

RE: Excel Question...

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

RE: Excel Question...

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.

RE: Excel Question...

If you highlight the range you're going to be in, you can tab from "H10" to "A11." Say you highlight a range from A1 to C10.  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...  

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close