{"id":73992,"date":"2014-10-03T04:00:03","date_gmt":"2014-10-03T02:00:03","guid":{"rendered":"http:\/\/onsoftware.en.softonic.com\/?p=73992"},"modified":"2025-07-02T00:26:14","modified_gmt":"2025-07-02T07:26:14","slug":"office-tip-how-to-freeze-and-lock-multiple-excel-cells","status":"publish","type":"post","link":"https:\/\/cms-articles.softonic.io\/en\/office-tip-how-to-freeze-and-lock-multiple-excel-cells\/","title":{"rendered":"Office Tip: how to freeze and lock multiple Excel cells"},"content":{"rendered":"

Freeze and lock Excel cells: <\/strong>If I had to choose only one tip for Microsoft Excel<\/a>, I would probably recommend this one. It’s very handy for sharing spreadsheets without having to worry about any accidental modifications.<\/p>\n

In Microsoft Excel<\/a>, 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<\/strong> happens way too often. Secondly, it allows you to share spreadsheets<\/strong> with colleagues, associates or friends, without worrying about information getting changed.<\/p>\n

Here’s how to protect your data in Excel:<\/p>\n

1.<\/strong> When your Excel document is completed and ready to be shared, go to the Review<\/em> tab and select Protect<\/em> Sheet<\/em>.<\/p>\n

\"Review<\/p>\n

2.<\/strong> In this new window, you need to set a password to secure the document. This is also where you manage the permissions<\/strong> for users of the document.<\/p>\n

For example, you can allow users to: add columns to the document, insert hyperlinks, and so on.<\/p>\n

\"Protect<\/a><\/p>\n

3. <\/strong>Excel will ask you to enter a password <\/strong>and then re-enter it to confirm.<\/p>\n

\"Confirm<\/p>\n

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.<\/p>\n

4.<\/strong> If you try to change the content of the document afterwards, Excel displays a notification on the screen.<\/p>\n

\"Protected<\/a>
\nTo unfreeze the document, you need to click on Unprotect<\/em> Sheet<\/em> under the Review<\/em> tab. You will need to type in your password.<\/p>\n

5.<\/strong> One last tip: if some of your colleagues need to modify only a few Excel cells<\/strong>, you can manually unlock the boxes.<\/p>\n

Before you lock the spreadsheet in step 1, click on the cell you want to make editable while holding down the Control<\/em> key. Then right-click and choose Format<\/em> Cells<\/em>.<\/p>\n

\"Format
\n
\n6. <\/strong>Unlock the cell by unchecking the Locked<\/em> box.<\/p>\n

\"Protection<\/p>\n

7.<\/strong> 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<\/strong>.<\/p>\n

Related Articles<\/h3>\n

Office Tip: how to type multiple lines in an Excel cell<\/a><\/p>\n

Office Tip: type faster by replacing one word with another<\/a><\/p>\n

Office Tip: access your Word, PowerPoint and Excel documents online<\/a><\/p>\n

Office Tip: use tabs in Word, Excel and PowerPoint<\/a><\/p>\n

Office Tip: Restore or minimize the Ribbon interface in Word and Excel<\/a><\/p>\n

Originally published in French <\/a>on Softonic FR<\/a>.<\/em><\/p>\n

Follow me on Twitter:<\/em> @bbrassart<\/em><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

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 … Continue reading “Office Tip: how to freeze and lock multiple Excel cells”<\/span><\/a><\/p>\n","protected":false},"author":2043,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","wpcf-pageviews":1},"categories":[2441],"tags":[],"usertag":[],"vertical":[],"content-category":[],"class_list":["post-73992","post","type-post","status-publish","format-standard","hentry","category-how-to"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t