Excel Password

Microsoft Office Excel is a spreadsheet program often used to store numerical data. Spreadsheets are used to enter data in cells. The program can later filter and sort the information. Mathematical formulas and equations can also be placed in the cells. The data stored in the cells can be used as values for the equations.

Microsoft Excel is often used in businesses to hold a number of sensitive information. Because of this, the program comes with an additional feature to include a password to secure files. The access to the files is limited to the people who know the password.

MS Excel offers five types of password security measures:

1. Password for Modifications – Users who know the password can modify the file whereas people who don’t can only view the spreadsheet.

a. Open the Excel document that you want to guard.

b. From the “File” menu, select the “Save As” option.

c. On the upper left portion of the Save As window, click on the “Tools” tab.

d. Select “General Options.”

e. Key in the desired password in the space provided for “Password” to modify. Hit “Enter.”

2. Worksheet Password – protects individual worksheets saved in workbooks from changes by unauthorized users.

a. Open the Excel document.

b. Click the “Tools” menu on the uppermost portion of the window.

c. Click the “Protection” option, then the “Protect Sheet” option.

d. Choose among the options provided. This would allow individual access to certain parts of the sheet.

e. Key in your desired password.

3. Workbook Password – protects the entire workbook file which can contain a number of worksheets

a. Open the Excel document.

b. Go to the Tools menu.

c. Click the Protection option then go to the Protect Workbook option.

d. Click the box beside the Structure and Windows options to choose the suitable option.

e. Enter the password.

If you want to have a password protection pop-up when sharing the Excel worksheet, go to the “Protect and Share Workbook” option from the Protection option. Check the box for Sharing With Track Changes, then assign the password.

4. Visual Basic for Application (VBA) Modules – protects worksheets that contain VBA modules used for programming.

a. Select the VBA module.

b. Right-click the mouse button.

c. Click “VBA Properties.”

d. Select the Protection tab.

e. Check the box for “Lock Project for Viewing” option.

f. Key in the password and hit “OK.”

5. Password to open the Worksheet – users who want to open the worksheet will need to provide a password.

a. Open the Excel document.

b. Go to the File menu and choose the Save As option.

c. Go to the Tools tab.

d. Select General Options.

e. Assign a password in the Password slot to open the text box.