Tabbing from cell to cell

[Guest]

I need to be able to tab from a certain cell to the next and so on in order.
I understand that I should hold control, and click on the cells in the order
I need to move through them. Then, I press ctrl+F3 and give a name to the tab
order. What next? How do I call back that tab order to use when I open up a
specific document?

Thanks!

 

[Myrna Larson]

Once you've set up the name, then you press CTRL+G and type in the name of the
range. This will select the cells. (Or type the name of the range in the
"Name" box at the left end of the formula bar.)

 

[Guest]

Is there a way to prevent the cells from continuing to cycle within the
selection?
Thanks!

 

[Guest]

Better yet, is there a way to completely block a cell from being tabbed into
or typed in?

 

[Myrna Larson]

To do that, you have to first set the cells that the person can select to
Unlocked. You do that at Format/Cells/Protection. Then you have to protect the
worksheet (Tools/Protection/Protect sheet). Uncheck the box that allows users
to select locked cells. The options here are dependent on the version of Excel
you are using.

 

[Myrna Larson]

PS: re your 1st question, there's no way to prevent the cell selection from
looping back to the first cell.

 

[Guest]

Worked beautifully. Thanks!

To do that, you have to first set the cells that the person can select to
Unlocked. You do that at Format/Cells/Protection. Then you have to protect the
worksheet (Tools/Protection/Protect sheet). Uncheck the box that allows users
to select locked cells. The options here are dependent on the version of Excel
you are using.

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.xlFAQ0008.html