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?

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

"Angela" wrote:

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?

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.



"Mike H" wrote:

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

"Angela" wrote:

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?

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


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------



"Angela" wrote in message
...
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.



"Mike H" wrote:

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

"Angela" wrote:

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?

Try this link:

http://tinyurl.com/2gzlwp
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ragdyer" wrote in message
...

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


--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-



"Angela" wrote in message
...
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.



"Mike H" wrote:

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

"Angela" wrote:

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?