Moving between cells

A

Angela

I want to protect some cells and be able to move between other cells that are
not side by side by pressing tab. Is there a way to do this?
 
M

Mike H

Angela,

Select all the cells you want to tab between by holding down CTRL and
clicking on each one.

Then. Format|cells|protection and remove the locked checkmark.
Then. Tools|protection and protect the sheet.

Tab away between unlocked cells.

Mike
 
A

Angela

I should have been more clear with my question. I have a spreadsheet and I
want the client to fill out information in one row, then move down two rows
and fill in the blanks vertically down a column and then go over two columns
and fill out more information vertically in that column with them only having
to press tab and it moving vertically down the column.
 
R

Ragdyer

You might be interested in an old procedure where using a "named range" will
make the focus in a range of cells move to the next *pre-selected* cell,
following the exact route established at the time of range creation.

Check out this link to an old post:


http://tinyurl.com/39vzv
 
Top