How to Lock Cells in Excel to Protect your Formulas & Only Allow Input where Needed

Ever created this perfect shared Excel template only to come back to a total disaster? Collaborating on shared spreadsheets can be painful. But it doesn't have to be that way! In this video I'll show you how you can lock and unlock any cell, or a whole range of cells, to keep your work protected. This way you'd be able to protect your formula cells and allow people to only input in specific ranges or cells. I'll also show you a cool Excel trick which allows you to multi-select cells based on their color and then lock those cells only.

Category