Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 . |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
tabbing to pre-determined cells | Excel Discussion (Misc queries) | |||
How do I skip columns when tabbing in Exce? | Excel Discussion (Misc queries) | |||
In Excel 2000, can I change the direction of the move selection a. | Excel Discussion (Misc queries) |