Whether you want to make structural changes or modify the content in your Microsoft Excel workbooks, you’ll have to unprotect those items first. We’ll show you how to do just that.
If you used a password to protect your Excel items, you’ll need that password in the unlocking procedure below, so keep that handy.
If you’d like to make structural changes to your workbook, like adding, moving, deleting, hiding, or renaming your worksheets, you’ll have to unprotect your workbook (as opposed to unprotecting a worksheet). Doing that unlocks the options to make the above-mentioned changes to your workbook.
In case you’re looking to modify the data in your worksheet, such as changing the content of a cell, you’ll have to unprotect your sheet. This allows you to add and remove content from your worksheet.
Either way, it’s easy to unprotect your items in Excel as we’ll explain below.
To be able to make structural changes to your workbook, first, launch your spreadsheet with Microsoft Excel.
In Excel’s ribbon at the top, click the “Review” tab.
On the “Review” tab, from the “Protect” section, choose “Protect Workbook.”
If you didn’t use a password to protect your workbook, your workbook is now unprotected.
In case you used a password for protection, then in the “Unprotect Workbook” box that opens, type that password and click “OK.”
To change the content of your cells in your worksheet, first, open your spreadsheet with Microsoft Excel.
When Excel opens, in the ribbon at the top, select the “Review” tab.
On the “Review” tab, from the “Protect” section, choose “Unprotect Sheet.”
If you didn’t use a password to protect your worksheet, your worksheet is now unlocked.
In case you did use a password, then in the “Unprotect Sheet” box, enter your password and click “OK.”
Your worksheet is now unlocked and you can make whatever changes you want to it.
Need to re-protect your Excel workbook? If so, it’s a quick and easy process to do that.
- › How to Lock Column Width and Row Height in Microsoft Excel
- › How to Delete a Sheet in Microsoft Excel
- › Wrap Up Your Gift List With Deals From Surface, Lenovo, More
- › How to Add Bullet Points in Word
- › Look Out for These USPS Shipping Scam Messages
- › 7 Ways to Sort Data in Microsoft Excel
- › No, “Web5” Is Not a Thing
- › How to Copy and Paste Formatting in Microsoft PowerPoint