Téléphone au téléphone Transfert de données, Récupération de données, Gomme de données

Comment ajouter et supprimer mot de passe à partir du fichier Excel

32
iMusic

Les mots de passe sont partout de nos jours. Chaque site vous vous inscrivez nécessite un mot de passe, votre ordinateur Windows nécessite un mot de passe, and let’s not get started on Two Factor Authentication. Pour certaines personnes, it’s irritating having to come up with and remember all of these passwords. Although it’s a necessary security measure, there’s no denying how tedious it can be. Microsoft made this a part of their Microsoft Office package and the more forgetful users have found themselves wondering how to remove password from Excel file.

With so many passwords, you’re going to forget them occasionally. Adding passwords to files isn’t seen as bothersome, bien que, and some users have wanted this ability for years. But this doesn’t take away from the fact that you’ll have to remember your passwords, either by memorizing them or using a password manager. Dans cet article, we’ll be focusing on Microsoft Excel. You can use password protection either to lock the document completely or to restrict edits, and we’re going to observe how to bypass both.

Setting Passwords for an Excel Worksheet

If you’re wondering why you should set a password for an Excel worksheet, tu n'es pas seul. It is a relatively new feature of the program but is something many have been waiting for. It’s a simple matter of security and privacy.

Some documents contain information you don’t want others to see. Businesses don’t want their financial records being public information, nor would they want employee details to be easily accessible. Spreadsheets are an effective way of storing this type of data, and a password ensures it remains private.

When you’re not trying to remove protection from Excel, but rather add it, here are some tips.

Password Length

There aren’t any tight requirements for setting an Excel password. Alors, if you enter an insecure password, you won’t see a warning.

Typiquement, you should aim for your password to be at least 6 personnages. Idéalement, bien que, try to have it around 10 personnages. The longer it is, the harder it’ll be to crack. Bien que, the longer the password is, the harder it’ll be for you to remember it.

Password Complexity

When we say complexity, we mean that your password shouldn’t only contain letters. You should include a mixture of uppercase and lowercase letters, Nombres, and a couple of special characters too. The more complex the password is, the harder it’ll be for someone to guess it or crack.

Limit Password Sharing

Who you share the password with will differ depending on your situation. toutefois, in most cases, you shouldn’t share it at all (or at the very most, one other person).

Giving a password to more people means that it’s at a greater risk of falling into the wrong’s hands. Only give others access to the protected Excel spreadsheet if it’s 100% nécessaire.

How to Add a Password to Excel File

Starting with the very first process, you’ll likely use, this process details how to add a password to your Excel file. Doing this will prevent anyone without the password from so much as opening the file, let alone reading it.

Étape #1 – Locate and open the Excel file you would like to add a password to.

Étape #2 – Once the spreadsheet opens, clique sur le “Fichier” onglet, puis “Info.”

Étape #3 - Cliquer sur “Protect Workbook” et choisissez “Encrypt with Passwordfrom the encryption options that appear.

Étape #4 – A popup box will appear on your screen. Use this to enter a strong password that you can remember or save it in a password manager app.

Étape #5 – Type the password into the box for a second time to confirm that this is the password you want to use. Cliquez sur “Entrer” to finish adding the password to Excel.

Étape #6 – After you have successfully encrypted the Excel file, close the window, and reopen the file to check if the password has been enabled.

Une fois que vous faites cela, every time you need to open the file, you must enter the passcode. If the novelty wears off and you don’t want the password, we’ll show you how to remove password from Excel file later on.

How to Add a Password to Restrict Excel Editing

Maybe you don’t want to add a total lock to the Excel file. Perhaps you just want to stop people from making edits whilst being able to read the spreadsheet’s contents. Si c'est le cas, then you can add editing restrictions.

Étape #1 – Start by opening the excel file that you want to restrict editing to.

Étape #2 – After opening the file, cliquer sur “Fichier > Info.”

Étape #3 - Cliquez sur “Protect Workbookand from the list, sélectionner “Protect Current Sheet.

Étape #4 – A popup window will appear. Vérifier la “Protect Worksheet and Contents of Locked Cells” option.

Étape #5 – On this page, you’ll be able to adjust the restrictions. Scroll through the various options and check the boxes of the features you want users to have access to.

Étape #6 - Suivant, enter a suitable password for the spreadsheet and press “D'accord” procéder.

Étape #7 – Type in the password again to verify it, et cliquez sur “D'accord” one last time.

This is particularly useful for whenever you share a file. Tracking down whoever makes edits to a shared file isn’t always easy, but revoking access might not be appropriate.

Adding this basic edit-restricting password to your Excel file will ensure that only you (or any password holders) can make changes to the spreadsheet. If you forget the password that you’ve chosen then don’t worry, we’ll also be showing you how to remove protection from Excel.

How to Remove Protection from Excel with Password

Moving on to one of the more complex issues that users face. Knowing how to remove password from Excel File is a rather simple task, but only if you already know what the password is. Assuming this is the case, here’s how to remove the password if you know it.

Étape #1 – Find and open the Excel file, which has password protection.

Étape #2 – Submit the file’s password so that you can have full access to the spreadsheet.

Étape #3 – Head over to “Fichier > Info” et cliquez sur “Protect Workbook.

Étape #4 - Suivant, cliquer sur “Encrypt with Passwordand when the popup window appears, delete the password from the box.

Étape #5 - Appuyez sur la “D'accord” button to confirm the password removal and save the file.
Following these steps allows you to remove the password from an Excel file which has file protection. D'autre part, you might want to remove protection from Excel file to get rid of editing restrictions.

How to Remove Editing Restrictions from Excel with Password

You can remove your editing restrictions from an Excel document in a similar way. Follow the steps below to see how.

Étape #1 – Open up the Excel file with editing restrictions.

Étape #2 – From the toolbar at the top, Cliquez sur “Fichier” et alors “Info.”

Étape #3 – Proceed to click onProtect Workbook” et sélectionnez “Limiter l'édition.” Enter the password that was created when you first enabled the restrictions.

Étape #4 – On the list of restrictions, locate and select “Protection Stop.”

Étape #5 - Enfin, Cliquez sur “D'accord” and save the document.

Making this change effectively removes the read-only restrictions of a Microsoft Excel file. It goes without saying that you can only remove password from Excel file with this method if you have the original password. Si non, you must take a different approach.

Removing Excel Passwords without the Password

A more common situation you might find yourself in is trying to access an Excel file when you don’t know the password. Sûr, it’s easy enough to remove protection from excel if you were the creator of the file. But what happens when you require information from a spreadsheet that someone else added protection to?

La réponse est Passper pour Excel, a program which will assist you. After scanning the chosen Excel file, Passper will discover the file’s password. You can then use the findings to unlock the spreadsheet after you open it.

  • Removes passwords from Excel files so that you can print documents
  • Removes editing restrictions so that you’re able to make changes to a spreadsheet
  • Uses 4 different password recovery methods to regain access quickly
  • Utilizes your computer’s CPU and GPU to ensure a speedy experience
  • Supports Windows Vista to Windows 10
  • Does not cause any data loss when removing an Excel password
  • There are alternate versions of Passper for Word, Power Point, PDF, and other filetypes
  • Available as a free or paid program

Obtenez Passper pour Excel

Given that Passper for Excel uses 4 password cracking methods, it might sound like an intimidating solution. That’s not the case – it doesn’t matter how technical you are; this is an easy program to use.

How to Remove Protection from Excel without Password

Dans cette nouvelle méthode, you will see Passper for Excel in action. When you don’t have a file’s password and therefore are unable to open it, follow these steps to remove password from Excel file.

Étape #1 – Download and install the Passper for Excel program on your computer.

Étape #2 - Ouvrez le programme et dans le menu principal, cliquer sur “Récupérer des mots de passe.”

Étape #3 - Suivant, you must select which Excel file to unlock. Cliquez sur “Ajouter” and use the popup window to locate and select the Excel file to remove a password from.

Étape #4 – After selecting the file, you’ll see a brief description of each password recovery method that you can use. Select whichever you prefer, et cliquez sur “Récupérer.”

Étape #5 – Passper will now begin rigorously cracking the Excel file’s password. How long this takes is dependant on the recovery method you chose.

Étape #6 – After hopefully not too long, the scan will finish, and you will see the password. Open the Excel file and use this password to unlock it.

habituellement, this approach won’t take too long as most people use simple passwords. If the Excel file uses a more intricate password then, bien sûr, it’ll take a little longer.

How to Remove Editing Restrictions from Excel without Password

Passper for Excel is also useful to remove protection from Excel when the owner has editing restrictions enabled. Here’s a short guide on removing these restrictions with Passper.

Étape #1 – Install the Passper for Excel software on your computer, then launch it.

Étape #2 – When the program’s main menu loads, clique sur le “Supprimer les restrictions” fonctionnalité.

Étape #3 - Clique sur le “Ajouter” button and navigate to the Excel file, et sélectionnez.

Étape #4 – After importing your file into Passper for Excel, Cliquez sur “Remove.

Étape #5 – In a matter of seconds, the editing restrictions will be removed, and you’ll be able to make changes to the spreadsheet file.

This is a significantly easier and quicker way of getting into a Microsoft Excel file compared to if there is password protection. Cela dit, whether you want to bypass the file’s password or its editing restrictions, Passper pour Excel is the most effective solution you’ll find.

Try Passper for Excel

To Conclude on How to Remove Protection from Excel

Password protecting your important Microsoft Excel files can be greatly beneficial. Valuable personal information won’t be seen by other people, and financial spreadsheets will be for your eyes only. If you’re unable to view your spreadsheets because you can’t remember what you set the password as, as stressed as this might make you, it’s not the end of the world. The methods above to remove password from Excel file will allow you to regain access and make any changes. Spreadsheets are fantastic and so is password protection, but they can’t work around human error just yet!

vous pourriez aussi aimer

Laisser un commentaire

Votre adresse email ne sera pas publiée.

Ce site utilise des cookies pour améliorer votre expérience. Nous allons vous supposerons ok avec ce, mais vous pouvez refuser si vous le souhaitez. AcceptezLire la suite