Excel: Create list fields with multiple selection

It often makes sense to create a multiple selection in Excel lists. Especially when the same terms keep popping up or users should only have certain choices. For example, a multiple selection can be used to select which employee has taken on a shift.

Excel: Create area for multiple selection

If you want to create a multiple selection in an Excel list, you must first define a range in which the values ​​for the selection are.

• To do this, mark the relevant area and right-click on it.
• Then select the menu item "Name area".
• In the window, enter a name for the area under "Name" and click "OK".

Excel: Link the multiple selection to the list area

Now you just have to select a cell for the multiple selection and link it to the area just defined.

• Select the cell in which the multiple selection should be located.
• In the "Data" tab, click on "Data verification".
• In the window that appears, you must now select "List".
• Then, under "Source", write "= Name of your area" and click "OK".