tab down instead of across

[Guest]

Can I make the tab key in a protected spreadsheet move a cell down in a
instead of across? I cannot use VBA/programming though...or alternatively,
can i set the order of unlocked cells in a protected sheet?

 

[Ragdyer]

There is another way to set the cell order for data entry.

The sheet does *not* have to be protected with this procedure.

Check out this old link:

http://tinyurl.com/39vzv

 

[Guest]

Much appreciated, however the data is much much greater than the 46 cells
limit for this option....

 

[RagDyeR]

Didn't the last line of the link say:
<<<"If you try more, and run into a problem, post back for work-arounds.">>>
<bg>

Well ...
Here's a simple work-around by Dave Peterson to by-pass the limit:

http://tinyurl.com/ypk2j


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Much appreciated, however the data is much much greater than the 46 cells
limit for this option....