Protect/Restrict usage of a range of cells.

S

Sri Harsha

Hi,
I have a status report which i want my entire team to access and fill it.
However, it has some formulae which are being accidentally deleted by some of
them. Is there any way that i can protect a particular range of cells in a
worksheet?

Regards,
Sri Harsha.
 
D

DILipandey

Hi,

You can use the command : Tools - > Protect - > Allow User to Edit Ranges.

Here you can allow users to edit the ranges but please make sure that you
protect the worksheet before allowing them to edit.

Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
D

David Biddulph

The other option is to use Tools/ Protection/ Protect worksheet, having used
Format/ Cells/ Protection to set which cells are going to be locked when you
apply the protection to the sheet and which will not be locked.
 

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

Recover Outlook calendar entry 1
Import data from a particular cell in different excel sheets 1
Protect Only Certain Cells 2
Password Protect Specific Range Of Cells 6
Auto fit text in linked cells of a protected worksheet 1
Import values from a cell or a range of cells 0
Language of the templates 0
Hlp! Protect Cells in Dynamic Range 0

Top