How do I make a template in EXCEL

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
By default, Excel locks all cells in a worksheet, but this only becomes
active when the sheet is protected. You will have to unlock all the
cells and then lock only the few that you need, and then protect the
sheet.

To do this, click the intersection of the row and column identifiers -
this will highlight all cells. Then go to Format | Cells and choose the
Protection tab. Unclick the Locked box then OK. Then select the cells
which you want to protect - if these are not in a contiguous block,
then hold the CTRL key down and click on each in turn. Then go to
Format | Cells and Protection tab again and click the Locked box then
OK.

Then go to Tools | Protection | Protect Sheet and a dialogue box will
enable you to choose the protection and decide if you want to apply a
password - if so, you will be asked to retype it (hint, write it down
somewhere so that you can remember what it is).

Now if you try to change anything in the protected cells by
double-clicking on them, Excel will not allow it and will present you
with a warning message.

Hope this helps.

Pete
 
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
 
Back
Top