Computing.Net > Forums > Office Software > cells protection in excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

cells protection in excel

Reply to Message Icon

Name: gurlie
Date: September 25, 2008 at 12:21:24 Pacific
OS: xp
CPU/Ram: 999
Product: 9999
Comment:

hi

i hav a small question. i am using office
2000 proffessional. i got an excel file that
i want to protect partially. because there
are cells which should be edited by somebody
else so i want to keep them unprotected but
protect the rest of the document. is it
possible? i know that i can either protect
the whole document or one sheet from it but i
don't know if it is possible to protect only
certian cells. i tried it with right clicking
on selected cells and chage the protection on
them, but it also requires the protection of
the sheet at least. the language is german so
i can not translate the menus exactly. can
anbody help me? thanks



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: September 25, 2008 at 12:50:28 Pacific
Reply:

Select the cells that you want others to be able to edit.

Click on Format...Cells...Protection tab.

Uncheck the Locked box

Click on Tools...Protection...Protect Sheet

Choose your options and click OK.

By default, all cells are Locked, but this has no effect until you Protect the sheet. If you simply Protect the sheet, all cells will be locked by default. However, you have the option to Unlock specific cells before Protecting the sheet so that they can be edited.


0
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: cells protection in excel

Can't change cell color in Excel www.computing.net/answers/office/cant-change-cell-color-in-excel/4723.html

Change cell color in Excel www.computing.net/answers/office/change-cell-color-in-excel/9540.html

Locking cells in Excel 2003 www.computing.net/answers/office/locking-cells-in-excel-2003/7741.html