As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Protect Cells in Excel: A Step-by-Step Guide

If you're dealing with sensitive data in Excel and want to prevent accidental modifications, cell protection is a valuable feature. This step-by-step guide will walk you through the process of protecting cells in Excel.

How to Protect Cells in Excel:

Step 1: Select the cells you want to protect

  • Manually select cells or use Ctrl+Shift to select multiple cells.
  • You can also choose entire columns or rows by clicking on the column or row headers.

Step 2: Click the "Format" tab

  • Navigate to the "Format" tab at the top of the Excel window.

Step 3: Click the "Protection" tab

  • In the "Format Cells" dialog box, click the "Protection" tab.

Step 4: Check the "Locked" box

  • Check the box next to "Locked" to prevent changes to the selected cells.
  • Optionally, you can check "Track Changes" if you want changes to be tracked.

Step 5: Click "OK"

  • Click "OK" to close the "Format Cells" dialog box.

Step 6: Click the "Review" tab

  • Go to the "Review" tab at the top of the Excel window.

Step 7: Click "Protect Sheet"

  • Click the "Protect Sheet" button to open the "Protect Sheet" dialog box.

Step 8: Enter a password (optional)

  • Optionally, enter a password in the "Password" field for added security.

Step 9: Select the options you want to protect

  • Choose protection options such as "Select locked cells," "Select unlocked cells," etc.
  • Select the options based on your specific needs.

Step 10: Click "OK"

  • Click "OK" to close the "Protect Sheet" dialog box.

Now, you've successfully protected the cells in your Excel worksheet.

How to Unprotect Cells in Excel:

Step 1: Click the "Review" tab

  • Navigate to the "Review" tab at the top of the Excel window.

Step 2: Click "Unprotect Sheet"

  • Click the "Unprotect Sheet" button to open the "Unprotect Sheet" dialog box.

Step 3: Enter the password (if required)

  • If you used a password for protection, enter it in the "Password" field.

Step 4: Click "OK"

  • Click "OK" to close the "Unprotect Sheet" dialog box.

Now, you can make changes to the previously protected cells.

How to Protect a Workbook in Excel:

Step 1: Click the "Review" tab

  • Go to the "Review" tab at the top of the Excel window.

Step 2: Click "Protect Workbook"

  • Click the "Protect Workbook" button to open the "Protect Workbook" dialog box.

Step 3: Enter a password (optional)

  • Optionally, enter a password in the "Password" field for added security.

Step 4: Select the options you want to protect

  • Choose between protecting "Structure" and "Windows" or both.

Step 5: Click "OK"

  • Click "OK" to close the "Protect Workbook" dialog box.

Your entire workbook is now protected.

How to Unprotect a Workbook in Excel:

Step 1: Click the "Review" tab

  • Navigate to the "Review" tab at the top of the Excel window.

Step 2: Click "Unprotect Workbook"

  • Click the "Unprotect Workbook" button to open the "Unprotect Workbook" dialog box.

Step 3: Enter the password (if required)

  • If you used a password for protection, enter it in the "Password" field.

Step 4: Click "OK"

  • Click "OK" to close the "Unprotect Workbook" dialog box.

Now, you can make changes to the previously protected workbook structure and windows.