Tabs

  • Thread starter Thread starter dyowell
  • Start date Start date
D

dyowell

I have developed a small price quote form in Excel. I
would like to be able to make it so that when I press the
tab key, the only areas that the cursor goes to are areas
that the user will enter information into. In other
words, I would like to make the unused cells on the form,
unavailable. I am not a programmer or anything, so if
anyone knows a way to explain this to me so that I can
understand it, I would appreciate it. Thanks.
 
You can protect a worksheet, and leave a few cells unlocked for people
to type in.

First, to unlock the cells for typing --
Select the cells in which users will enter information
Choose Format>Cells
Select the Protection tab
Remove the check mark from Locked
Click OK

Next, protect the worksheet --
Choose Tools>Protection>Protect Sheet
Select the options you want, and enter a password if you want one
Click OK
 
Back
Top