Offistart - Virtual Offices, Office Space, Business Support Services
*Home>>>Shared Offices

In MS Excel, how can I set the tab key to go to specific cells?


I have a shared worksheet that my office uses. I have protected all the cells except the ones I want data added to. Essentially, it's a form we fill out.
I was wondering if there is a way to select which cells the tab key will navigate to. I would like to be able to fill in one "blank" and tab the next.
Any help would be greatly appreciated. Thank you,

Steve

At the top, choose Tools / Protection / Protect Sheet

When the "Protect Sheet" window appears, deselect the check box next to "select locked cells"
This will prevent a user from even selecting cells that are locked. It will ONLY allow the tab key to jump between unlocked cells.

I think this is what you want (control + G)
http://www.baycongroup.com/el3.htm

Tags
  Offices to Lease   Rent Offices   Business Centers   Service Offices   Branch Offices   Temporary Offices   Shared Offices   Commercial Space   Office Space   Business Services   Business Address   Call Forwarding
Related information
  • Please help me-problem at work?

    this is obviously going to be quite a hurdle in a job like yours, i'd start by getting more comfortable at using the phone at home and actually put yourself in the situation that makes you unc...

  • Were there instances of appointments to Collins submarine computerization, and associated organizations, in ..

    Probably some of all of the above...

    ...
  • Why are they so mean!!?

    They are jealous of you, they could care less, they are in menopause age and moody. It is best to totally ignore them, they are acting immature. Laugh when they make jerky remarks and give them n...

  • I just recieved an email from British national Lottery saing I have won 1.2 million British Pounds Sterling?

    This is a SCAM. Check out the below link for confirmation of several email scams including the famous Yahoo/MSN lottery scam and how to report them: ...

  • Flyer ideas for bringing in insurance business?

    I believe that any gift or 'thank you' should be related to the product or service you are advertising... The first thing that comes to my mind with the gas card idea is what is the c...

  • Is my new Youtube video funny??? (cute Beagle eating spaghetti)?

    i love it!!! i commented it. my youtube is xgiirlxinxloovex

    ...
  • Do you like sharing the written word, and getting free books?

    It is a great idea. When I take my mom to Social Services, they have a shelf there. I have picked up a couple very great books and left a few I was given that I already had. My mother's Senior...

  • I have won i million us dollar as per the australian international lottery programme is it for real?

    Well even yesterday I got an email stating that I have won the Euro Lottery. It told me to contact them. I also received a same kind of letter 2 years back. And in that letter I actually contacted ...

  •  

    Categories--Copyright/IP Policy--Contact Webmaster