Protect Excel Files with Password

As you are an Excel user you must know to keep your work safe and Protected. In this post, you are going to learn how to shield your work.

After reading this article you will be able to protect your workbook, sheet or part of the sheet after ignoring range, cells, formula, etc so that no user will be able to open or made changes into the selected sheet or workbook.

You will get the option to Protect sheet in three ways:

  1. In Review Tab Under Protect group
  2. By just right-click the sheet tab
  3. In-Home Tab Under Cells group select Format

Start applying Passwords on Sheet

Like you have to set the password in a sheet to shield your work so that no one can copy your information or making any changes in Excel File.

 

 

 

 

To Protect the Entire sheet

  • Open sheet Protect Sheet.
  • Click the Review Tab
  • Under the Protect group select Protect Sheet
  • In the Protect Sheet dialog box put a password
  • Confirm the password

  • Click OK
If you try to edit protected sheet you get warning.
If you try to edit protected sheet you get warning.

Note: As you put the password in a sheet you will see title bar turn light grey color or greyed out except Find & Replace so that you can’t add any symbol, formatting, etc.

Protect sheet but not a range of cells

When you have data and permit others to edit some or one cell remains the same. Here we have an employee detail sheet you allow them to fill how many days they work other cells are locked.

Protect sheet but give permission to edit selected Range.
Protect sheet but give permission to edit selected Range.

Allow to Edit Ranges

  • Open sheet Range.
  • Click the Review Tab.
  • Select the range
  • Under the Protect group select Allow edit Range.
  • In Allow Users to Edit Range box, click New.
  • Then click Protect Sheet.
  • Put the password and confirm the password (123).

So, by this, you will allow to edit or add text only the selected column but not any other cells.

Remember: If you wish you can Put Password to Range also.

Lock or Unlock Excel cells

Due to any reason, you leave one cell unprotected so that others can edit while other cells have remained secure in the sheet. Like here we left one cell so that you can write the name who sells max Product.

Steps to Protect all cells except one

  • Open Sheet Cell.
  • Click the Home tab.
  • Select the cell.
  • Click the small icon near Font Group

  • A dialog box appears to choose Protection.
  • Remove the Checkmark from Locked.
  • Then click the Protect sheet.
All cells are locked exclude one.
All cells are locked exclude one.

Remember: The same steps will be followed if You want to select multiple cells by pressing Ctrl.

Protect cells with Formula

When the user wants to locked Formulas without the Protecting worksheet. So that no one able to seek the formula without permission.

You will not able to see or move selected cells Formula.
You will not able to see or move selected cells Formula.

To Protect Formula but Allow Input

    • Open sheet Formula
    • Click the Review tab
    • Select Cells
    • Under the Protect group choose Protect Sheet
    • Untick select locked cells
    • Click OK

By doing this, it not allowed anybody to modify or even to move that particular cells which are select to unlocked cells.

Remember: By default, the checkmark is present in the first two options.

Protect sheet but allow to Edit Objects

If you want to protect your sheet but let a few things to change for this, you must know how it works. Here we gave permission to edit the chart only.

Allow to made changes in chart only.
Allow to made changes in chart only.

Allow Edit charts or Object

  • Open sheet Edit Object
  • Click the Review Tab.
  • Under the Protect group select Protect Sheet
  • In the dialog box check mark Edit Object
  • Click OK

It will Prevent edition in cells except for chart and so you can be made changes only chart (object) as per your requirement.

Remember: Its optional to type Password, you can directly click OK without Password.

The same way you can give permission to sort and filter the selected table tick the options sort and Use an Auto filter.

First, apply the filter and then by following the same steps, Tick the option Sort and Use an Auto filter then Click OK to protect.

Permit to Sort and Filter in Protected Sheet.
Permit to Sort and Filter in Protected Sheet.

Remember:  You can allow any of the features to edit by scrolling up and down like insert columns, insert rows, Edit scenarios, etc.

To Protect the whole Excel workbook

There are two ways by which you can protect your workbook. Read (below) about them.

The first way is not allowing another user to interfere in your file only they can view and read the information in the file nothing else.

Protect the Structure

  • Click the Review Tab
  • Under the Protect group select Protect workbook
  • Put and Confirm Password
  • Click OK

As you applied the Protect workbook it will not allow others to add, delete or modify or arrange sheet in the workbook.

Prevent from viewing

The second way is not even allowing you to open the file for reading even unless you have a password. Protect the workbook so that nobody can open without a password.

Put Password to Prevent from Viewing.
Put Password to Prevent from Viewing.

To Protect Excel Workbook

  • Open file
  • Click the File tab
  • Select Info
  • Choose Protect workbook
  • From drop-down select Encrypt with Password
  • Put and confirm Password (12)
  • Click OK

Now, whenever you try to seek this file it will ask you password, if you know the password type otherwise file will not open. So now the Excel workbook is protected not just the worksheet.

Learn how Printing is done in Excel step by step.