Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    East Tennessee
    Posts
    179
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Move to next Column (Exel 2000)

    I have a sheet where I make a series (6) of entries in a column, and then repeat the entries in the next col 25 times. Everything is working as I want. I set Excel to move down afetr each entry. What I would like to do is after completing one col, move to the top of the next col.
    Can anybody give me a hint on how to do this?
    Win 8, Firefox 16.0.2, Thunderbird 15.0.2

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Move to next Column (Exel 2000)

    If you select the range of 6 rows x 26 columns, Enter will move down a column, then to the top of the next row.

    You can also use code to set the ScrollArea of a worksheet.

  3. #3
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    East Tennessee
    Posts
    179
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Move to next Column (Exel 2000)

    Thanks for your response!

    I'm not sure how you mean to use the range select.

    If I use the ScrollArea, I guess it would have to be in an Autoopen macro. Is that correct?
    Win 8, Firefox 16.0.2, Thunderbird 15.0.2

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Move to next Column (Exel 2000)

    It's hard to explain, but easy to do once you see how:

    Before you start to enter data, use the mouse to select the entire area where you want to enter data. Now, you will have an area in blue with one white cell. The white cell will receive any data that you type. If you use the Enter key to navigate, then when you get to the bottom, Enter will take you to the top of the next column. If you use the Tab key to navigate, you will go right until you reach the end of the area, then you will go back to the beginning of the next row . HTH --Sam
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

  5. #5
    2 Star Lounger
    Join Date
    Apr 2002
    Location
    East Tennessee
    Posts
    179
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Move to next Column (Exel 2000)

    Thanks!
    Like you said it's easy enough to do. I, obviously, was not aware of that feature.
    There must be thousands of other features like that which don't get much exposure.
    Win 8, Firefox 16.0.2, Thunderbird 15.0.2

  6. #6
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Springfield, Ohio, USA
    Posts
    2,136
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Move to next Column (Exel 2000)

    Another feature that I like: next time you want to "fill" a column with the formula at the top of the column, select the cell (or cells for a series) and double-click on the little box in the lower-left corner of the selected cell. Like magic, the column is filled to the length of the column on the left.
    <font face="Comic Sans MS">Sam Barrett, CACI </font face=comic>
    <small>And the things that you have heard... commit these to faithful men who will be able to teach others also. 2 Timothy 2:2</small>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •