(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”. symbols to represent each character in the password.Since I already have a password protecting this document, you can see that they’re shown with 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.
