Microsoft Excel sheet is the most used sheet in the world. Almost in every office it is used to prepare data. Sometimes, excel has private or sensitive data. To secure data, we need to set password in our excel sheet.

In this post, I will tell you the easiest way to set password in excel. To make an excel file password protected, below steps need to follow:

There are two methods to make excel file password protected:

First

1. Open the Excel Sheet.

2. Click on Save As.

3. Go to Tools at the bottom of the window.

setpasswordinexcel

4. Go to General Options.

5. Set the password here of your choice.

Second

1. Open the Excel file.

2. Select File from left top.

3. Click on Info>Protect Workbook

excelpassword

4. Select Encrypt with Password.

excelpasswordprotect

5. Type and confirm the Password by re writing the password of your choice.

Explore More

How to Merge 2 or more Cell into 1.

How to Merge 2 or more Cell into 1.   While working in excel we need to merge 2 or more cells into 1. Mainly when are to make a

How to use “Text to Columns” in excel

How to use “Text to Columns” in excel   Many times we get data in one cell like full name with address and we need to separate it in different

How to Add (Sum) data in Excel

How to Add (Sum) data in Excel   In Microsoft office, Excel plays a vital role. It has vast range of formula, in excel we can add (sum) the data