Create Password protected excel file - Excel Data analysis

Protecting excel file You can prevent people from editing Locked cells or changing the from the cells, To unlock any cells or ranges that you want other users to be able to change, or access password protected excel file do the following:

Select each cell or range that you want to unlock. On the Home tab, in the Cells group, click Format, and then click Format Cells. On the Protection tab, clear the Locked check box, and then click OK.

Example.

Select All the cells.

Right Click and go to Format cells.

Following dialog box will appear go to under protection tab and Un-tick Locked.

Click OK again select the cells range that you want to Lock.

Again Right click and go to Protection and tick the locked box.

Click OK. Now go to Under Review Tab click on Protection,

Following Dialog box, Enter your password and confirm and click OK.

Now your done creating password protecting excel file.

Do you like this page..? Subscribe for news letter below. Or add follower on google plus..!!