Only enter in certain cells, save, and distribute

J

jeff

Hi,

Easy. Select the cells your users can enter into, go
to Menu>Format>Cells>protection tab; uncheck "locked";
click Ok. Your cells are now unlocked for editing,while
all the rest are, by default, locked. Now protect your
sheet.

jeff
-----Original Message-----
I want to send out a worksheet to a team.
I only want the team members to enter data in certain
Click to expand...
cells (will use conditional formatting to shade the cells
they need to enter)
I want to make all other cells protected/locked out.
I want the team member to save the worksheet and email it back to me.

Any thoughts on how to make on certain cells editable,
Click to expand...
protect the rest of the sheet, and have it sent back with
the data saved?
 
Top