How to Protect Excel Sheet with Password?
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
Share your thoughts in the comments
Please Login to comment...