The add sheet

Can"t insert a brand-new worksheet or delete an existing sheet? The alternative to include new sheet is greyed out? If the workbook structure is defended via a password, you"re unable to include, delete, move, copy, rename, hide or unhide any kind of sheets. Here are 2 ways to unprotect workbook framework in Excel 2016 / 2013.

*

Method 1: Unsafeguard Workbook Structure via Password

Excel permits customers to defend the structure (the arrangement of sheets) of all sheets in a workbook. If you can remember the workbook framework password, you have the right to conveniently remove the defense in Excel.

You watching: The add sheet

Open the Excel file (.XLSX, .XLS) in Office Excel. Click the File menu in the upper-left corner of the Excel window, and also then select Info.

*

Click the Protect Workbook button and also then select the Protect Workbook Structure option from the drop-down list.

*

If your workbook framework is protected, the Undefend Workbook dialog box will pop up. Type in the correct password and click OK.

See more: Boot Android Boot From External Sd Card, Run Any Android Rom From Sd Card

*

You have the right to then insert, delete, copy, relocate, rename, hide or unhide the sheets without constraints.

Method 2: Unsafeguard Workbook Structure without Password

If you"ve forobtained the password of protecting workbook structure, you can undefend it through the Excel Password Recoexceptionally routine. Here"s exactly how to remove workbook framework defense easily.

Start the Excel Password Recoextremely program. Click the ... button to select your safeguarded Excel file, and select Rerelocate Worksheet & Workbook Password.

*

Once you clicking Next, the program will certainly rerelocate the workbook framework password instantly. Click the Go to folder button and you deserve to open up the unprotected Excel file and also then include or delete sheets.

See more: Q&A ( Honor 8 Lock Screen ? Change Wallpaper Huawei Honor 8, How To

*

Using the Excel Password Recoextremely regime you can also undefend worksheet that stays clear of you from inserting or editing and enhancing rows. It works via workbook produced in Office Excel 2016, 2013, 2010 and also 2007 files.


Ready to try or buy?

Buy Excel Password Recoextremely Download Excel Password Recoexceptionally

Related Articles