Hi,

The only way to do what you requested is to use VBA. Why? Because the other
answer you were given does not move the cursor in "a specific order" it moves
them in to order Excel is pre-designed to. In other words if you have the
range A1:A5 unlocked in a protected spreadsheet .
If you want the cursor to move in this order, it won't
A3--A1--A5--A2--A4
If you start in A1 and press Tab the cursor will always move to A2. If you
press Enter in A1, of this example, the cursor will move to A2. To go in any
non-standard order you must program Excel. To do that we would need the
"specific order" you want to move through the range.

--
Thanks,
Shane Devenshire


"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?