How do I add a password to my Excel worksheet?

 About Microsoft Excel -

Microsoft Excel is a useful and powerful program for data analysis and documentation. It is a spreadsheet program that contains a number of columns and rows, each column and row being a "box". Each cell contains one data point or one piece of information.

How do I add a password to my Excel worksheet?

Password can be applied in two ways. That is,

1. Apply the password so that no one can open the Excel worksheet.
2. Excel Worksheet can be opened but the information in it cannot be changed.

How to use passwords,

• Apply the password so that no one can open the Excel worksheet.       

First, enter your information into an Excel worksheet and save it to your computer. Use save as for this.     

Now click on the Browse button to select the appropriate location to save the file.

Then at the bottom of the window that appears here there is a button called Tool which gives you general options.

You will now see a window similar to the one below. Enter your password there.
Here Password for Open is for entering the password to access the file when it is opened.
Password for Modify is the password used to authorize changes to the worksheet.
In both cases, passwords must be used when opening the file and modifying the file. This method is more secure.

How to open an Excel worksheet but not change the information in it.

First go to Protest Sheet in the Review tab.

You will now see a window similar to the one below. Enter your password here at "Password to unprotect sheet", You can select non-modified options from the list below.

For example, to prevent you from deleting lines in your worksheet, check the box next to Delete rows.

To Remove the password, Click "Unprotect sheet "and enter the password.