tabbing in a pre-determined direction
 

Can I tell Excel where I want it to tab to? I have locked cells and when I
tab to the next field I want to tell it which field to go to next.
Thanks,
PatS

Try this:

1. While holding down the Ctrl key, click on the cells one
by one in the pre-determined direction.
2. Click on the name box in the upper left-hand corner
(where you see a cell reference), type in a name
like "myrng", and press Enter.
3. Go to Format Cells and unlock the cells.
4. Go to Tools Protection and protect the sheet.
5. You can now click on the name "myrng" from the name box
and tab through your cells.

HTH
Jason
Atlanta, Ga

-----Original Message-----
Can I tell Excel where I want it to tab to? I have locked
cells and when I
tab to the next field I want to tell it which field to go
to next.
Thanks,
PatS
.

Gord Dibben suggests starting your selection with the second cell. And making
the cell you want to start with, the last cell in the selection.

Then when you select "myRng", you'll be in that first cell.



Jason Morin wrote:

Try this:

1. While holding down the Ctrl key, click on the cells one
by one in the pre-determined direction.
2. Click on the name box in the upper left-hand corner
(where you see a cell reference), type in a name
like "myrng", and press Enter.
3. Go to Format Cells and unlock the cells.
4. Go to Tools Protection and protect the sheet.
5. You can now click on the name "myrng" from the name box
and tab through your cells.

HTH
Jason
Atlanta, Ga

-----Original Message-----
Can I tell Excel where I want it to tab to? I have locked
cells and when I
tab to the next field I want to tell it which field to go
to next.
Thanks,
PatS
.


--

Dave Peterson

Gord's right. I should have tested more thoroughly.

-----Original Message-----
Gord Dibben suggests starting your selection with the
second cell. And making
the cell you want to start with, the last cell in the
selection.

Then when you select "myRng", you'll be in that first
cell.



Jason Morin wrote:

Try this:

1. While holding down the Ctrl key, click on the cells
one
by one in the pre-determined direction.
2. Click on the name box in the upper left-hand corner
(where you see a cell reference), type in a name
like "myrng", and press Enter.
3. Go to Format Cells and unlock the cells.
4. Go to Tools Protection and protect the sheet.
5. You can now click on the name "myrng" from the name
box
and tab through your cells.

HTH
Jason
Atlanta, Ga

-----Original Message-----
Can I tell Excel where I want it to tab to? I have
locked
cells and when I
tab to the next field I want to tell it which field to
go
to next.
Thanks,
PatS
.


--

Dave Peterson
.