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? Lock Formulas or a Cell in Excel - feature ImageHow to Lock Formulas or Cells in Excel? Merge Cell in Excel feature imageHow to Merge Cells, Columns & Rows 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 Deactivate Account in Instagram?
  • How to Download Private Instagram Stories?
  • How to Slow Motion a Video in PowerDirector?
  • How to Check Who Unfollow You On Instagram?
  • How to Use Boomerang on Instagram?
  • How to Edit Video in PowerDirector?
  • How to Mute Someone’s Stories or Posts on Instagram?
  • How to Hide and Unhide Posts on Instagram?
  • How to Change Video Background in PowerDirector?
  • How to Make a Video Call on Instagram?

Related Searches

  • How to use Autofill in MS Excel 2016?
  • How to download files/folders from Dropbox?
  • How to unsubscribe from snapdeal email alerts
  • How to find XPath in Chrome?
  • How to Disable History in Firefox?

Copyright © 2021 · QueHow · Contact Us