why excel has two options for passwords to protect an excel workbook

You have two choices here: File encryption: When you choose this option, you specify a password and lock the Excel file. This prevents other users from opening the file. For more information, see Protect an Excel file.

1. Which are the different workbook protection types in Excel?
2. How do I protect different cells with different passwords in Excel?
3. How do I protect an Excel workbook with a password?
4. What is the difference between Protect Sheet and Protect Workbook in Excel?
5. How do I restrict editing in Excel?
6. How do you prevent someone from saving an Excel file?
7. How do I enable multiple user editing in Excel?
8. How do I protect certain cells in Excel 2007?
9. How do I lock a group of cells in Excel?
10. How do you password protect an Excel file but allow read only?
11. How do you protect cells in Excel without protecting sheet?
12. What does it mean to protect a workbook in Excel?
13. How do I protect all sheets in Excel?

Which are the different workbook protection types in Excel?

You have three choices when it comes to protecting an entire Excel workbook: encrypt the workbook with a password, make the workbook read-only, or protect just the structure of a workbook.

How do I protect different cells with different passwords in Excel?

Applying Different Passwords

1. Go to the Review tab in the Changes group > Click on Allow Users to Edit Ranges button.
2. Click on 'New' to set up your first range for North, which will be cells C3:C14 and enter your password:

How do I protect an Excel workbook with a password?

Protect an Excel file

1. Select File > Info.
2. Select the Protect Workbook box and choose Encrypt with Password.
3. Enter a password in the Password box, and then select OK.
4. Confirm the password in the Reenter Password box, and then select OK.

What is the difference between Protect Sheet and Protect Workbook in Excel?

Well, they're completely different things, really. Amongst other things, Workbook protection allows you to prevent deletion, moving and hiding/ unhiding of worksheets. Worksheet protection allows you to lock cells, prevents modification of data validation and formats etc etc.

How do I restrict editing in Excel?

To restrict editing to a sheet in Excel, use these steps:

1. Open the Excel document.
2. Click on File.
3. Click on Info.
4. On the right side, click the Protect Workbook menu.
5. Select the Protect current sheet option.
6. (Optional) Set a password to unlock the sheet.
7. Check the Protect worksheet and contents of locked cells option.

How do you prevent someone from saving an Excel file?

Preventing Save As... in a Workbook

You can specify that any workbook be saved as read-only by checking the "Read-only recommended" checkbox in the File » Save options. Doing so can prevent a user from saving any changes he might make to the file, unless he saves it with a different name and/or in a different location.

How do I enable multiple user editing in Excel?

To enable this mode and share Excel files, open an Excel file and use Save As in the File tab to save it somewhere accessible on your office network. Click Share Workbook in the Review tab. Click Editing and check the "Allow changes by more than one user" box.

How do I protect certain cells in Excel 2007?

MS Excel 2007: Protect a cell

1. When the Format Cells window appears, select the Protection tab. ...
2. Next, select the cell(s) that you wish to protect. ...
3. When the Format Cells window appears, select the Protection tab. ...
4. For the locking of the cells to take effect, you must also protect the worksheet. ...
5. A "Protect Sheet" window will appear. ...
6. NEXT.

How do I lock a group of cells in Excel?

Lock cells to protect them

1. Select the cells you want to lock.
2. On the Home tab, in the Alignment group, click the small arrow to open the Format Cells popup window.
3. On the Protection tab, select the Locked check box, and then click OK to close the popup.

How do you password protect an Excel file but allow read only?

Save an Excel Workbook as Read Only

1. The “Save As” dialogue box will pop up. ...
2. Doing so will open the “General Options” dialogue box. ...
3. You'll be prompted to confirm the password. ...
4. Clicking the “Read-Only” button will open the document but in Read-Only mode.

How do you protect cells in Excel without protecting sheet?

You can protect cells (or whole rows or columns) by highlighting the cells (i.e. data input cells) you DON'T want to protect then click on "Format"->"Cells"->"Protection" tab. Uncheck the "Locked" box. Now protect your worksheet and/or workbooks with a password.

What does it mean to protect a workbook in Excel?

To prevent other users from viewing hidden worksheets, adding, moving, deleting, or hiding worksheets, and renaming worksheets, you can protect the structure of your Excel workbook with a password.

How do I protect all sheets in Excel?

How to Protect/Unprotect Multiple Worksheets At Once in Excel

1. For each of the code sections below: Go to Tools > Macros > Visual Basic Editor. ...
2. Protect Multiple Worksheets At Once. Sub protect_all_sheets() top: pass = InputBox("password?") ...
3. Unprotect Multiple Worksheets At Once.