QueHow

A How-To and wiki Blog

  • Operating System
    • Windows
      • Windows 10
      • Windows 7
    • Linux
  • Software
    • Application Software
    • Microsoft Office
      • Outlook
      • Word
      • PowerPoint
  • Internet
    • Browsers
      • Mozilla Firefox
      • Google Chrome
    • CMS
    • Tips & Tricks
  • Website
    • ecommerce
    • Google
    • Social Networking
    • General Websites
  • Mobile
  • Email
    • Gmail
  • Wiki

How to Protect Worksheet and Cells in MS Excel 2016?

By Neha T Leave a Comment

Sometimes you have to share the Excel sheet with some other users also. Like, you have created an entire years surveillance data of the company and wanted your juniors to mark their remark on it. At the same time, you don’t want your data to be hampered or changed in any way.  Then, you must protect the cells containing the important data. Sometimes you even want to protect the entire sheet from being changed. This article will help you in both situations. Come, let us see How to Protect Worksheet and Cells in MS Excel 2016?

Steps to Protect Worksheet and Cells in MS Excel 2016:

  1. Protect a Worksheet
  2. Protect Cells in Worksheet


Protect a Worksheet

Step 1: Open an MS Excel worksheet on your screen. Go to Review tab and under Changes group, click on Protect Sheet.

how-to-protect-worksheet-and-cells-in-ms_excel-2016-step-01Step 2: A Protect Sheet dialog box will get opened. Here, you have to type the password that will be demanded later, when you will unprotect the sheet. The password is optional, so if you want you can skip typing password. The protection will be applied to all the locked cells in the sheet. By default, all the cells in an Excel sheet are locked. Click OK.

how-to-protect-worksheet-and-cells-in-ms_excel-2016-step-2Step 3: Time to check your effort. Try to edit any cells in the sheet, it will pop out the dialog box saying, you are trying to edit the protected sheet.

how-to-protect-worksheet-and-cells-in-ms_excel-2016-step-3

Protect Cells in Worksheet

Step 4: Now, if you want to allow users, to be able to edit some set of cells in a protected sheet then you have to unlock those cells as the password is applied to all the locked cells of the sheet. For that select the cells you want to unlock, right-click on the selected cells. An option list will pop out, select Format Cells.

how-to-protect-worksheet-and-cells-in-ms_excel-2016-step-4Step 5: A Format Cells dialog box will get opened. Click on the Protection tab at the top the dialog box and unmark Locked checkbox and click OK.

how-to-protect-worksheet-and-cells-in-ms_excel-2016-step-5Perform step 1 and 2 again to protect the sheet again. But this time, you can observe that the cells that you have unlocked are still editable, and rest are protected from editing.

Step 6: To unprotect the sheet, go back to the Review tab and under Changes group click on ‘Unprotect Sheet’. If you have provided the password while protecting the sheet, it will ask you for the same password to unprotect the sheet.

how-to-protect-worksheet-and-cells-in-ms_excel-2016-step-6Thank you. Keep Reading.

You Might Also Like:

Hide Formula in Excel - feature imageHow to Hide Formula in Excel? how-to-create-a-drop-down-list-in-ms-excel-2016-featured-imageHow to Create a Drop-Down List in MS Excel 2016? how-to-split-text-of-cells-in-ms-excel-2016-featured-imageHow to Split Text in a Cell in MS Excel 2016? Edit a Drop-Down List featured ImageHow to Edit Dropdown List In Excel 2016? How to Concatenate in Excel -featured imageHow to Concatenate Multiple Cells in MS Excel 2016? Merge Cell in Excel feature imageHow to Merge Cells, Columns & Rows in Excel? Lock Formulas or a Cell in Excel - feature ImageHow to Lock Formulas or Cells in Excel? How to Embed an Excel worksheet into WordHow to Embed an Excel worksheet into Word?

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Most Viewed

  • How to Install and Use TELNET in Ubuntu
  • How to install Hindi fonts in MS Word
  • How to Change a File Extension in Windows 10?
  • How to create a flipkart account in 3 simple steps
  • How to Change Monitor Refresh Rate in Windows 10?
  • How to install IIS on Windows 10
  • How to Insert Clickable Checkbox in MS Word 2016?
  • How to Set Auto Reply in Outlook 2016?
  • How to Login as Administrator in Windows 10?
  • How to Check RAM Size and System Type in Windows 10?

Recent Additions

  • How to Add Hyperlink to Another Sheet in Excel?
  • How to Add and Remove Watermark in Excel
  • How to use Relative and Absolute Cell Reference in Excel?
  • How to Enable and Disable Scroll Lock in Excel?
  • How to Use INDEX and MATCH Functions in Excel?
  • How to Make Bar Graph in Excel?
  • How to Count Duplicate Values in Excel?
  • How to Wrap Text in Excel?
  • How to Round off Numbers in Excel?
  • How to Create a Bell Curve in Excel?

Related Searches

  • How to Install and Configure Apache Web Server in Ubuntu
  • How to Install and Use PuTTY to Connect to a Remote Computer
  • How to enable and disable Cookies in Mozilla fire firefox?
  • How to Hide the Unity Launcher In Ubuntu 14.04
  • How to Register on naukri.com

Copyright © 2023 · QueHow · Contact Us