Tab Stops In Excel (JTurke) wrote:
I am a new user and I created an Excel document that I want to use as a form.
Some of the cells have a default text that I do not want to change (for
example: "ADDRESS"). Other cells are empty where I would like to type in
info. Is there a way to select the cells in a specific order so that when I
press the TAB or ENTER key(s) the cursor will move to a cell where I would
like to type rather than simply to the next cell?

Select the entire sheet and then Format / Cells / Protection. Make sure
"Locked" is checked and then click OK.

Now select all of the cells into which you would like to be able to enter
information. If they are not all connected to each other, select the first
range, then hold down the "Ctrl" key and continue to select additional ranges.

Next, Format / Cells / Protection and un-check "Locked".

Finally, Tools / Protection / Protect Sheet and check all the things you want to
do, making sure that "Select locked cells" is un-checked.