V
Vimal
I want the Tab to go to only few desired fields on a sheet. The fields can be
selected like C2, D10 or F32 etc.
How can I achieve this ?
selected like C2, D10 or F32 etc.
How can I achieve this ?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Debra Dalgleish
You could select those cells, and unlock them (Format>Cells, Protection tab)
Then, protect the worksheet (Tools>Protection>Protect Sheet
When you press the Tab key, you'll move to the next unlocked cell.
Then, protect the worksheet (Tools>Protection>Protect Sheet
When you press the Tab key, you'll move to the next unlocked cell.
G
Gord Dibben
If your cells are in a left to right and top to bottom order, see Debra's
answer.
If in a random order.................
You can use a named range to "jump" through in any order you design.
Select SECOND cell then CTRL + click on each succeeding cell in sequence, ending
up with the cell you want to start at.
Insert>Name Define........give your range a name and OK.
In namebox select the name and the cells will be highlighted in the order you
want.
Just type and hit ENTER key to go to next cell.
Note: there are limitations on the number of cells in a range.
See Bob Phillips' site for more help on this.
http://www.xldynamic.com/source/xld.xlFAQ0008.html
There is a VBA method if you choose. Post back for that.
Gord Dibben MS Excel MVP
answer.
If in a random order.................
You can use a named range to "jump" through in any order you design.
Select SECOND cell then CTRL + click on each succeeding cell in sequence, ending
up with the cell you want to start at.
Insert>Name Define........give your range a name and OK.
In namebox select the name and the cells will be highlighted in the order you
want.
Just type and hit ENTER key to go to next cell.
Note: there are limitations on the number of cells in a range.
See Bob Phillips' site for more help on this.
http://www.xldynamic.com/source/xld.xlFAQ0008.html
There is a VBA method if you choose. Post back for that.
Gord Dibben MS Excel MVP
J
John A
Debra Dalgleish said:You could select those cells, and unlock them (Format>Cells, Protection tab)
Then, protect the worksheet (Tools>Protection>Protect Sheet
When you press the Tab key, you'll move to the next unlocked cell.