Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Sep 2006
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    selecting certain cells for data (Excel)

    For work I am making a form, and I want to be able to push Tab and go to the next cell that needs to be filled out. I dont want to tab through every single cell. Is there a way to do this?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: selecting certain cells for data (Excel)

    Move between unlocked cells on a protected worksheet.

    Highlight the cell that you want to tab between, select

    1) Format | Cells
    2) Click protection Tab
    3) Untick Locked
    4) Press OK

    Now

    1) Tools | Protection | Protect Sheet

    Job jobbed
    Jerry

  3. #3
    New Lounger
    Join Date
    Sep 2006
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: selecting certain cells for data (Excel)

    Ok thanks! You helped a lot! I got it to work!

Posting Permissions

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