How to lock cells in excel? while Maintaining the integrity of an excel file that has to be shared with peers is a challenging job? Earlier versions of MS excel had a password feature but they were widely criticized because they were pretty easy to crack. However, the latest versions have fortified the security and password features to protect your file from external attacks and alterations. In this feature, we will run you through some super simple tips on password setups and improve excel security.
1. How to lock cells in excel:
- Select the cells that you want to lock.
- Go to Home Tab > Cell group and click on Format.
- Select Lock Cell under the protection tab.
- Again go to Cell group and under Format, select Protect Sheet and then enter the password to unlock.
- You can get the option of Protect Sheet from the Review Tab of the bar as well. Rest of the procedure remains the same.
Challenge ONLY4U: Solve this Channel and get scored, how well you know excel. CLICK HERE
2. Hiding the Excel Formulas From Cell:
If you want that the formulas that you have inserted should remain hidden and protected then follow these easy steps:
- Select the cells that have formula based result
- Go to Cell group on the bar and select Format
- Select Format Cells from the dropdown list.
- Tick the Hidden option in the dialogue box and click on
3. Using Selective Lock:
Sometimes you may have to share a file that allows the user to only input data. In other scenarios, you should be able to let them only delete them.
Here is a very simple way of managing excel security or lock cells in excel.
- Go to the Cell group in the bar and select
- From the drop-down list, select Protect Sheet
- A dialogue box will open which will give you an option of choosing various rights for the users and you can check them according to your need.
4. Protecting Workbook Structure
Instead of the worksheet and its elements, if it is the entire workbook that you are looking to secure then excel provides that option as well. Just follow these simple tips and guiding images.
- Click on Review tab and select Protect Workbook option
- A dialogue box will appear, tick Structure option
- If you want a stringent control and prevent other users from removing workbook protection, define a password for it as well.
This tip will not allow viewing hidden columns, adding, deleting or moving worksheets and showing source data for pivot tables thereby improving excel security.
5. Sharing locked Workbook- Improving Excel Security:
When you have locked or protected the sheet, sharing has to be enabled. When you click on the share workbook on a file with locked sheet a dialogue box appears to tell you that you need to change the setting to enable sharing. The steps are as follows:
- Click on the File tab and then select Options.
- Select Trust Center button and choose Privacy options.
- Under Document Specific Settings, uncheck Remove Personal Information from File Properties on Save and then select Ok.
Now you can freely share the workbook. But, if you still want to exercise control with respect to the content. Then select Protect and Share workbook option in Review.
In the resulting dialog box, you have an option of giving Password as well as tracking changes.
“Password and Security in Microsoft Excel”, do share it with your friend and colleagues. It will help them learn how to lock cells in excel. Want to learn more about Excel? Check out yodalearning’s effortless Advanced Excel Tutorials and also the impressive Free online Excel Courses.