Cellen vergrendelen in Excel

PDF download Pdf downloaden
PDF download Pdf downloaden

Het vergrendelen van cellen in een Excel-spreadsheet kan voorkomen dat er wijzigingen worden aangebracht in de gegevens of formules die zich in die specifieke cellen bevinden. Cellen die zijn vergrendeld en beveiligd kunnen op elk moment worden ontgrendeld door de gebruiker die de cellen in eerste instantie heeft vergrendeld. Volg de onderstaande stappen om te leren hoe je cellen in Microsoft Excel-versies 2010, 2007 en 2003 kunt vergrendelen en beschermen.

Methode 1
Methode 1 van 2:

Cellen vergrendelen en beschermen in Excel 2007 en Excel 2010

PDF download Pdf downloaden
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/02\/Lock-Cells-in-Excel-Step-1-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-1-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/02\/Lock-Cells-in-Excel-Step-1-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-1-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e1\/Lock-Cells-in-Excel-Step-2-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-2-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e1\/Lock-Cells-in-Excel-Step-2-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/87\/Lock-Cells-in-Excel-Step-3-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-3-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/87\/Lock-Cells-in-Excel-Step-3-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-3-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/82\/Lock-Cells-in-Excel-Step-4-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-4-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/82\/Lock-Cells-in-Excel-Step-4-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-4-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/47\/Lock-Cells-in-Excel-Step-5-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-5-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/47\/Lock-Cells-in-Excel-Step-5-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-5-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/70\/Lock-Cells-in-Excel-Step-6-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-6-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/70\/Lock-Cells-in-Excel-Step-6-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-6-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/9a\/Lock-Cells-in-Excel-Step-7-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-7-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/9a\/Lock-Cells-in-Excel-Step-7-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-7-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/48\/Lock-Cells-in-Excel-Step-8-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-8-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Lock-Cells-in-Excel-Step-8-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-8-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/35\/Lock-Cells-in-Excel-Step-9-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-9-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/35\/Lock-Cells-in-Excel-Step-9-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-9-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d5\/Lock-Cells-in-Excel-Step-10-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-10-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d5\/Lock-Cells-in-Excel-Step-10-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-10-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/3f\/Lock-Cells-in-Excel-Step-11-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-11-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/3f\/Lock-Cells-in-Excel-Step-11-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-11-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a4\/Lock-Cells-in-Excel-Step-12-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-12-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a4\/Lock-Cells-in-Excel-Step-12-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-12-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/05\/Lock-Cells-in-Excel-Step-13-Version-3.jpg\/v4-460px-Lock-Cells-in-Excel-Step-13-Version-3.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/05\/Lock-Cells-in-Excel-Step-13-Version-3.jpg\/v4-728px-Lock-Cells-in-Excel-Step-13-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    De cellen die je hebt geselecteerd worden nu vergrendeld en beschermd, en kunnen alleen worden ontgrendeld door de cellen opnieuw te selecteren en het wachtwoord in te voeren dat je hebt aangegeven.
    Advertentie
Methode 2
Methode 2 van 2:

Cellen vergrendelen en beschermen in Excel 2003

PDF download Pdf downloaden
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4a\/Lock-Cells-in-Excel-Step-14-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Lock-Cells-in-Excel-Step-14-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  2. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/eb\/Lock-Cells-in-Excel-Step-15-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/eb\/Lock-Cells-in-Excel-Step-15-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  3. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d2\/Lock-Cells-in-Excel-Step-16-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d2\/Lock-Cells-in-Excel-Step-16-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/c\/c9\/Lock-Cells-in-Excel-Step-17-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/c9\/Lock-Cells-in-Excel-Step-17-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  5. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/da\/Lock-Cells-in-Excel-Step-18-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/da\/Lock-Cells-in-Excel-Step-18-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/50\/Lock-Cells-in-Excel-Step-19-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-19-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Lock-Cells-in-Excel-Step-19-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-19-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/42\/Lock-Cells-in-Excel-Step-20-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-20-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/42\/Lock-Cells-in-Excel-Step-20-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  8. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/9\/91\/Lock-Cells-in-Excel-Step-21-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-21-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/9\/91\/Lock-Cells-in-Excel-Step-21-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/3\/33\/Lock-Cells-in-Excel-Step-22-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-22-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/3\/33\/Lock-Cells-in-Excel-Step-22-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-22-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  10. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/84\/Lock-Cells-in-Excel-Step-23-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-23-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/84\/Lock-Cells-in-Excel-Step-23-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-23-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/40\/Lock-Cells-in-Excel-Step-24-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-24-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/40\/Lock-Cells-in-Excel-Step-24-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-24-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/8\/88\/Lock-Cells-in-Excel-Step-25-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-25-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/88\/Lock-Cells-in-Excel-Step-25-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-25-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/ae\/Lock-Cells-in-Excel-Step-26-Version-2.jpg\/v4-460px-Lock-Cells-in-Excel-Step-26-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/ae\/Lock-Cells-in-Excel-Step-26-Version-2.jpg\/v4-728px-Lock-Cells-in-Excel-Step-26-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    De cellen die je hebt geselecteerd worden nu vergrendeld en beschermd, en kunnen alleen worden ontgrendeld door de cellen opnieuw te selecteren en het wachtwoord in te voeren dat je hebt aangegeven.
    Advertentie

Tips

  • Als meerdere gebruikers toegang hebben tot je Excel-document, blokkeer dan alle cellen die belangrijke gegevens of complexe formules bevatten, om te voorkomen dat de cellen per ongeluk worden gewijzigd.
  • Als de meerderheid van de cellen in je Excel-document waardevolle gegevens of complexe formules bevatten, overweeg dan het hele document te vergrendelen of te beschermen, en ontgrendel dan de paar cellen die mogen worden gewijzigd.
Advertentie

Gerelateerde artikelen

Een lege pagina in Word verwijderen
Een komma veranderen in een punt in Excel
Twee Excel bestanden vergelijken
Tekst doorhalen in Word
De beveiliging verwijderen van een Excel bestand
Twee spreadsheets samenvoegen in Excel
Verborgen rijen weer zichtbaar maken in Excel
Twee kolommen samenvoegen in Excel
Een achtergrond toevoegen aan een Word‐document
Een krant maken in Word
Automatisch nummers toevoegen aan Excel
Opmerkingen verwijderen of verbergen in een Worddocument
Advertentie

Bronnen

  1. http://www.dummies.com/how-to/content/how-to-protect-cell-data-in-excel-2010.html

Over dit artikel

In andere talen
Deze pagina is 6.157 keer bekeken.

Was dit artikel nuttig?

Advertentie