jumping cells

  • Thread starter Thread starter sunroyal
  • Start date Start date
S

sunroyal

Is there a way to tab over or jump cells. I would like to guide the user
of an excel sheet from cells that are non adjacent so i can protect
formulas. How is this done?
 
Select the cells you want to jump over. Go to Format - Cells. Click the
Protection tab and select Locked. Then, protect the worksheet (Tools -
Protection - Protect Sheet). Now, the tab key (or Enter key will skip the
locked cells). You can also make the formulas invisible to the user by
selecting "Hidden" on the Protection tab.
 
sunroyal

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

Atom did leave out one step however. All cells are set "locked" by default.

CRTL + A to select all cells then Format>Cells>Protection>uncheck "locked".

Now select the ones you want locked and proceed per Atom.

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 XL2002
 
Back
Top