Workbook protection

Hello students, welcome to Kwickprep. Your office file had twelve sheets, one for each month. Someone deleted the March sheet by mistake. How can you stop that from happening? Today we will learn workbook protection: what it protects, how to switch it on, and how to open a file with a password.

First, two words that students often mix up. A workbook is the whole spreadsheet file that you save, such as Sales dot xlsx. A worksheet is one page inside that file, and you see it as a tab at the bottom. One workbook can hold many worksheets, like January, February and March. Workbook protection guards the file and the list of sheets, not the typing inside one cell.

Excel offers three kinds of protection for a workbook. A password to open means nobody can even see the data without the password. A password to modify lets others open the file, but only read it, unless they know the password. Structure protection stops people from adding, deleting or renaming sheets. Let us learn each one.

Structure protection locks the arrangement of sheets. Nobody can insert a new sheet. Nobody can delete a sheet, so the March problem is solved. Nobody can rename a sheet or drag it to a new position. Nobody can hide or unhide a sheet. But people can still type in cells, because this protection is about sheets, not cells.

Here are the steps to protect the structure. Go to the Review tab on the ribbon. Click Protect Workbook. In the box, keep Structure ticked. Type a password and click OK. The password is optional, but without one anyone can remove the protection. Excel asks you to type the password again, to check for typing mistakes. Now the structure is protected.

To stop strangers from opening the file at all, use a password to open. Click the File tab, then Info. Click Protect Workbook. Choose Encrypt with Password. Encrypt means the file is scrambled so it cannot be read without the password. Type the password, then confirm it. Save the file, because nothing changes until you save. Next time, Excel asks for the password before opening.

There is one more place to set passwords. Choose File, Save As, then click Tools near the Save button, and pick General Options. Here the password to open works as we just learned. The password to modify is needed only to save changes to the same file. A person without it can click Read only, which means they can look but cannot save over your file.

To remove protection, you must know the password. For structure protection, go to the Review tab and click Protect Workbook again. It acts like an on and off switch, so type the password and click OK. For a password to open, go to File, Info, Encrypt with Password, and delete the dots in the box. Then save the file, or the old password stays.

Passwords need care. Excel passwords are case sensitive, which means capital and small letters count as different. A strong password mixes capital letters, small letters, digits and symbols, like Sales at twenty six. If you forget a password to open, Microsoft cannot recover it, and the data may be lost for good. So keep a copy of the password in a safe place, not on a sticky note on the monitor.

Pause and predict. The structure of the Sales workbook is protected. Riya right clicks the March tab. Can she delete the March sheet? No, Delete appears grey and cannot be clicked. Can she type five thousand in cell B2? Yes, she can, because structure protection does not lock cells. To lock cells, we need sheet protection, which is a separate lesson.

If your centre uses LibreOffice Calc, the idea is the same, but the menus differ. In Excel, you use the Review tab. In Calc, you use the Tools menu. The item is called Protect Spreadsheet Structure in Calc, instead of Protect Workbook. For a password to open, Calc uses Save As, with the Save with password box ticked.

Let us revise. A workbook is the whole file, and a worksheet is one tab inside it. Review, then Protect Workbook, stops sheets from being added, deleted, renamed, moved or hidden. File, Info, Encrypt with Password stops anyone opening the file without the password. A password to modify lets others open the file only as Read only. And a forgotten password cannot be recovered, so store it safely.