Whether you want to make structural changes or change the content in your Microsoft Excel workbooks, you need to unprotect these items first. We’ll show you how.
If you used a password to protect your Excel items, you will need that password for the unlock procedure below. So have it ready.
TIED TOGETHER: How to lock cells in Microsoft Excel to prevent editing
Unprotecting a workbook vs. unprotecting a worksheet
Unprotect an Excel workbook
Unprotect an Excel worksheet
Unprotecting a workbook vs. unprotecting a worksheet
If you want to make structural changes to your workbook, e.g. For example, to add, move, delete, hide, or rename your worksheets, you must unprotect your workbook (as opposed to unprotecting a worksheet). This will unlock the options to make the above changes to your workbook.
If you want to change the data in your worksheet, e.g. For example, to change the contents of a cell, you must unprotect your sheet. This allows you to add and remove content from your worksheet.
In any case, it is easy to unprotect your items in Excel, as we will explain below.
Unprotect an Excel workbook
To be able to make structural changes to your workbook, first start your spreadsheet with Microsoft Excel.
At the top of the Excel ribbon, click the Review tab.
On the Review tab, in the Protect section, select Protect Workbook.
If you didn’t use a password to protect your workbook, your workbook is now unprotected.
If you used a password for protection, enter that password in the Unprotect Workbook box that opens and click OK.
Your workbook is now unlocked and you can add, remove, delete, hide and rename worksheets in it. Enjoy!
TIED TOGETHER: How to rename worksheet tabs in Excel
Unprotect an Excel worksheet
To change the contents of your cells in your worksheet, first open your spreadsheet with Microsoft Excel.
When Excel opens, select the Review tab at the top of the ribbon.
On the Review tab, in the Protect section, select Unprotect Sheet.
If you didn’t use a password to protect your worksheet, your worksheet is now unlocked.
If you used a password, enter your password in the Unprotect Sheet field and click OK.
Your worksheet is now unlocked and you can make any changes you want to it.
Need to protect your Excel workbook again? If so, it’s a quick and easy process to do so.
TIED TOGETHER: How to protect workbooks, worksheets and cells from editing in Microsoft Excel
This article was previously published on Source link
