Moving between cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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