Unlock Specific Cells in Excel

Question

How do I unlock specific cells in Excel?

Answer

 There is a way to have certain cells unlocked in our Excel workbook.

The entire workbook will be unprotected when you start out. We can then edit specific cells you would like to have protected. When you protect the worksheet, no one else can edit that worksheet.
 
To protect your worksheet select Protect Worksheet under the Review tab. After selecting this option the Protect Sheet window will appear. From there you can choose the options you with to protect.

For more information about Charts and Graphs in Excel, please view the full tutorial from the CTL here: Excel Part 2

If you need further assistance, please click the CTL Support Request button on this page.

CTL Support Request

Details

Article ID: 7922
Created
Thu 12/29/22 11:34 AM
Modified
Fri 11/3/23 3:52 PM
KCS Article Status
WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance
Validated

Related Services / Offerings (1)

CTL Support Request
The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.