How to Make a Drop Down List in MS Excel Spreadsheet

Microsoft Excel Spreadsheet is developed by Microsoft for Windows, MacOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.

Drop down lists are actual beneficial especially if you want the users to select an option from the list instead of typing custom values. In MS Excel you can make the drop-down lists of your desired type for the users in an Excel sheet and the process isn't problematic, once you know the way then it’s very easy to implement.

In the steps below, I’ll be showing you that how can you create a drop-down list in MS Excel spreadsheet.

Create Drop-down List:

To crate a drop-down list in MS Excel spreadsheet, follow the steps below,

Step 1: On the second spreadsheet, type the desired items/value of your choice that you want to be appeared in drop-down list.

Step 2: Whereas, on the first sheet select the cell “B1”.

Step 3: On the top “Data Tab”, in the “Data Tools Group” you should click the “Data Validation”.

Step 4: When the Data Validation dialogue box appears, in the allow box click List.

Step 5: Now click the Source box and select the range “A1:A3” on sheet 2 then click OK (If you want to hide sheet 2 from the users simply click sheet 2 and then select hide).

Here's your drop-down list,

If You Enjoyed This, Take 5 Seconds To Share It

• 
• 
• 
• 
• 
•