how can i Cell Locked

M

masood

hi to all
can i cell locked. i mean when i write formula in cell, after i locke
this cell no body delete or over write in this cell. i think
understand my point. my english is very poor Plz help me

thanks
masoo
 
A

Ardus Petus

Select all cells that CAN be changed
Format>Cell>Protection, uncheck Locked
Tools>Protection>Protect sheet

Default value for cell protection is Locked

HTH
 

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

Excel - Wich Function should I use? 1
Drop down list control value in vba 2
New computer, how do i move outlook 365 ENTIRELY? 0
loop through rows 2
Help Needed ... Probably simple for you gurus ... locking cell afterdata entered and 1
Lock Cells with Hyperlink 3
Password protecting multiple pages, and then some. 7
Lock CELLS 2

Top