+ Reply to Thread
Results 1 to 6 of 6

How to jump between Columns and Rows

  1. #1
    Registered User
    Join Date
    07-11-2010
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    8

    How to jump between Columns and Rows

    Q1: Could you show me how to jump between columns (ex. from C7 jumps to F7) in a worksheet to protect the formula within that cell (D7 and E7)?

    Q2: if we hit the enter key its goes down to the next row/cell, is there a ways to make it jump to the next column/cell using the enter key instead of the arrow right key?

    Q3: lastly, if I reach my last cell w/c is G7 in my worksheet (ex: G7 column) is it possible to make it jump back to A8 (then to A9, A10.. and so on) ready for a new record.?

    It will easier for us users to move between cells if you could help us find the the answers for our 3 questions.

    Thank you.
    Last edited by mar_t; 07-30-2010 at 01:29 AM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: How to jump between Columns and Rows

    Q1, Q3: Unlock only the cells that you want people to type data directly into, then protect the worksheet.
    Q2: Tools > Options > Edit ==> Move selection after enter [your selection]...
    Ben Van Johnson

  3. #3
    Registered User
    Join Date
    07-11-2010
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: How to jump between Columns and Rows

    Q2: solved
    Q1 and Q3: I tried but AutoFilter doesn't work after, I had to unprotect to use autofilter.

    I did some web searching and i found this code (see below), I just replaced C and D to I and J and it works perfectly! I want to include the following columns also L, M, O, Q, S and T into the code but I'm not a programmer. Please help.

    thank you.


    Please Login or Register  to view this content.
    Last edited by mar_t; 07-22-2010 at 01:57 AM.

  4. #4
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: How to jump between Columns and Rows

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    07-11-2010
    Location
    Manila
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: How to jump between Columns and Rows

    protonLeah,
    I copied your code and paste it on my worksheet (click on my worksheet and select View Code ) and test it, however it did not skip the columns.

    Please help, I might have done it the wrong way.

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: How to jump between Columns and Rows

    It works for me. All columns listed are skipped.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1