Icône de message
Passer au contenu du pied de page
  1. IronXL
  2. Blog IronXL
  3. Utilisation d'IronXL
  4. Comment verrouiller les cellules dans Excel
UTILISATION D'IRONXL

Comment verrouiller les cellules dans Excel : un tutoriel étape par étape

Jordi Bardia
Jordi Bardia
Mis à jour:

Many people find it challenging to understand the procedure for locking cells in Excel. We are here to help. This article will show you how to lock cells in an Excel file easily, one step at a time. You will be able to do it like a pro by the end of this article, so let's get started.

IronXL: The C# Excel Library

IronXL is a library for C# that lets you work with Excel without installing Excel on your system. This is a significant benefit as you won't need access to administrative rights and won't have to worry about interfering with the user's machine. If there are still any doubts about this library, we recommend reading our datasheet. To create a new Excel file and format the data according to your needs, you can use the IronXL C# library. This is a go-to package for all Excel operations, meaning that it provides complete functionality. If you're building any software and need to edit or create an Excel file, you can use the IronXL library to do this quickly.

Furthermore, IronXL also offers a wide range of features to interact with Excel WorkBook, WorkSheet and Cells level such as converting between popular formats, cell data formatting, merging cells, inserting math functions, and even managing charts and adding images.

To use it, you must import the library's DLL file or install it with NuGet Package Manager. Its free trial version can be used to test and ensure that all features function as intended. The trial version is free and does not expire until the end of 30 days. When you purchase IronXL, you will need to apply for the license key. If you decide that you like IronXL after reading the documentation, please make sure to buy it at an affordable price! Visit this licensing page for more information about licensing.

Let's see how we can protect an Excel sheet using the IronXL C# Library:

  1. Create a C# .NET or VB .NET project in Visual Studio.
  2. Download the DLL file of the IronXL library or install it via NuGet Package Manager in Visual Studio.
  3. Apply for your License key using the provided tutorial.
  4. Use IronXL in your project.
// Import IronXL to your project
using IronXL;

// Load the Excel workbook from the specified file path
WorkBook wb = WorkBook.Load("fileaddress.xlsx");

// Select the specific sheet you want to lock
WorkSheet ws = wb.GetWorkSheet("SheetName");

// Protect the sheet by setting a password
ws.ProtectSheet("Password");

// Save the changes made to the workbook
wb.Save();
// Import IronXL to your project
using IronXL;

// Load the Excel workbook from the specified file path
WorkBook wb = WorkBook.Load("fileaddress.xlsx");

// Select the specific sheet you want to lock
WorkSheet ws = wb.GetWorkSheet("SheetName");

// Protect the sheet by setting a password
ws.ProtectSheet("Password");

// Save the changes made to the workbook
wb.Save();
' Import IronXL to your project
Imports IronXL

' Load the Excel workbook from the specified file path
Private wb As WorkBook = WorkBook.Load("fileaddress.xlsx")

' Select the specific sheet you want to lock
Private ws As WorkSheet = wb.GetWorkSheet("SheetName")

' Protect the sheet by setting a password
ws.ProtectSheet("Password")

' Save the changes made to the workbook
wb.Save()
$vbLabelText   $csharpLabel

You have now seen how easy it is to protect cells in Excel using the IronXL library, given a working knowledge of C#. You can also benefit from multiple tutorials on Excel operations in the IronXL official documentation.

You can download a file project.

Lock Cells in Microsoft Excel

The lock cell function is a protection feature in Microsoft Excel that allows you to lock cells so that they cannot be edited. Let's look at how we can lock cells in Microsoft Excel.

Protect the Entire Sheet

Sometimes you have to give your document to someone else for read-only purposes. You can do this by protecting the sheet with a password. Let's see how we can do this:

  1. Open your file in Microsoft Excel.
  2. Go to the Home tab and click on the dialogue box launcher icon in the Alignment group.

How to Lock Cells in Excel: A Step-by-Step Tutorial, Figure 1: Navigate to Format Cells dialog in Excel Navigate to "Format Cells" dialog in Excel

  1. A "Format Cells" section will open. Go to the Protection tab.

How to Lock Cells in Excel: A Step-by-Step Tutorial, Figure 2: Protection tab in Format Cells dialog Protection tab in "Format Cells" dialog

  1. Check the Locked check box and click on the OK button.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 3: Lock cells option Lock cells option

  1. Next, go to the Review tab and click the Protect Sheet option in the Protect group.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 4: Navigate to the Protect Sheet button in Excel Navigate to the "Protect Sheet" button in Excel

  1. Then, enter a password to protect the sheet and click the OK button.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 5: Enter a password in the Protect Sheet dialog Enter a password in the Protect Sheet dialog

  1. Next, re-enter the password to verify your password.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 6: Re-enter a password Re-enter a password

After following these steps, your sheet will be completely protected. When someone tries to edit any cell in an Excel file, they will get an error prompt.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 7: Error on editing a locked sheet in Excel Error on editing a locked sheet in Excel

Lock Specific Cells

Sometimes you will need to protect specific cells with data or formulas. If so, unprotect the rest of the spreadsheet before protecting those essential cells. Let's look at how we can lock specific cells in Excel.

  1. Open your Excel file in Microsoft Excel.
  2. Select the whole sheet and press Ctrl + 1 to open the "Format Cells" dialogue box. The "Format Cells" dialogue box will open.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 8: Format Cells dialog in Excel Format Cells dialog in Excel

  1. Go to the Protection tab, uncheck the 'Locked' option, and press the OK button. This will unlock cells in the Excel spreadsheet.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 9: Navigate to the Lock cell function Navigate to the Lock cell function

  1. Next, select the cells you want to protect and open the cell dialogue box using the Ctrl+1 keyboard shortcut key. Go to the Protection tab, check the locked option, and click the OK button.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 10: Lock cell in Format Cells dialog Lock cell in Format Cells dialog

  1. Go to the review tab and click "protect the sheet" from Protect Group. The protection dialogue box will open. Check the option "Protect worksheet and content of the cell." Enter the password to protect it.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 11: Protect Sheet dialog and enter a password Protect Sheet dialog and enter a password

By doing this, your selected cells will be protected. When you try to edit these cells, you will get the error message.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 12: Error on editing a locked sheet in Excel Error on editing a locked sheet in Excel

Lock Formula Cells

You can choose to lock only formula cells to protect your calculations in Excel. Follow these steps to lock formula cells in Excel:

  1. Open your Excel file.
  2. Unlock the whole sheet by selecting all the cells, going to the cell group, and clicking on the Format menu. Select "format cells" from the dropdown. The "Format Cells" menu will open.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 14: Navigate to Format Cells function Navigate to Format Cells function

  1. Go to the Protection tab, uncheck the 'Locked' option and click the OK button.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 15: Tick on the Locked option Figure 15: Tick on the Locked option

This will unlock the whole sheet. Next, find the formula cells. Go to the Home tab and click on the Find and Select menu. From the drop-down, select the "Go to special" menu.

  1. From the "Go To Special" dialogue box, select Formulas and press the OK button.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 16: Enable Formulas option in Go To Special dialogue box Enable "Formulas" option in "Go To Special" dialogue box

  1. You will see that cells with formulas will be selected in the Excel sheet.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 17: Selected cells with formulas Selected cells with formulas

  1. With these cells selected, go to the review tab and click "Protect Sheet". Enter the password to protect and re-enter the password to confirm.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 18: Protect formula cells Protect formula cells

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 19: Confirm password dialogue box Confirm password dialogue box

The formula cells will now be protected. No one will be able to edit these cells without entering the correct password.

Unprotect Sheet

Follow these steps to enable editing:

  1. Select the whole sheet. Go to the review tab and click "Unprotect Sheet".

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 20: Navigate to Unprotect Sheet function Navigate to Unprotect Sheet function

  1. In the "Unprotect Sheet" dialogue box, enter the correct password. The sheet will now be open to edits.

How to Lock Cells in Excel: a Step-by-Step Tutorial, Figure 21: Enter the password to unlock the sheet Enter the password to unlock the sheet

Conclusion: The Benefits of Locked Cells vs. Unlocked Cells

There are clearly benefits to locking cells, but the level of security you need depends on what you are using the cells for.

The benefits of locking cells include:

  • Preventing access to unauthorized users (e.g. children)
  • Preventing people from tampering with an item
  • Controlling the environment in which items are stored

The drawbacks of locking cells include:

  • Costs of purchasing and installing locks
  • Difficulties in accessing items when they need to be retrieved (e.g., when a file has gone missing)
  • Difficulty in moving items within a facility

Questions Fréquemment Posées

Comment puis-je verrouiller des cellules dans un fichier Excel en utilisant C#?

Vous pouvez verrouiller des cellules dans un fichier Excel en utilisant C# en utilisant la bibliothèque IronXL. Tout d'abord, chargez le classeur Excel et sélectionnez la feuille de travail. Ensuite, utilisez la méthode ProtectSheet avec un mot de passe pour verrouiller des cellules spécifiques.

Quelles étapes sont impliquées dans la protection d'une feuille Excel entière en utilisant C#?

Pour protéger une feuille Excel entière en utilisant C#, vous pouvez utiliser la bibliothèque IronXL. Chargez le classeur, sélectionnez la feuille de travail souhaitée, et appliquez la méthode ProtectSheet avec un mot de passe pour sécuriser toute la feuille.

Est-il possible de verrouiller uniquement des cellules spécifiques dans Excel avec C#?

Oui, en utilisant IronXL en C#, vous pouvez verrouiller des cellules spécifiques dans Excel. Tout d'abord, déverrouillez toute la feuille, puis sélectionnez les cellules que vous souhaitez verrouiller, et enfin appliquez la méthode ProtectSheet avec un mot de passe.

Quels avantages offre le verrouillage des cellules dans Excel?

Le verrouillage des cellules dans Excel offre plusieurs avantages, notamment la prévention de l'accès non autorisé, l'assurance de l'intégrité des données et la protection des informations sensibles contre la falsification.

IronXL peut-il être utilisé pour verrouiller les cellules de formule dans Excel?

Oui, IronXL peut être utilisé pour verrouiller les cellules de formule dans Excel. Déverrouillez toute la feuille, utilisez la fonctionnalité 'Atteindre' pour sélectionner les cellules de formule, puis appliquez la méthode ProtectSheet avec un mot de passe.

Comment déverrouiller une feuille protégée dans Excel en utilisant C#?

Pour déverrouiller une feuille protégée dans Excel en utilisant C#, utilisez IronXL pour charger le classeur, sélectionnez la feuille de travail, et appliquez la méthode UnprotectSheet avec le mot de passe correct.

Quels sont les inconvénients potentiels du verrouillage des cellules dans Excel?

Certains inconvénients potentiels du verrouillage des cellules dans Excel incluent la difficulté d'accès et de récupération des données lorsque cela est nécessaire et les défis de modification du contenu verrouillé, à moins d'être déverrouillé avec le bon mot de passe.

Comment puis-je démarrer un projet C# pour travailler avec Excel en utilisant IronXL?

Pour démarrer un projet C# avec IronXL, créez un nouveau projet C# dans Visual Studio, ajoutez le package NuGet IronXL, et appliquez votre clé de licence IronXL pour commencer à travailler avec des fichiers Excel.

Puis-je trouver des tutoriels sur l'utilisation de IronXL pour les opérations Excel?

Oui, IronXL fournit une documentation complète et des tutoriels sur leur site Web, couvrant diverses opérations Excel telles que la création, l'édition et la sécurisation de fichiers Excel en utilisant C#.

Existe-t-il une version d'essai de IronXL disponible pour les tests?

IronXL propose une version d'essai gratuite qui vous permet de tester toutes les fonctionnalités de la bibliothèque pendant 30 jours sans aucun coût.

Jordi Bardia
Jordi Bardia
  Discutez maintenant avec l'équipe d'ingénierie
Ingénieur logiciel
Jordi est le plus compétent en Python, C# et C++, et lorsqu'il ne met pas à profit ses compétences chez Iron Software, il programme des jeux. Partageant les responsabilités des tests de produit, du développement de produit et de la recherche, Jordi apporte une immense valeur à l'amé...
Lire la suite

Articles connexes

Essai de 30 jours → Produit complet. Pas de limites. Pas de carte. Démarrer l'essai gratuit