Locking down a spreadsheet

  • Thread starter Thread starter DavidLilley
  • Start date Start date
D

DavidLilley

I have created a spreadsheet for colleagues at work to use but I do not want
them to be able to alter the formulae or the format - how do I still allow
them to enter data but not change anything??
 
You want to check out Tools|Protect,Protect Sheet.
You will have to Unlock the cells you want people to be able to edit.
You can do this by se3lecting the cells you want people to edit, and then
going to Format|Cells. On the Protection Tab, Remove the Check for locked.

tj
 
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

Locking a format 1
Locking columns 3
Lock location of sheet within a spreadsheet 4
Protecting a Sheet 7
Locking down propriety spreadsheets 5
Spreadsheet is locked??? 2
copy cells but lock editing 5
Lookups - how to obtain data from a master spreadsheet into another 5

Back
Top