How To Lock Excel Cells With Password

Navigate through file to info section.

How to be flirty with a girl over text. Select the cells you want to lock. You can lock cells in excel or lock specified cells in excel as per your wish. The password is optional.

On the right side select the protect workbook box the one with a lock and key icon. Lets see how we can lock cells in excel. Now that your boss is done with the workbook you can lock these cells.

Make sure that you choose a password that is easy to remember because if you lose the password you wont have access to the protected. If you do not supply a password any user can unprotect the sheet and change the protected elements. Step 3 enter a password which is optional and choose from the list of options that will still be available for users even after the sheet is protected.

Go to protect sheet. To avoid modifications ms excel 2016 and its earlier versions let you lock cells in ms excel. Before you enabled password protection you had unlocked some cells in the workbook.

If you want details on the full list of options have a look at. In excel there are different ways that allow you to protect data and the integrity of your files. Its super important to know your way around protection excel files.

To protect a workbook using a password open excel workbook and add your data. How to password protect an excel file. Click ok once youre happy with the options.

A dialog box will appear. Step 2 go to the review tab in the excel ribbon and select the protect sheet option. In the password to unprotect sheet box type a password for the sheet click ok and then retype the password to confirm it.

Lock cells and formulas easily written by co founder kasper langmann microsoft office specialist.