Cellen vergrendelen in Excel

Pdf downloaden
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 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 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
Tekst doorhalen in Word
Een komma veranderen in een punt in Excel
De beveiliging verwijderen van een Excel bestand
Het eurosymbool typen
Twee Excel bestanden vergelijken
Verborgen rijen weer zichtbaar maken in Excel
Een krant maken in Word
Getallen van elkaar aftrekken in Excel
Opmerkingen verwijderen of verbergen in een Worddocument
Een tekstvak maken in Google Documenten
Twee spreadsheets samenvoegen in Excel
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 5.678 keer bekeken.

Was dit artikel nuttig?

Advertentie