View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Angela Angela is offline
external usenet poster
 
Posts: 85
Default Moving between cells

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?