tabbing in a pre-determined direction

[Guest]

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

 

[Jason Morin]

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

 

[Dave Peterson]

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]

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