EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tools Protect Sheet in Excel
 

Protect Sheet in Excel

Dikshita Jain
Article byDikshita Jain
Madhuri Thakur
Reviewed byMadhuri Thakur

Updated October 4, 2023

Protect Sheet in Excel

 

 

What Does Protect Sheet in Excel Mean?

Protect sheet in Excel is a feature that you can use to lock your Excel worksheet by adding various restrictions and permissions. It allows you to control what others can do with a particular worksheet.

It protects the data present in a workbook or worksheet by adding a password to it. This prevents unauthorized users from changing the protected sheet’s data, such as structure, content, or formatting.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

For instance, imagine you add a password to a sales report and share the password only with the sales department. Thus, anyone other than the sales department employee won’t be able to make any changes to the data.

Table of Contents
  • What Does Protect Sheet in Excel Mean?
    • Why Use Protect Sheet?
    • How to Protect Sheet in Excel?
    • How to Unprotect a Sheet?
    • How to Lock & Protect Cells?
    • How to Hide the Formula within a Cell?

Why Use Protect Sheet in Excel?

Here are a couple of reasons you might want to use protect sheet in Excel:

  1. Data Security: You can keep your data safe from accidental changes or unauthorized access.
  2. Data Integrity: Prevent important formulas or information from being accidentally deleted or modified.
  3. Collaboration: You can work on a project with others without worrying about them accessing any information that they should not have access to.

How to Protect Sheet in Excel?

You have two options to protect sheet in Excel. You can lock a specific worksheet to stop others from opening it at all, or you can protect specific cells. If you choose the second option, people can open and edit the worksheet, but they won’t be able to make changes to the protected cells.

Follow these steps to protect your sheet in Excel.

1. Open the Protect Sheet dialog box using the below steps:

  • Step 1: Click on the Sheet1 tab at the bottom of the Excel window.
  • Step 2: Open the Review tab from the Excel ribbon.
  • Step 3: Under Changes or Protect group, select the Protect Sheet option.

How to Protect Sheet 1.1

OR

Right-click on Sheet1 and select the Protect Sheet option.

How to Protect Sheet 1.2

A dialog box will appear.

How to Protect Sheet 1.3

  1. Set a password as per your choice. Remember this password, as you will need it to unprotect the sheet later.
Note: This step is optional; you can choose not to add a password, but it will be easier for unauthorized people to remove the protection. That’s why adding a password gives an extra layer of security.

How to Protect Sheet 1.4

2. If you want the users to be able to do something on the protected sheet, like selecting cells, formatting, etc., just click the checkbox next to that action and Click OK.

How to Protect Sheet 1.5

Note: If you don’t check any of the actions,  users won’t be able to make any changes. They will be able to view it like a read-only document.

 3. Re-enter the password to confirm it, and then click OK.

How to Protect Sheet 1.6

Result:
To cross-check, click on the Review tab OR Right-click on Sheet1 to check. It would show as Unprotect Sheet, meaning that your sheet is already in protection mode.

How to Protect Sheet 1.7

How to Unprotect a Sheet?

To make changes to a protected sheet or to remove protection, follow these steps:

  1. Go to the Review tab.
  2. Click on Unprotect Sheet. A Dialog box will appear.
  3. Enter the password that you set before to unprotect the sheet.
  4. Click on OK.

How to Unprotect

How to Lock & Protect Cells in an Excel Worksheet?

It is very simple and easy to protect cells in Excel. Let’s understand the workings of protecting cells in Excel with some examples.

Given:

How to Lock Given

Step 1: Select the cell you want to protect and Right-click. and
Step 2: A context menu will appear. Select the Format Cells option in the context menu.

How to Lock Step 2

Step 3: In the Format Cells dialog box that appears, go to the Protection tab.

How to Lock Step 3

Step 4: You will see that the “Locked” checkbox is ticked by default in Excel. If the checkbox is not selected, then tick the “Locked” checkbox and Click OK.

How to Lock Step 4

Note: After locking the cells, you will need to protect the worksheet. Only then will the cell protection work.

Step 5: Go to the Review tab.
Step 6: Click Protect Sheet.
Step 7: Set a password.
Step 8: Specify the actions users can perform on the protected sheet.
Step 9: Click OK.

How to Lock Step 9

Step 10: Confirm the password to proceed.

How to Lock Step 10

Result:
Now, if you try to click on the cell, a message will pop up on your screen (as shown in the below image) stating that the cell is protected. So, to access the particular cell, you will need to enter the password.

How to Lock Result

How to Hide the Formula within a Cell?

If you want to hide the formula, you can use the below method:

Given:

How to Hide Given

Step 1: Select the cell containing the formula that you want to hide, E.g., B5.
Step 2: Follow these steps:

  • Right-clicking the cell > Choose Format Cells > Go to the Protection tab.
  • Now, instead of only selecting the “Locked” checkbox (as shown in the previous section), you must tick the “Hidden” checkbox as well.

How to Hide Step 2

Step 3: Protect the worksheet (see section “How to Protect Sheet in Excel?”).
Step 4: Once the cell is protected, the formula will be hidden from view, and users won’t be able to modify it without unprotecting the sheet first.

Result:

How to Hide Result

Note: If you just want to hide the formula but let the user make changes to all other cells, you will need to select all permissions in the Protect Sheet dialog box carefully, or else the user might not be able to edit any cells.

Frequently Asked Questions (FAQs)

Q1. Can I lock all the formulas in my worksheet at once?

Answer: Yes, you can lock all the formulas in my worksheet at once. For this, you will first need to select all the formulas and then go ahead and lock the selected cells.

Now, if your Excel sheet has less than 10 formulas, you can easily select them using the mouse or the keyboard shortcut. However, if your sheet has more formulas (Eg, 50), you can use the Go to Special option. It lets you select all formulas in a worksheet at once.

To select all the formulas, follow these steps:

  • Go to the Home tab
  • Open the Find & Select dropdown menu from the Editing group.
  • Click on Go to Special. A dialog box will open.
  • Choose the type of data you want Excel to select. For instance, click on the Formulas option box.
  • Click the OK button.

You will see that all the formulas that are present in the sheet are selected. Now, you can go ahead and lock the selected cells using the format cells option shown in the section “How to Lock & Protect Cells in an Excel Worksheet?.”

Q2. What is the difference between protect sheet and protect workbook in Excel?

Answer: Protect sheet safeguards individual sheets in Excel by controlling actions within them, such as editing and formatting. On the other hand, protect workbook secures the entire Excel workbook, including all its sheets. It prevents changes to the workbook’s structure, like adding or deleting sheets.

Q3. Can I protect multiple sheets in the same workbook with different passwords?

Answer: Yes, you can protect different sheets in the same workbook with different passwords to provide different levels of access to users.

Q4. What if I want to allow certain users to edit specific parts of a protected sheet?

Answer: You can unlock specific cells or ranges within a protected sheet by unchecking the “Locked” option in the cell formatting and then protecting the sheet. Users will be able to edit only the unlocked cells.

Recommended Articles

This has been a guide to Protect Sheet in Excel. Here, we discuss how to Protect the Sheet in Excel, along with practical examples. You can also go through our other suggested articles-

  1. VBA Protect Sheet
  2. Unprotect Excel Workbook
  3. How to Create Spreadsheet in Excel?

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA

Download Print Gridlines Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Print Gridlines Excel Template

EDUCBA

डाउनलोड Print Gridlines Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW