Freeze and lock Excel cells: If I had to choose only one tip for Microsoft Excel, I would probably recommend this one. It’s very handy for sharing spreadsheets without having to worry about any accidental modifications.
In Microsoft Excel, locking cells of a spreadsheet has two major advantages: Firstly, by enabling this option, you won’t have to worry about accidentally changing the cells. Erasing a formula by mistake happens way too often. Secondly, it allows you to share spreadsheets with colleagues, associates or friends, without worrying about information getting changed.
Here’s how to protect your data in Excel:
1. When your Excel document is completed and ready to be shared, go to the Review tab and select Protect Sheet.
2. In this new window, you need to set a password to secure the document. This is also where you manage the permissions for users of the document.
For example, you can allow users to: add columns to the document, insert hyperlinks, and so on.
3. Excel will ask you to enter a password and then re-enter it to confirm.
All the cells in your document are now locked. Other users can’t edit the document or delete formulas by mistake. The only thing they’re able to do is copy the contents of the document and paste it into another worksheet.
4. If you try to change the content of the document afterwards, Excel displays a notification on the screen.
5. One last tip: if some of your colleagues need to modify only a few Excel cells, you can manually unlock the boxes.
Before you lock the spreadsheet in step 1, click on the cell you want to make editable while holding down the Control key. Then right-click and choose Format Cells.
6. Unlock the cell by unchecking the Locked box.
7. You can then perform steps 1, 2 and 3 to freeze the rest of the document. Your colleagues will therefore only be able to modify the data that you have previously selected.
Follow me on Twitter: @bbrassart