4

I want to lock the whole template/sheet except for a few cells that are to be filled manually. To lock the template I used "Tools / Protection / Protect Sheet "

I am using Excel 2003 spreadsheets. How can I do that?

0

1 Answer 1

7

The answer is to select a cell that you want to be editable, choose Format/Cells, hit the "Protection" tab, and uncheck the box that says "Locked".

Note that this will have to be done before you protect the sheet.

1
  • For choosing Format Cells we can use Ctrl+1 ;).
    – shA.t
    May 4, 2015 at 11:47

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .