Add Password to Open Excel File
Lock Data in Excel by adding a password to your excel files. To protect your data in excel a password can be added very easily in just 3 steps
- Click on Review Tab
- Click on Protect sheet
- Enter a password of your choice
That’s it !
Excel also allows you to make some cells editable so what that means Is that except for a few cells in excel sheet all the other cells will be uneditable. Now that’s awesome and but how do we keep some cells editable and lock all other cells, well that can be done in 4 steps
- Select the cells which you want to keep as editable
- Click on the small arrow at bottom right hand corner of the Font Section on the Home Tab
- Click on the Protection tab
- Uncheck the Locked box
Now when you protect the Excel sheet with password all the cells would be locked except the ones that you want to be editable.
You can download the training practice file from www.myelesson.org