How to lock cell

S

Spencer101

Moideen;1599749 said:
Hi,

How to lock a particular cell without locking the whole work sheet

Pls help me.
Click to expand...

Do you mean have one particular cell that cannot be updated/altered bu
the rest can?

Or do you mean have a locked cell but without protecting the work sheet
 
G

Gord Dibben

By default all cells on a sheet are locked when the sheet is
protected.

Select all cells(CTRL + a...........twice in Excel 2003) then go to
format>cells>protection and unlock all.

Now select just the cells you want locked and mark them as locked.

Protect the sheet.


Gord
 
M

Moideen

Spencer101;1599757 said:
Do you mean have one particular cell that cannot be updated/altered bu
the rest can?

Or do you mean have a locked cell but without protecting the work sheet?
Click to expand...

Yes, I mean have a locked cell but without protecting the work sheet
 

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

Access Lock File .LACCDB / Now shows as a notepad file 0
Place picture in Excel cell 0
Someone knows how to add hyperlinks to hours to schedule an appointment? 0
Format column widths from one table to a separate table on same page 1
Cell data entering slow! 0
Cell Auto Lock After Entering 1
Cumulative formula for word table 0
Lock Row (A~F) based on criteria in g 1

Top