I have a spreadsheet that I created a while back with both an open and modify password but now want to share it with someone without a password blocking access. How do I turn off the password protection in Microsoft Excel for Mac?

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. 🙂 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. The best way, however, is to step through the entire Security section on your document, so let me show you how to do that. The very first step is to open up the Excel spreadsheet in question, then go to Preferences: You may be surprised if you’ve never poked around in the Excel preferences, there’s a lot you can access: You can explore later, however. Right now, let’s stay on task!

Click on “Security”, and Now you can set a password for opening or modifying here by simply typing one in. Since I already have a password protecting this document, you can see that they’re shown with • symbols to represent each character in the password. You can remove the password protection by simply deleting the password or passwords here, then click “OK”. (as an experiment, I’m going to remove the password but also check “Read-only recommended”.

With that changed, a quick File –> Save As lets me specify a new name for the non-password-protected (but read-only recommended) file: (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) Now when I open up the spreadsheet instead of seeing a password prompt, I see this: 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. A) Open document > Select edit menu > choose select all > then choose copy from edit menu. Open new document > edit menu> paste. Select tools menu> choose options> window opens with options. Select form different tabs the edit tab> make sure that al desired boxes are selected. Select save tab>choose and mark box>ask about properties accept or Apply options and close.

To add a new password, click Protect Sheet or Protect Workbook, type and confirm the new password, and then click OK. To remove a password from the workbook, click Protect Workbook, and then click OK without entering a new password.

How to set the buttons on the side of your mouse on minecraft for mac free. Save new document different name. When saving it should ask if you want to save properties> choose not save. Maybe it asks if you want to modify properties> choose yes> select box archive amongst read only, hidden or archive.

If this does not work. B)There are many 3rd party utilities which claim to reset forgotten word password: The program that I recommend is the Excel Password Recovery 5.0 It recovers/removes the “Password to Open” and “Password to Edit” for you to view and edit the document freely.