Excel worksheet tab order

Excel Excel 2007
February 23, 2011 at 13:37:13
Specs: Windows XP
I made an Excel worksheet and I want to set limits to where a user is able to tab to. Ie...
The user starts in A2 and presses tab to get to B2, when the user presses the tab key again I want them to be taken to tab A3. Any Ideals? Thank you in advance for your help.

See More: Excel worksheet tab order

March 11, 2011 at 19:15:08
Do you only want them to have access to the columns A and B only??

If so, try this.. Select the range of cells that you wan them to have access cells (EX: A2:B20). Right click on one of the selected cells and Select FORMAT CELLS. Then find the "Protection Tab" and UNCHECK the box next to" Locked". Close the FORMAT CELLS box. Then we are going to protect the worksheet and/or workbook depending on whichever you wish. This method will vary depending on which version of Excel you have. If it is the 03 version, go to Tools, Protect. If it is 07+, go to the Review Tab. Once you select Protect Sheet, you should see some options or "permissions" with check boxes next to them. Here we want to DESELECT "Select Locked Cells" so that they will only be able to select the cells that we previously "unlocked".


Report •
Related Solutions

Ask Question