Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lock only specific cells and ranges in a protected worksheet 2007

Status
Not open for further replies.

feajob

Aerospace
Aug 19, 2003
158
0
0
CA
Hi,

I would like to know how to enable cells to be edited while leaving only some cells locked. I could do this task in excel 2000, but I have difficulty to perform this task in excel 2007. I appreciate your help.

Thanks,
A.A.Y.
 
Replies continue below

Recommended for you

Isn't this much the same as always?
Select cells and press Ctrl 1.
Go to protection tab and unlock selected cells.
Under /Review\ tab on the ribbon select protect sheet/workbook.
 
Status
Not open for further replies.
Back
Top