- EXCEL FOR MAC 2011 UNPROTECT SHEET PASSWORD HOW TO
- EXCEL FOR MAC 2011 UNPROTECT SHEET PASSWORD PASSWORD
The way in which you go about locking those cells really depends on how many you plan to lock. If you plan to share your spreadsheet and only want participants to be able to edit specific cells, this is easy to do. You can do this with other spreadsheets in the same workbook, the same way. You should receive an alert letting you know that the sheet is protected. Now try to make a change to your spreadsheet.
You can leave the default items selected or choose more to allow.
EXCEL FOR MAC 2011 UNPROTECT SHEET PASSWORD PASSWORD
But if you plan to share the sheet, a password is something to consider. You don’t have to use a password if you’re locking the cells for yourself. (Protecting a workbook is different and doesn’t give you the same options.)ģ) Notice that you can enter a password to protect the sheet if you like. Protect the spreadsheetĢ) Choose Protect Sheet. This is just an extra step for verification. Or click the Format button on the Home tab.ģ) Be sure that the box for Locked is checked, which again, should be by default. Your entire sheet should be highlighted.Ģ) Right-click, select Format Cells, and pick the Protection tab. You can do this by clicking the square with the triangle on it in the upper left corner of the table. Verify all cells are lockedġ) With your spreadsheet open, select the entire sheet. The trick to making sure you cannot edit them is to protect the sheet. This can be confusing because as you know, you can change them. You may not realize it but all cells in an Excel spreadsheet are locked by default.
EXCEL FOR MAC 2011 UNPROTECT SHEET PASSWORD HOW TO
Pretty cool! I hope you can see from my example how to simply remove a password or, for that matter, add password protection to your spreadsheet next time you save it.Open your workbook in Excel on Mac and follow these steps to lock the cells you need. Now when I open up the spreadsheet instead of seeing a password prompt, I see this: (Tip: a shortcut to set or delete passwords can be found by clicking on the “Options…” button from this file save dialog window too, if you don’t want to fiddle with Preferences) With that changed, a quick File –> Save As… lets me specify a new name for the non-password-protected (but read-only recommended) file: (as an experiment, I’m going to remove the password but also check “Read-only recommended”. You can remove the password protection by simply deleting the password or passwords here, then click “OK”.
Now you can set a password for opening or modifying here by simply typing one in. Right now, let’s stay on task! Click on “Security”, and …
You may be surprised if you’ve never poked around in the Excel preferences, there’s a lot you can access: The very first step is to open up the Excel spreadsheet in question, then go to Preferences: The best way, however, is to step through the entire Security section on your document, so let me show you how to do that. Seriously, it’s a bit weird to remove the password because there’s no feedback or indication that it’s been removed: all you do is delete the previously entered password when you’re doing a ‘Save As’ save. I imagine it’d sound flippant if I just said “you remove password protection from an Excel file the same way you set up the password protection in the first place” so I will resist saying that.
0 kommentar(er)
