Excel - Drop-down lists Video

In this video, you will learn about drop-down lists in Microsoft 365. The video covers how to create drop-down lists in Excel to limit the entries people can make in a cell.
By selecting the cell, a drop-down list arrow appears, allowing you to make a selection.
To create drop-down lists, you need to select the cells, go to the Data tab on the ribbon, click Data Validation, set Allow to list, enter the text or numbers in the Source field, and click OK.
Using drop-down lists can help improve data entry accuracy and efficiency.
This tutorial will guide you through the process of creating drop-down lists in Excel, enhancing your data management skills.

0:55
3318 views

Objectifs :

This video aims to teach users how to create drop-down lists in spreadsheet applications to enhance data entry efficiency and accuracy.

Chapitres :

Introduction to Drop-Down Lists
Drop-down lists are a powerful tool in spreadsheet applications that streamline data entry. By limiting the entries that users can make in a cell, these lists not only speed up the process but also reduce the likelihood of errors.
Benefits of Using Drop-Down Lists
Using drop-down lists offers several advantages: - **Increased Speed**: Users can quickly select from predefined options instead of typing. - **Enhanced Accuracy**: Reduces the chances of typos or incorrect entries. - **Consistency**: Ensures that data is entered in a uniform manner across the spreadsheet.
Creating Drop-Down Lists
Follow these steps to create drop-down lists in your spreadsheet: 1. **Select the Cells**: Highlight the cells where you want the drop-down lists to appear. 2. **Access Data Validation**: Navigate to the ribbon at the top of the application, click on the 'Data' tab. 3. **Open Data Validation**: Click on 'Data Validation' to open the dialog box. 4. **Set Allow to List**: In the dialog box, set the 'Allow' option to 'List'. 5. **Define Source**: Click in the 'Source' field and enter the text or numbers you want to appear in the drop-down list. 6. **Confirm**: Click 'OK' to finalize your settings.
Using the Drop-Down Lists
Once you have created the drop-down lists, you can use them by selecting a cell. An arrow will appear next to the cell; click on it to view and select from the available options. This feature makes data entry more efficient and user-friendly.
Conclusion
Creating drop-down lists is a simple yet effective way to improve data entry in spreadsheets. By following the outlined steps, users can enhance their workflow, ensuring that data is entered quickly and accurately. Implementing this feature can significantly impact the overall quality of data management.

FAQ :

What is a drop down list in data entry?

A drop down list is a feature that allows users to select a value from a predefined list, making data entry faster and more accurate by limiting the options available.

How do I create a drop down list in Excel?

To create a drop down list in Excel, select the cells where you want the list, go to the Data tab, click on Data Validation, set Allow to 'List', enter your values in the Source field, and click OK.

Why is data validation important?

Data validation is important because it helps prevent errors in data entry by restricting the type of data that can be entered into a cell, ensuring data integrity.

Can I use numbers in a drop down list?

Yes, you can use both text and numbers in a drop down list when creating it in a spreadsheet application.

Quelques cas d'usages :

Streamlining Data Entry in Surveys

Using drop down lists in survey forms can help ensure that respondents select from predefined options, reducing the likelihood of errors and making data analysis easier.

Inventory Management

In inventory management systems, drop down lists can be used to select product categories or suppliers, improving accuracy and efficiency in tracking stock levels.

Project Management

Project managers can use drop down lists to assign tasks to team members, ensuring that only available team members are selected, which helps in resource allocation.

Financial Reporting

In financial reports, drop down lists can be used to select expense categories, ensuring consistency in reporting and simplifying the review process.

Glossaire :

Data Entry

The process of inputting data into a computer system or database.

Drop Down List

A user interface element that allows users to choose one value from a list of options that appears when the user clicks on it.

Data Validation

A feature in spreadsheet applications that ensures only specific types of data can be entered into a cell.

Source Field

The area where the values for a drop down list are defined, which can include text or numbers.

00:00:04

a drop-down list to limit the entries people can make in a cell.

00:00:09

When you select the cell, the drop-down list down arrow appears,

00:00:14

click it, and make a selection.

00:00:18

Here's how to create drop-down lists.

00:00:21

Select the cells that you want to contain the lists,

00:00:24

on the ribbon, click the Data tab,

00:00:28

and click Data Validation;

00:00:32

in the dialog, set Allow to list, click in Source,

00:00:37

in this example, we're using a comma delimited list.

00:00:41

The text or numbers we type in the Source field

00:00:44

are separated by commas;

00:00:46

and click OK.

00:00:49

The cells now have drop-down lists.

00:00:01

A entrada de dados é mais rápida e precisa quando você usa

00:00:04

uma lista suspensa para limitar as pessoas que podem inserir dados em uma célula.

00:00:09

Ao selecionar a célula, a seta para baixo da lista suspensa aparece;

00:00:14

clique nela e faça a seleção.

00:00:18

Aqui está como criar listas suspensas.

00:00:21

Selecione as células que você deseja que contenham as listas;

00:00:24

na faixa de opções, clique na aba Dados

00:00:28

e clique em Validação de dados.

00:00:32

Na caixa de diálogos, escolha Permitir listar e clique em Fonte;

00:00:37

neste exemplo, estamos usando uma lista delimitada por vírgula.

00:00:41

O texto ou números que digitamos no campo Fonte

00:00:44

são separados por vírgulas;

00:00:46

e clique em OK.

00:00:49

Agora as células têm listas suspensa.

00:00:01

Die Dateneingabe ist schneller und genauer, wenn Sie

00:00:04

Drop-down-Listen verwenden, um die Eingabemöglichkeiten, die in Zellen vorgenommen werden können, begrenzen.

00:00:09

Wenn Sie die Zelle auswählen, erscheint unten in der Drop-down-Liste ein Pfeil nach unten.

00:00:14

Klicken Sie darauf und nehmen Sie eine Auswahl vor.

00:00:18

Hier sehen Sie, wie Sie Drop-down-Listen anlegen können.

00:00:21

Wählen Sie die Zellen, die in den Listen enthalten sein sollen,

00:00:24

auf dem Band und klicken Sie auf die Registerkarte „Daten”

00:00:28

und dann auf „Datenüberprüfung”.

00:00:32

Im Dialog stellen Sie „Zulassen” in der Liste ein und klicken dann in diesem Beispiel,

00:00:37

in dem Sie eine durch Kommas getrennte Liste verwenden, auf „Quelle”.

00:00:41

Text oder Zahlen, die wir in das Quellenfeld eingeben,

00:00:44

werden durch Kommas getrennt,

00:00:46

und klicken Sie auf „OK”.

00:00:49

Die Zellen haben jetzt Drop-down-Listen.

00:00:01

La entrada de datos es más rápida y precisa cuando se usa una

00:00:04

lista desplegable para limitar qué entradas se pueden hacer en una celda.

00:00:09

Al seleccionar la celda, aparece la flecha de la lista desplegable.

00:00:14

Haga clic en ella y realice una selección.

00:00:18

A continuación, veremos cómo crear listas desplegables.

00:00:21

Seleccione las celdas que desea que contengan las listas;

00:00:24

en la cinta, haga clic en la pestaña Datos

00:00:28

y en Validación de datos.

00:00:32

En el cuadro de diálogo, elija Permitir y Lista, y haga clic en Origen.

00:00:37

En este ejemplo, estamos utilizando una lista delimitada por comas.

00:00:41

El texto o los números que escribimos en el campo Origen

00:00:44

están separados por comas.

00:00:46

Haga clic en Aceptar.

00:00:49

Ahora las celdas tienen listas desplegables.

00:00:01

Gegevens invoeren gaat sneller en nauwkeuriger wanneer u een keuzelijst

00:00:04

gebruikt om het aantal gegevens te beperken die mensen in een cel kunnen invoeren.

00:00:09

Wanneer u de cel selecteert, verschijnt het pijltje waarmee u de keuzelijst kunt openen. Klik erop

00:00:14

en maak uw keuze.

00:00:18

U maakt zo'n keuzelijst als volgt.

00:00:21

Selecteer de cellen waarvoor u de lijst wilt maken en klik op het

00:00:24

Gegevens-tabblad, op het lint,

00:00:28

en klik op gegevensvalidatie.

00:00:32

Kies in het venster bij Toestaan voor lijst en kies bij Bron,

00:00:37

in dit voorbeeld, voor met komma gescheiden lijst.

00:00:41

De tekst of de nummers die we in het bronveld intypen,

00:00:44

worden gescheiden met komma's

00:00:46

en klik op OK.

00:00:49

Nu hebben de cellen keuzelijsten.

00:00:01

L'immissione dei dati è più rapida e più preciso quando si utilizza .

00:00:04

un elenco a discesa per limitare le persone possono fare in una cella..

00:00:09

Quando si seleziona la cella, viene visualizzata la freccia a discesa,.

00:00:14

fare clic su di esso ed effettuare una selezione.

00:00:18

Ecco come creare elenchi a discesa.

00:00:21

Selezionare le celle vogliono contenere le liste,.

00:00:24

sulla barra multifunzione, fare clic sulla scheda Dati,

00:00:28

e fare clic su Convalida dati;

00:00:32

nella finestra di dialogo, impostare Consenti per elencare, fare clic su Sorgente,.

00:00:37

in questo esempio, stiamo usando un elenco delimitato da virgole..

00:00:41

Il testo o i numeri che digitare nel campo Origine.

00:00:44

sono separati da virgole;

00:00:46

e fare clic su OK.

00:00:49

Le celle ora hanno elenchi a discesa.

00:00:01

資料輸入更快，使用時更準確.

00:00:04

下拉清單，以限制人們可以在儲存格中輸入的條目。.

00:00:09

當您選擇儲存格時，出現下拉清單下箭頭，.

00:00:14

按一下它，並做出選擇。

00:00:18

下面列出了創建下拉清單。

00:00:21

選擇您想要包含清單，.

00:00:24

在功能區上，按一下"資料"選項卡，

00:00:28

並按一下"資料驗證";

00:00:32

在對話方塊中，設置"允許" 要列出，請按一下"源"，.

00:00:37

在此示例中，我們使用逗號分隔清單。.

00:00:41

我們的文本或數位在"源"欄位中鍵入.

00:00:44

用逗號分隔;

00:00:46

然後按一下"確定"。

00:00:49

儲存格現在具有下拉清單。

00:00:01

データ入力が速く、使用する場合は、より正確.

00:00:04

を制限するドロップダウンリストユーザーがセル内で作成できるエントリ。.

00:00:09

セルを選択すると、ドロップダウンリスト下の矢印が表示され、.

00:00:14

クリックして選択します。

00:00:18

ドロップダウンリストを作成する方法は次の通りです。

00:00:21

自分のセルを選択します。リストを含めたいと思っています。.

00:00:24

リボンで、[データ] タブをクリックします。

00:00:28

をクリックし、[データの検証] をクリックします。

00:00:32

ダイアログボックスで、[許可] を設定します。一覧表示するには、[ソース] をクリックします。.

00:00:37

この例では、カンマ区切りリスト。.

00:00:41

テキストまたは数値 [ソース] フィールドに入力する.

00:00:44

はコンマで区切られ、カンマで区切られ、コンマで区切

00:00:46

をクリックし、[OK] をクリックします。

00:00:49

これで、セルにドロップダウンリストが作成されました。

00:00:01

Nhập dữ liệu nhanh hơn và chính xác hơn khi bạn sử dụng .

00:00:04

một danh sách thả xuống để giới hạn mục nhập người có thể thực hiện trong một tế bào..

00:00:09

Khi bạn chọn ô, danh sách thả xuống xuống mũi tên xuất hiện,.

00:00:14

nhấp vào nó, và thực hiện một lựa chọn.

00:00:18

Dưới đây là cách tạo danh sách thả xuống.

00:00:21

Chọn các ô mà bạn muốn chứa các danh sách,.

00:00:24

trên ruy băng, bấm vào tab dữ liệu,

00:00:28

và nhấp vào xác nhận dữ liệu;

00:00:32

trong hộp thoại, đặt cho phép vào danh sách, bấm vào nguồn,.

00:00:37

trong ví dụ này, chúng ta đang sử danh sách phân cách bằng dấu phẩy..

00:00:41

Văn bản hoặc số nhập vào trường nguồn.

00:00:44

được phân tách bằng dấu phẩy;

00:00:46

và nhấn OK.

00:00:49

Các ô bây giờ có danh sách thả xuống.

00:00:01

Entri data lebih cepat dan lebih akurat bila Anda menggunakan .

00:00:04

daftar drop-down untuk membatasi entri yang dapat dilakukan orang dalam sel..

00:00:09

Bila Anda memilih sel, daftar drop-down panah bawah muncul,.

00:00:14

Klik, dan membuat pilihan.

00:00:18

Berikut adalah cara membuat daftar drop-down.

00:00:21

Pilih sel yang Anda ingin berisi daftar,.

00:00:24

pada pita, klik tab data,

00:00:28

dan klik validasi data;

00:00:32

dalam dialog, setel Izinkan ke daftar, klik di sumber,.

00:00:37

dalam contoh ini, kita sedang menggunakan Daftar koma terbatas..

00:00:41

Teks atau angka yang kita ketik di bidang sumber.

00:00:44

dipisahkan dengan koma;

00:00:46

dan klik OK.

00:00:49

Sel sekarang memiliki daftar drop-down.

00:00:01

Ввод данных быстрее и более точным при использовании .

00:00:04

список отсева, чтобы ограничить записи люди могут сделать в ячейке..

00:00:09

При выборе ячейки появляется выпадают из списка вниз стрелка,.

00:00:14

нажмите на него, и сделать выбор.

00:00:18

Вот как создать списки отсева.

00:00:21

Выберите ячейки, которые вы хотите содержать списки,.

00:00:24

на ленте нажмите на вкладку Данных,

00:00:28

и нажмите Проверка данных;

00:00:32

в диалоге, установить Разрешить список, нажмите в Источник,.

00:00:37

в этом примере мы используем запятой делимитирован список..

00:00:41

Текст или цифры, которые мы тип в поле Источника.

00:00:44

разделены запятыми;

00:00:46

и нажмите OK.

00:00:49

Теперь у ячеек есть списки выпадают.

00:00:01

Въвеждането на данни е по-бързо и по-точни, когато използвате .

00:00:04

падащ списък, за да записи, които хората могат да правят в клетка..

00:00:09

Когато изберете клетката, се появява стрелката надолу по падащия списък,.

00:00:14

щракнете върху него и направете избор.

00:00:18

Ето как да създадете падащи списъци.

00:00:21

Изберете клетките, които искате да съдържа списъците,.

00:00:24

в лентата щракнете върху раздела Данни,

00:00:28

и щракнете върху "Проверка на данни";

00:00:32

в диалоговия прозорец, задайте Разрешаване , за да изберете списък, щракнете в Източник,.

00:00:37

в този пример използваме списък със запетаи..

00:00:41

Текстът или цифрите, които въведете в полето Източник.

00:00:44

се разделят със запетаи;

00:00:46

и щракнете върху OK.

00:00:49

Клетките вече имат падащи списъци.

00:00:01

Introducerea datelor este mai rapidă și mai precise atunci când utilizați .

00:00:04

o listă verticală pentru a limita intrările pe care oamenii le pot face într-o celulă..

00:00:09

Când selectați celula, apare săgeata în jos a listei verticale,.

00:00:14

faceți clic pe el și faceți o selecție.

00:00:18

Iată să creați liste verticale.

00:00:21

Selectați celulele pe care le doriți să conțină listele,.

00:00:24

pe panglică, faceți clic pe fila Date,

00:00:28

și faceți clic pe Validare date;

00:00:32

în dialog, setați Se permite pentru a lista, faceți clic în Sursă,.

00:00:37

în acest exemplu, folosim o listă delimitată prin virgulă..

00:00:41

Textul sau numerele pe care le tastați în câmpul Sursă.

00:00:44

sunt separate prin virgule;

00:00:46

și faceți clic pe OK.

00:00:49

Celulele au acum liste verticale.

00:00:01

Введення даних швидше і точніше, коли ви використовуєте .

00:00:04

розкривного списку, щоб обмежити записи, які люди можуть зробити у клітинці..

00:00:09

Якщо виділити клітинку, з'явиться стрілка розкривного списку,.

00:00:14

клацніть його та виберіть потрібний фрагмент.

00:00:18

Ось як можна створити розкривні списки.

00:00:21

Виділіть клітинки, які ви хочете містити списки,.

00:00:24

на стрічці перейдіть на вкладку Дані,

00:00:28

і натисніть кнопку Перевірка даних;

00:00:32

у діалоговому вікні, встановіть Дозволити до списку, клацніть у джерелі,.

00:00:37

у цьому прикладі ми використовуємо список, у який позначено комами..

00:00:41

Текст або номери, які ми введіть у полі Джерело.

00:00:44

розділяються комами;

00:00:46

і натисніть кнопку ОК.

00:00:49

Тепер клітинки мають розкривні списки.

00:00:01

Veri girişi daha hızlı dır ve kullandığınızda daha doğru .

00:00:04

sınırlamak için bir açılır liste kişilerin bir hücrede yapabilecekleri girişler..

00:00:09

Hücreyi seçtiğinizde, açılan liste aşağı ok görünür,.

00:00:14

tıklatın ve bir seçim yapın.

00:00:18

Açılır listeler şu şekilde oluşturulur.

00:00:21

Sahip olduğunuz hücreleri seçin listeleri kontrol altına almak istiyorsanız,.

00:00:24

şeritte, Veri sekmesini tıklatın,

00:00:28

ve Veri Doğrulama'yı tıklatın;

00:00:32

iletişim kutusunda, İzin Ver'i ayarlayın listelemek için Kaynak'a tıklayın,.

00:00:37

bu örnekte, virgül delimited listesi..

00:00:41

Metin veya sayılar biz Kaynak alanına yazın.

00:00:44

virgülle ayrılır;

00:00:46

ve Tamam'ı tıklatın.

00:00:49

Hücrelerin artık açılır listeleri var.

00:00:01

A entrada de dados é mais rápida e mais preciso quando se usa .

00:00:04

uma lista de drop-down para limitar o entradas que as pessoas podem fazer numa cela..

00:00:09

Quando selecionar a célula, a lista de queda para baixo seta aparece,.

00:00:14

clique nele, e fazer uma seleção.

00:00:18

Eis como criar listas de desistel.

00:00:21

Selecione as células que quer conter as listas,.

00:00:24

na fita, clique no separador Dados,

00:00:28

e clicar na Validação de Dados;

00:00:32

no diálogo, definir Permitir para listar, clique na Fonte,.

00:00:37

neste exemplo, estamos a usar uma lista delimitada de vírgula..

00:00:41

O texto ou números que tipo no campo Fonte.

00:00:44

são separados por vírgulas;

00:00:46

e clique ok.

00:00:49

As células agora têm listas de espera.

00:00:01

Unos podataka je brži i preciznije kada koristite .

00:00:04

padajuću listu da biste ograničili unose koje osobe mogu da naprave u ćeliji..

00:00:09

Kada izaberete ćeliju, pojaviće se strelica padajuće liste nadole,.

00:00:14

kliknite na njega i napravite izbor.

00:00:18

Evo kako da kreirate padajuće liste.

00:00:21

Izaberite ćelije koje Želite da zadržite liste,.

00:00:24

Na glavnoj traci izaberite karticu Podaci,

00:00:28

i kliknite na dugme Provera valjanosti podataka;

00:00:32

u dijalogu, podesite Dozvoli da biste naveli, kliknite na dugme Izvor,.

00:00:37

u ovom primeru, koristimo listu razgraničenih zarezima..

00:00:41

Tekst ili brojevi koje vrsta u polju Izvor.

00:00:44

su razdvojeni zarezima;

00:00:46

i kliknite na dugme U redu.

00:00:49

Ćelije sada imaju padajuće liste.

00:00:04

قائمة منسدلة للحد من الإدخالات التي يمكن للأشخاص القيام بها في خلية..

00:00:09

عند تحديد الخلية، يظهر السهم المنسدل للقائمة،.

00:00:14

انقر فوقه، وجعل التحديد.

00:00:18

إليك كيفية إنشاء قوائم منسدلة.

00:00:21

حدد الخلايا التي قمت تريد أن تحتوي على القوائم،.

00:00:24

على الشريط، انقر فوق علامة التبويب بيانات،

00:00:28

وانقر فوق التحقق من صحة البيانات؛

00:00:32

في مربع الحوار ، قم بتعيين السماح للقائمة، انقر فوق في المصدر،.

00:00:37

في هذا المثال، نحن نستخدم قائمة محددة بفاصلة..

00:00:41

النص أو الأرقام التي اكتب في حقل المصدر.

00:00:44

مفصولة بفواصل؛

00:00:46

وانقر فوق موافق.

00:00:49

الخلايا الآن قوائم منسدلة.

00:00:04

드롭다운 리스트는 사람들이 셀에서 만들 수 있는 항목입니다..

00:00:09

셀을 선택하면 드롭다운 목록 다운 화살표가 나타납니다..

00:00:14

클릭하고 선택합니다.

00:00:18

드롭다운 목록을 만드는 방법은 다음과 같습니다.

00:00:21

셀을 선택합니다. 목록을 포함하려면.

00:00:24

리본에서 데이터 탭을 클릭합니다.

00:00:28

데이터 유효성 검사를 클릭합니다.

00:00:32

대화 상자에서 허용 하도록 설정 목록을 클릭하려면 소스를 클릭합니다..

00:00:37

이 예제에서는 쉼표 구분 목록입니다..

00:00:41

텍스트 나 숫자 우리는 소스 필드의 유형.

00:00:44

쉼표로 구분됩니다.

00:00:46

확인을 클릭합니다.

00:00:49

이제 셀에 드롭다운 목록이 있습니다.

00:00:04

用于限制用户可以在单元格中创建的条目。.

00:00:09

选择单元格时，出现下拉列表向下箭头，.

00:00:14

单击它，然后进行选择。

00:00:18

下面介绍了如何创建下拉列表。

00:00:21

选择您喜欢的单元格想要包含列表，.

00:00:24

，单击"数据"选项卡，

00:00:28

，然后单击数据验证;

00:00:32

在对话框中，设置允许要列出，请单击"源".

00:00:37

在此示例中，我们使用以逗号分隔的列表。.

00:00:41

我们的文本或数字在"源"字段中键入.

00:00:44

用逗号分隔;

00:00:46

，然后单击确定。

00:00:49

单元格现在具有下拉列表。

00:00:04

รายการแบบหล่นลงเพื่อจํากัด รายการที่ผู้คนสามารถทําได้ในเซลล์.

00:00:09

เมื่อคุณเลือกเซลล์ ลูกศรลงของรายการแบบหล่นลงจะปรากฏขึ้น.

00:00:14

คลิกและทําการเลือก

00:00:18

ต่อไปนี้เป็นวิธีการสร้างรายการดรอปดาวน์

00:00:21

เลือกเซลล์ที่คุณ ต้องการเก็บรายชื่อ.

00:00:24

บน Ribbon ให้คลิกแท็บ ข้อมูล

00:00:28

แล้วคลิก การตรวจสอบความถูกต้องของข้อมูล

00:00:32

ในกล่องโต้ตอบ ให้ตั้งค่า อนุญาต เมื่อต้องการแสดงรายการ ให้คลิกใน 'แหล่งที่มา'.

00:00:37

ในตัวอย่างนี้, เรากําลังใช้ รายการตัวคั่นด้วยจุลภาค.

00:00:41

ข้อความหรือตัวเลขที่เรา พิมพ์ในเขตข้อมูล 'ต้นทาง'.

00:00:44

จะถูกคั่นด้วยเครื่องหมายจุลภาค

00:00:46

แล้วคลิก ตกลง

00:00:49

ขณะนี้เซลล์มีรายการแบบหล่นลง

Mandarine AI: CE QUI POURRAIT VOUS INTÉRESSER

RELATED COURSES This video is part of the following courses

2109 Views

Video Training Microsoft Excel - Intermediate level

Increase your scope of action with our intermediate tutorials dedicated to formulas, advanced visual enhancement and data analysis with pivo...

ALL COURSES