Tip: also learn how to use Power Query and Power Pivot in Microsoft Excel.
How to Lock All Cells in a Sheet
When creating a new sheet, all cells are automatically locked. However, there are cases when the last user keeps the cells unlocked manually. Here’s how to lock all cells in a sheet:
How to Unlock All Cells in Excel
Follow these steps to unlock all locked cells in a sheet: Extra: Master VLOOKUP guide for Microsoft Excel here.
How to Lock Specific Cells in Excel
You can lock specific cells in Excel and keep other cells unlocked in the same sheet by following these steps:
How to Unlock Specific Cells in Excel
If you need to change specific cells that are locked, follow the instructions below to unlock them: Use these tips to find duplicates and remove them from your spreadsheet.
What You Can and Can’t Do when Locking Cells in Excel
What you can do:
Lock formulas in cells Choose specific cells to lock and leave unselected cells unlocked Protect your sheet and workbook with a password Lock symbols in cells
What you can’t do:
Lock cells in the Web version of Microsoft Excel Edit locked cells in a protected sheet
How to Protect a Workbook in Excel
You can lock an Excel workbook to protect it from the Insert, Delete, Rename, Move, Copy, Hide, and Unhide commands. Here’s how to protect a workbook: All screenshots by Natalie dela Vega
