Een vervolgkeuzelijst maken in Excel

PDF download Pdf downloaden
PDF download Pdf downloaden

Het gebruiken van een vervolgkeuzelijst in een Microsoft Excel spreadsheet kan het invoeren van gegevens vaak een stuk efficiënter en eenvoudiger maken, waarnaast het ook mogelijk is om een beperkt aantal mogelijke waarden aan te geven welke kunnen worden ingevoerd. Neem de volgende stappen om te leren hoe je een vervolgkeuzelijst kunt maken in Excel 2013 en eerdere versies.

Methode 1
Methode 1 van 2:

Excel 2013

PDF download Pdf downloaden
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6b\/Create-a-Drop-Down-List-in-Excel-Step-1-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-1-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Create-a-Drop-Down-List-in-Excel-Step-1-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-1-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\/4\/4d\/Create-a-Drop-Down-List-in-Excel-Step-2-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-2-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4d\/Create-a-Drop-Down-List-in-Excel-Step-2-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-2-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\/2\/2e\/Create-a-Drop-Down-List-in-Excel-Step-3-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-3-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2e\/Create-a-Drop-Down-List-in-Excel-Step-3-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-3-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Elk item komt in een eigen cel, en in dezelfde kolom. Bijvoorbeeld, als je een vervolgkeuzelijst wilt maken met een lijst van sporten, typ dan "honkbal" in cel A1, "basketbal" in cel A2, "voetbal" in cel A3, enzovoort.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a2\/Create-a-Drop-Down-List-in-Excel-Step-4-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-4-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a2\/Create-a-Drop-Down-List-in-Excel-Step-4-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-4-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\/6\/62\/Create-a-Drop-Down-List-in-Excel-Step-5-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-5-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/62\/Create-a-Drop-Down-List-in-Excel-Step-5-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Selecteer Name (Naam) en daarna Define (Bepalen).
  6. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4f\/Create-a-Drop-Down-List-in-Excel-Step-6-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-6-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4f\/Create-a-Drop-Down-List-in-Excel-Step-6-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    De naam die je kiest is alleen ter referentie, en wordt niet weergegeven in het werkblad.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/4\/4a\/Create-a-Drop-Down-List-in-Excel-Step-7-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-7-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/4a\/Create-a-Drop-Down-List-in-Excel-Step-7-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-7-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\/4\/49\/Create-a-Drop-Down-List-in-Excel-Step-8-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-8-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/49\/Create-a-Drop-Down-List-in-Excel-Step-8-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Het bijbehorende dialoogvenster.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e1\/Create-a-Drop-Down-List-in-Excel-Step-9-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-9-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e1\/Create-a-Drop-Down-List-in-Excel-Step-9-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-9-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\/5\/51\/Create-a-Drop-Down-List-in-Excel-Step-10-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-10-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/51\/Create-a-Drop-Down-List-in-Excel-Step-10-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Ga naar het vakje "Source" (Bron), en typ een is-gelijk teken, gevolgd door de naam die je aan de vervolgkeuzelijst hebt gegeven. Bijvoorbeeld, als je de vervolgkeuzelijst "Sporten" hebt genoemd, typ dan "=Sporten."
  11. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7c\/Create-a-Drop-Down-List-in-Excel-Step-11-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-11-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7c\/Create-a-Drop-Down-List-in-Excel-Step-11-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-11-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\/4\/48\/Create-a-Drop-Down-List-in-Excel-Step-12-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-12-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/4\/48\/Create-a-Drop-Down-List-in-Excel-Step-12-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Plaats een vinkje naast "Ignore blank" (Lege cellen negeren) als je de gebruiker van het werkblad de optie wilt geven om geen van de items in de vervolgkeuzelijst te kiezen.
  13. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/fe\/Create-a-Drop-Down-List-in-Excel-Step-13-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-13-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fe\/Create-a-Drop-Down-List-in-Excel-Step-13-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  14. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/b\/b6\/Create-a-Drop-Down-List-in-Excel-Step-14-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-14-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/b\/b6\/Create-a-Drop-Down-List-in-Excel-Step-14-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Plaats een vinkje naast "Show error alert after invalid data is entered" (Foutmelding geven na het invoeren van ongeldige gegevens). Dit voorkomt dat gebruikers gegevens invoeren die niet in de lijst voorkomen. Als je wilt dat gebruikers hun eigen gegevens kunnen invoeren, vink het veld dan niet aan.
  15. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/f\/f5\/Create-a-Drop-Down-List-in-Excel-Step-15-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-15-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f5\/Create-a-Drop-Down-List-in-Excel-Step-15-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    De vervolgkeuzelijst is nu beschikbaar in het werkblad.
    Advertentie
Methode 2
Methode 2 van 2:

Excel 2010, 2007 en 2003

PDF download Pdf downloaden
  1. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/7\/7f\/Create-a-Drop-Down-List-in-Excel-Step-16-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-16-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7f\/Create-a-Drop-Down-List-in-Excel-Step-16-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-16-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\/1\/1e\/Create-a-Drop-Down-List-in-Excel-Step-17-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-17-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Create-a-Drop-Down-List-in-Excel-Step-17-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-17-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\/e\/e5\/Create-a-Drop-Down-List-in-Excel-Step-18-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-18-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e5\/Create-a-Drop-Down-List-in-Excel-Step-18-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Elk item komt in een eigen cel, en in dezelfde kolom. Bijvoorbeeld, als je een vervolgkeuzelijst wilt maken met een lijst van sporten, typ dan "honkbal" in cel A1, "basketbal" in cel A2, "voetbal" in cel A3, enzovoort.
  4. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6d\/Create-a-Drop-Down-List-in-Excel-Step-19-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-19-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6d\/Create-a-Drop-Down-List-in-Excel-Step-19-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-19-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\/8\/8f\/Create-a-Drop-Down-List-in-Excel-Step-20-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-20-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/8f\/Create-a-Drop-Down-List-in-Excel-Step-20-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-20-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\/7\/7d\/Create-a-Drop-Down-List-in-Excel-Step-21-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-21-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/7d\/Create-a-Drop-Down-List-in-Excel-Step-21-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    De naam die je kiest is alleen ter referentie, en wordt niet weergegeven in het werkblad.
  7. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/6\/6b\/Create-a-Drop-Down-List-in-Excel-Step-22-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-22-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6b\/Create-a-Drop-Down-List-in-Excel-Step-22-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-22-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\/e\/e5\/Create-a-Drop-Down-List-in-Excel-Step-23-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-23-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e5\/Create-a-Drop-Down-List-in-Excel-Step-23-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-23-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Klik op het tabblad "Data" (Gegevens) en selecteer "Data Validation" (Gegevensvalidatie) in de groep "Data Tools" (Hulpmiddelen voor gegevens). Het bijbehorende dialoogvenster verschijnt.
  9. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/d\/d8\/Create-a-Drop-Down-List-in-Excel-Step-24-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-24-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/d8\/Create-a-Drop-Down-List-in-Excel-Step-24-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-24-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\/0\/08\/Create-a-Drop-Down-List-in-Excel-Step-25-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-25-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/08\/Create-a-Drop-Down-List-in-Excel-Step-25-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-25-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\/8\/83\/Create-a-Drop-Down-List-in-Excel-Step-26-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-26-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/83\/Create-a-Drop-Down-List-in-Excel-Step-26-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-26-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Ga naar het vakje "Source" (Bron), en typ een is-gelijk teken, gevolgd door de naam die je aan de vervolgkeuzelijst hebt gegeven. Bijvoorbeeld, als je de vervolgkeuzelijst "Sporten" hebt genoemd, typ dan "=Sporten."
  12. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/0\/0c\/Create-a-Drop-Down-List-in-Excel-Step-27-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-27-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/0\/0c\/Create-a-Drop-Down-List-in-Excel-Step-27-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-27-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\/c\/cf\/Create-a-Drop-Down-List-in-Excel-Step-28-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-28-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/c\/cf\/Create-a-Drop-Down-List-in-Excel-Step-28-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-28-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Plaats een vinkje naast "Ignore blank" (Lege cellen negeren) als je de gebruiker van het werkblad de optie wilt geven om geen van de items in de vervolgkeuzelijst te kiezen.
  14. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/5\/54\/Create-a-Drop-Down-List-in-Excel-Step-29-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-29-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/54\/Create-a-Drop-Down-List-in-Excel-Step-29-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-29-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
  15. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/e\/e0\/Create-a-Drop-Down-List-in-Excel-Step-30-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-30-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/e\/e0\/Create-a-Drop-Down-List-in-Excel-Step-30-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-30-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    Plaats een vinkje naast "Show error alert after invalid data is entered" (Foutmelding geven na het invoeren van ongeldige gegevens). Dit voorkomt dat gebruikers gegevens invoeren die niet in de lijst voorkomen. Als je wilt dat gebruikers hun eigen gegevens kunnen invoeren, vink het veld dan niet aan.
  16. {"smallUrl":"https:\/\/www.wikihow.com\/images_en\/thumb\/a\/a6\/Create-a-Drop-Down-List-in-Excel-Step-31-Version-2.jpg\/v4-460px-Create-a-Drop-Down-List-in-Excel-Step-31-Version-2.jpg","bigUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/a6\/Create-a-Drop-Down-List-in-Excel-Step-31-Version-2.jpg\/v4-728px-Create-a-Drop-Down-List-in-Excel-Step-31-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"<div class=\"mw-parser-output\"><\/div>"}
    De vervolgkeuzelijst is nu beschikbaar in het werkblad.
    Advertentie

Tips

  • Ben je klaar met je vervolgkeuzelijst, open deze dan om er zeker van te zijn dat alle items die je hebt ingevoerd kloppen. In sommige gevallen kan het nodig zijn de kolom te verbreden om de gegevens in de cellen helemaal te laten zien.
  • Tijdens het typen van de lijst, typ je ze in de volgorde waarin ze in de vervolgkeuzelijst moeten komen te staan. Bijvoorbeeld, typ de items in alfabetische volgorde om het makkelijker te maken voor de gebruikers van het werkblad om bepaalde waarden te vinden.
Advertentie

Waarschuwingen

  • Het is niet mogelijk om het "Data Validation"-menu te openen, als het werkblad is beveiligd of gelinkt aan een "SharePoint"-website. Is dit het geval, verwijder dan de bescherming, zorg dat delen uitstaat, of verbreek de link met de SharePoint-website, en probeer het nogmaals.


Advertentie

Gerelateerde artikelen

Torrents gebruiken
Een Word‐document opslaan als jpeg
Een map beveiligen met een wachtwoord
Een dvd rippen met VLC Media Player
Gratis games downloaden voor de Nintendo DS
Een USB stick formatteren als dat niet lukt met Windows
Een ZIP‐bestand maken
Alfabetisch sorteren in Excel
VLC Media Player downloaden en installeren
DLL bestanden openen
Draaitabellen maken in Excel
Van een horizontale lijn afkomen in MS Word
Advertentie

Bronnen

  1. http://office.microsoft.com/en-us/excel-help/create-a-drop-down-list-HA102809802.aspx
  2. http://office.microsoft.com/en-us/excel-help/create-or-remove-a-drop-down-list-HP010342357.aspx

Over dit artikel

In andere talen
Deze pagina is 31.943 keer bekeken.

Was dit artikel nuttig?

Advertentie