Lock cells in Excel without the Format Cells routine
The standard way to lock cells in Excel takes four trips through the menus. Select the whole sheet and clear Locked in Format Cells, use Go To Special to find the formulas, lock just those, then switch on Protect Sheet. Do it on every tab, and do it again whenever someone sends a new version. Miss the first step and the whole sheet is frozen; miss the last and nothing is protected.
XLSX Locker turns that into one picture. Load a workbook and the sheet appears as a grid: red cells will be locked, green cells stay open for typing, and each formula is found for you, with a count of how many there are across all sheets. Cells the workbook already left unlocked start out green. Choose the Unlock cells or Lock cells brush and drag over the grid to adjust. A line under the grid reads, for example, 38 formulas locked · 120 cells open, and nothing is written until you press Protect workbook.
How to lock formulas in Excel but allow data entry
This is the most common reason people search for cell locking: a budget, a quote calculator or a timesheet where others should fill in numbers but never overwrite the totals.
- On the Protect formulas tab, choose the workbook.
- Leave Lock every formula on. It is the default, and it keeps formula cells locked even inside a range you paint open.
- Paint the input cells green with Unlock cells, or use Unlock the whole sheet and then lock just a few.
- Under Sheets, choose All sheets, only the sheets that contain formulas, or a single one.
- Optionally type a Password to change the locked cells, then press Protect workbook.
Sheet protection vs. a password to open
These two are often confused. Sheet protection controls who can type where; anyone can still open the file and read every value, and the protection can be stripped by someone determined. It prevents accidents, not snooping. Password to change the locked cells is that kind of protection.
A password to open is a different thing: the file is encrypted, so without the password it shows nothing at all. Use both together for a template that only accepts input in the right cells, inside a file only the right people can open.
Password protect multiple Excel files at once
The Lock or unlock files tab handles batches. Drop several workbooks, or a folder to add every workbook directly inside it, type a password and choose Lock or Unlock. Each row shows its own status while the batch runs, Wrong password included, so a single bad file does not stall the rest.
Copies get a label in the name, so a folder of workbooks locked for a shared drive is easy to tell apart from the working originals sitting beside them.
