excel security

S

stephen

How do I create a template that allows users to only input
data in certain cells, and not modify any others?
 
H

Harlan Grove

stephen said:
How do I create a template that allows users to only input
data in certain cells, and not modify any others?

Select the cells users may modify, run the menu command Format > Cells,
choose the Protection tab in the Format dialog, and uncheck Locked. Then run
the menu command Tools > Protection > Protect Sheet. Don't bother setting a
password. Just turning on protection will be sufficient with most users, and
it's very easy to undo passowrd protection.
 

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

Top