Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Tabing to different cells

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    Is it possible to tab to certain cells in excel.
    The reason for this is I have a layout which has Name(A5), Address(C5), Age(E5). I want to be able to press a key (Tab, F11, etc) and it move directly to the cell on the immediate right so I can fill in the answer. I have thought about a macro, but wondered if there is any other way.

    Thanks

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If you protect the sheet tab will move between unlocked cells, that would be one way. Paul

    On 2002-02-18 03:03, rstone25 wrote:
    Hi,

    Is it possible to tab to certain cells in excel.
    The reason for this is I have a layout which has Name(A5), Address(C5), Age(E5). I want to be able to press a key (Tab, F11, etc) and it move directly to the cell on the immediate right so I can fill in the answer. I have thought about a macro, but wondered if there is any other way.

    Thanks

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks, that has fixed it.

    On 2002-02-18 04:08, Paul B wrote:
    If you protect the sheet tab will move between unlocked cells, that would be one way. Paul

    On 2002-02-18 03:03, rstone25 wrote:
    Hi,

    Is it possible to tab to certain cells in excel.
    The reason for this is I have a layout which has Name(A5), Address(C5), Age(E5). I want to be able to press a key (Tab, F11, etc) and it move directly to the cell on the immediate right so I can fill in the answer. I have thought about a macro, but wondered if there is any other way.

    Thanks

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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