How to Protect MS Excel Worksheets Through Passwords

Microsoft Office Excel is a spreadsheet program, which is used to enter data into cells. Excel can filter and sort this information. Mathematical formulas and equations can also be placed in the cells. The data stored in other cells can be used as values for the equations. Thus, this program is often used to store and calculate numerical data.

Excel is often used in businesses to store a number of sensitive information. Because of this, the program comes with an additional feature that enables the user to install a password to secure files. The password restricts unauthorized access to the files.

Steps to Protect MS Excel Worksheets through Passwords

MS Excel offers five types of password security measures. These types, and how to implement them, are:

  1. Workbook Password – protects the entire workbook (which can contain a number of worksheets) file with a password
    • Open the Excel document.
    • Go to the Tools menu.
    • Click the Protection option, and then go to the Protect Workbook option.
    • Click on the box beside the Structure and Windows options to choose the suitable option.
    • 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.

  2. Worksheet Password – The password protects individual worksheets saved in workbooks from any changes from unauthorized users.
    • Open the Excel document.
    • Click the “Tools” menu on the uppermost portion of the window.
    • Click the “Protection” option, then the “Protect Sheet” option.
    • Choose among the options provided; this would allow individuals access to certain parts of the sheet.
    • Key in your desired password.

  3. Password to open the Worksheet – users who want to open the worksheet will need to provide a password
    • Open the Excel document.
    • Go to the File menu and choose the Save As option.
    • Go to the Tools tab.
    • Select General Options.
    • Assign a password in the Password slot to open the text box.

  4. Password for Modifications – Users who know the password can modify the file, whereas people who don’t can only view the spreadsheet.
    • Open the Excel document that you want to guard.
    • From the “File” menu, select the “Save As” option.
    • On the upper left portion of the Save As window, click on the “Tools” tab.
    • Select “General Options.”
    • Key in the desired password in the space provided for “Password” to modify. Hit “Enter.”

  5. Visual Basic for Application (VBA) Modules – protects worksheets that contain VBA modules which are used for programming.
    • Select the VBA module.
    • Right-click the mouse button.
    • Click on “VBA Properties.”
    • Select the Protection tab.
    • Check the box for “Lock Project for Viewing” option.
    • Key in the password and hit “OK.”