Excel Security | How to lock cells in excel

How to Keep my excel secured? Excel Security To lock cells 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 | Excel Security:

  1. Select the cells that you want to lock.
  2. Go to Home Tab > Cell group and click on Format.
  3. Select Lock Cell under the protection tab.
    how to lock excel
  4. Again go to Cell group and under Format, select Protect Sheet and then enter the password to unlock.
    Home-format-Protect-sheet-Excel-Security
  5. You can get the option of Protect Sheet from the Review Tab of the bar as well. Rest of the procedure remains the same.
Excel Security
Excel Security

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:

  1. Select the cells that have formula based result
  2. Go to Cell group on the bar and select Format
  3. Select Format Cells from the dropdown list.
  4. Tick the Hidden option in the dialogue box and click on

Hiding-Formulas-Excel-Security

Read More: Learn How To Use Excel Online with Basic Steps Free Course Available

3. Using Selective Lock:

Here is a very simple way of managing excel security or lock cells in excel.

  1. Go to the Cell group in the bar and select

  2. From the drop-down list, select Protect Sheet
  3. 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.

Use-Selective-lock-Excel-Security

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.

  1. Click on Review tab and select Protect Workbook option
  2. A dialogue box will appear, tick Structure option
  3. If you want a stringent control and prevent other users from removing workbook protection, define a password for it as well.

Protect-workbook-structure-Excel-security 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:

  1. Click on the File tab and then select Options.
  2. Select Trust Center button and choose Privacy options.

Sharing-locked-workbook-excel-security

  1. Under Document Specific Settings, uncheck Remove Personal Information from File Properties on Save and then select Ok.

Document-Specific-settings-Excel-Security 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.

Review-tab-protect-and-share-workbook

“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.

If your file is password protected, you can check our Remove password from excel tutorial. Which will help you to unprotect your excel File.

Related Tutorials

Delete Duplicate in Excel or Remove Duplicate in Excel
November 9, 2018
Excel Formulas PDF
September 6, 2018
How To Lock Cells in Excel | Unprotect Excel
August 13, 2018
4x Faster at Excel
August 6, 2018
Separate Content of One Excel Cells into Separate Columns
August 3, 2018
How to Transpose Excel Columns to Rows | Paste Special Method
July 26, 2018
How to create sparklines in Excel
July 19, 2018
AutoSum in Excel with Shortcut
July 17, 2018
OFFSET Function in Excel
July 6, 2018
Strikethrough Shortcut in Excel & Word
July 4, 2018
INDIRECT Function with SUM, MAX, MIN & Independent Cell Value
June 29, 2018
Pivot Table Slicers In Excel
June 12, 2018
How to Split Cells in Excel using Text to Column
June 7, 2018
How to Wrap Text in Excel Automatically and Manually
June 6, 2018
How to Hide/Unhide Column in Excel
June 5, 2018
Highlight row based on cell value
June 4, 2018
Learn how to remove blank cells in Excel
June 3, 2018
How to Group Numbers, Dates & Text in Pivot table in Excel
June 1, 2018
5 Powerful Tricks to Format cells in Excel
May 31, 2018
Insert a Picture into a Cell in Excel
May 25, 2018
What is ISFORMULA Function and FORMULATEXT Function
May 21, 2018
How to Use SUBSTITUTE Function
May 21, 2018
Excel Quartile Function in Excel
May 8, 2018
How to use the Excel PERCENTILE function
May 7, 2018
Insert or Type degree symbol in Excel with Autocorrect Feature
May 7, 2018