excel security

  • Thread starter Thread starter stephen
  • Start date Start date
S

stephen

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

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.
 
You must log in or register to reply here.

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

Created invoices in Excel - not working in Drive 1
alphnumeric if then statements? 3
Unprotect sheet command - How do I do this? 5
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas 4
Data Validation - Complex Q 2
Cell Protection 2
resettable, over-ridable, default cell values 0

Back
Top