Protect Cells

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?
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how to navigate through unprotected cells only in a worksheet 2
Protect Cells 10
How do I protect a number of sheets allowing the user to add a com 8
Copying in sheet with protection with the use of a macro 5
VBA code to protect cells Outside a given range 2
Protecting only cells with formulas 2
Excel VBA to move cells to sheet2 based on selection in sheet1 0
How do you password protect a single cell or column of cells 3

Top