Open In App

How to Protect Excel Sheet with Password?

Improve
Improve
Like Article
Like
Save
Share
Report

Excel sheets are also known as spreadsheets. Excel was developed by Microsoft for Apple’s Macintosh in 1985. The data stored in rows and columns format. We can create Excel sheets with infinite data. There will be n number of rows and n number of columns, which means we can store lakhs and crores of data into an Excel sheet. In this article, we will look into the process of adding passwords on a new Excel Sheet and an Existing Excel sheet.

Note: The password protection may not work for CSV files in some MS Excel versions.

Setting password for existing Excel file

Follow the below steps to set a password on an already existing Excel file

Step 1: Open existing Excel file 

Step 2: Click on the save as button.

Step 3: Click on the drop-down list called tools.

Step 4: In the drop-down list select the General option.

Step 5: Set a password for opening the sheet and for writing.

Step 6: After setting the password click on the save button.

After setting the password, open the encrypted Excel file, we will find a dialog box with a text box for entering the password.

Setting password for a new Excel file

Follow the below steps to set a password on an already existing Excel file

Step 1: Create a new Excel file and add some data to it.

Step 2: Click on the save as button.

Step 3: Click on the drop-down list called tools. 

Step 4: In the drop-down list select the General options. 

Step 5: Set a password for opening the sheet and for writing.

Step 6: After setting the password click on the save button. 


Last Updated : 22 Mar, 2021
Like Article
Save Article
Previous
Next
Share your thoughts in the comments
Similar Reads