Protect Cells

  • Thread starter Thread starter enquirer
  • Start date Start date
E

enquirer

I have Psion Series 3MX that has spreadsheet software called Sheet. In
Sheet, I can Protect individual cells, so that another user can't alter its
content, but leave specific cells unprotected for the user to enter their
own figures.

How can I do this with Excel. I have tried, but seem to only be able to
Protect the whole sheet and not leave individual cells unprotected?
 
If referring to MS Excel workbooks/worksheets..........

By default, all cells are locked when you protect the sheet.

Select the cells you wish to leave unlocked for entry.

Format>Cells>Protection. Uncheck "locked" option.

Now tools>Protection>Protect Sheet.

If some other application...........???


Gord Dibben Excel MVP
 
Back
Top