How do I make a template in EXCEL

[PhilMusicM]

I just started working with EXCEL 2003. I have made a worksheet and now want
to lock only certain cells. How do I do this??

[swatsp0p]

Remember that "locking" a cell only "locks" the cell when the sheet is protected (with or without a password).

With that in mind, all cells are 'locked' by default. To prove this, open a new worksheet, select any cell and click Format>Cells and select the Protection tab. You will see the "Locked" option is checked.

Therefore, you actually need to 'unlock' cells you want users to have access to, then protect the sheet (Tools>Protection>Protect Sheet). You can choose to enter a password or just leave it blank. In the "Allow all users..." section, uncheck "Select locked cells" and click OK (re-enter password, if asked).

Now, users will only be able to select and change the 'unlocked' cells.

HTH

Bruce