Excel Form / Tab to complete

  • Thread starter Thread starter Rhonda
  • Start date Start date
R

Rhonda

Is it possible to set up a worksheet so that you can Tab
from one specific cell to another in a certain order? I
put together a form and want to be able to tab to the cell
where information needs to be completed. For example, if
I start at A1 I would like to tab next to b7 then to g7
then to b9, etc., etc. Is this possible? Thanks so much.
 
One way:

Select the cells you want to change
press Ctrl-1 and choose protection and uncheck Locked
Protect your sheet

When you use your Tab key you get what you want
 
Ron,
You are the GREATEST! Thank you so much. I should have
asked hours ago and saved myself untold frustration.
Thanks again,
Rhonda
 
Rhonda

If your unlocked cells are in a left to right, top to bottom series, the TAB
key will move you through them as Ron 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...

Gord Dibben Excel MVP - XL97 SR2 & XL2002
 
Another Great Idea!! Thanks so much. I was able to get
the problem solved and tab through with the unlock cell /
protect sheet solution... however will try your method at
the next opportunity. Thanks again.
Rhonda
-----Original Message-----
Rhonda

If your unlocked cells are in a left to right, top to bottom series, the TAB
key will move you through them as Ron 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...

Gord Dibben Excel MVP - XL97 SR2 & XL2002
Click to expand...
 
Back
Top