Z Zoey New member Apr 10, 2026 #1 I’m working on a spreadsheet and want to prevent certain cells from being edited. I tried protecting the sheet but it’s confusing. Can someone explain how to lock cells in Excel step by step?
I’m working on a spreadsheet and want to prevent certain cells from being edited. I tried protecting the sheet but it’s confusing. Can someone explain how to lock cells in Excel step by step?
M Mateo Member Apr 13, 2026 #2 To lock cells in Microsoft Excel : Select cells → Right-click → Format Cells → Protection → Uncheck “Locked” (for editable cells) Go to Review → Protect Sheet Set a password (optional) → Click OK Locked cells can’t be edited after protecting the sheet. Upvote 0 Downvote
To lock cells in Microsoft Excel : Select cells → Right-click → Format Cells → Protection → Uncheck “Locked” (for editable cells) Go to Review → Protect Sheet Set a password (optional) → Click OK Locked cells can’t be edited after protecting the sheet.
