The password is optional. Passwords in Excel for Mac have a character limit. You cannot open a workbook or document that has been password-protected in the Windows-based version of Excel or if the password is longer than fifteen characters. If you want to open the file in Excel for Mac, ask the Windows-based author to adjust the password length.
If the sheet is protected with a password, then enter the password in the Unprotect Sheet dialog box, and click OK. Excel for the web can open workbooks protected by a password but these files cannot be edited in web. If you want to add a password to a workbook you are working on in Excel for the web, and you have Excel desktop application, use the Open in Excel button to open the workbook and password protect the workbook.
Select Open in Excel and password protect the workbook. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Protection and security in Excel. Protect an Excel file.
Protect a worksheet. Collaborate on Excel workbooks at the same time with co-authoring. Video: Password protect workbooks and worksheets Excel Print and share. Share files. See below for more information: To lock your file so that other users can't open it, see Protect an Excel file. To unprotect a sheet, follow these steps: Go to the worksheet you want to unprotect. Need more help?
When protecting an entire sheet, it makes sense to leave these options as is. Start from an unprotected sheet. Select the cells that you want people to be able to change. To select adjacent cells, just click and drag. If you need to select a cell that is not adjacent to the other cells, hold down the control key and click on it.
Right click on any one of the selected cells and choose Format Cells. Go to the Protection tab and uncheck Locked. Now we are going to password protect our entire worksheet. The cells we just unlocked will remain editable, but the rest of the sheet will be locked.
From the Review tab, choose Protect Sheet. I recommend unchecking the "select locked cells" option. The result will be that people won't even be able to CLICK in your locked areas, making it easier for them to edit without stumbling into the locked cells.
Last, try it out. Try clicking on a locked area and then on an unlocked area. Ranges with Passwords When to use: You're sending out a file to many people, each responsible for specific cell ranges If you are sharing a file with several people and they each have their own area to edit, you may want to assign different passwords to different areas in order to prevent them from accidentally editing an area that isn't theirs.
Start from an unprotected file. Now, you will create a different password for each editable area. Click the New button to designate a new area. For a Title, I recommend typing something meaningful so it will be easy to keep track of the cell ranges. For example, if you are designating this area for a specific person, type their name.
Where it says "Refers to cells", choose the cell range. The easiest way to do this is to click the icon at the end of this field to go to the worksheet and choose your cells. Like in the previous technique, you can either click and drag to select adjacent cells, or hold down control and click on cells that are not adjacent. Click on the icon to return to the dialog. Right-click on then select "Format Cells" from the popup menu. When the Format Cells window appears, select the Protection tab.
Uncheck the "Locked" checkbox. Click on the OK button. Next, select the cell s that you wish to protect. Right-click and then select "Format Cells" from the popup menu.
Check the "Locked" checkbox.
0コメント