How to set tabular order?

  • Thread starter Thread starter biben
  • Start date Start date
B

biben

Hi
I want to be able to fill in my forms in excel like this:
Is it possible to set the tabular order in excel xp to jump to
predefined cells directly and in the order I choose?

/biben
 
If you Format>Cells>Unlock the cells where you allow entry(ies) and
Tools>Protection>Protect Sheet, allowing only unlocked cells to be selected,
the cursor will travel only to the unlocked cells from left to right (US
version).

--
Greeting from the Gulf Coast!
http://myweb.cableone.net/twodays
biben said:
Hi
I want to be able to fill in my forms in excel like this:
Is it possible to set the tabular order in excel xp to jump to
predefined cells directly and in the order I choose?

/biben


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
biben

If your unlocked cells are in a left to right, top to bottom series, the
TAB(not ENTER) key will move you through them as Jim suggests.

If not in this configuration.....you can do it with a Named Range and no
sheet protection.

Assuming your range of cells to be A1, B2, C3, F4, A2, F1 for example.

Select the Second cell(B2) you want in the range then CRTL + click your way
through the range in the order you wish, ending with the First cell(A1). Name
this range under Insert>Name>Define>OK.

Now click on NameBox(top left corner above row 1 and col A), select the range
name to highlight the range. With these cells selected, you can input data
and Tab or Enter your way through the range in the order you selected.

Note: there is a limit of about 25 - 30 cells to a range using this method due
to a 255 character limit in a named range. Longer sheet names will reduce the
number of cells considerably.

If more needed, you can enter them manually in the "refers to" box.

From Debra Dalgleish.....
The limit is 255 characters in the Name definition. For example, I can
define a range of 46 non-contiguous cells, with the following string:

=$B$2,$D$2,$F$2,$H$2,$J$2,$B$4,$D$4,$F$4,$H$4,$J$4,$B$6,$D$6,$F$6,$H$6,
$J$6,$B$8,$D$8,$F$8,$H$8,$J$8,$B$10,$D$10,$F$10,$H$10,$J$10,$B$12,$D$12,
$F$12,$H$12,$J$12,$B$14,$D$14,$F$14,$H$14,$J$14,$B$16,$D$16,$F$16,$H$16,
$J$16,$B$18,$D$18,$F$18,$H$18,$J$18,$L$3
Click to expand...

There is another method which involves VBA worksheet_selectionchange event if
you want that.

Gord Dibben XL2002
 
Back
Top