Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

Register Log in
  • Congratulations IFRs on being selected by the Eng-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

feajob

Aerospace
Aug 19, 2003
159
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

Sort by date Sort by votes
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.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

K
  • Question
How to create an add-in (VB Net) and add it to SolidWorks
Replies
1
Views
2K
MintJulep
M
Trestala
  • Locked
  • Question
Looping on a single cell until I reach approximately 100% stress ratio
Replies
4
Views
1K
Trestala
Trestala
William Heath
  • Locked
  • Question
change active cell in excel
Replies
4
Views
783
IDS
IDS
Cobra17
  • Locked
  • Question
Moving to a specific tab stop
Replies
11
Views
1K
Cobra17
Cobra17
C
  • Question
InserVariable is not recognised
Replies
2
Views
1K
Denial
Denial

Part and Inventory Search

Sponsor

Back
Top Bottom