Excel: how to create a drop-down list

The most straightforward method for making a drop-down list in Excel 2013/2016 includes posting the decisions in an exchange box. This technique works best in the event that you will make only a couple of cells with drop-down records, on the grounds that to change the decisions you would need to alter each cell where it shows up. However, for straightforward circumstances, it’s an extraordinary technique.

Follow the means in the video above, or:

• From the DATA tab, select Data Validation.
• Click Data Validation in the drop-down list.
• In the exchange box, select List from the Allow drop-down menu.
• In the source field, type the decisions you’d like your drop down menu to incorporate, isolated by commas. (Note: leave “Overlook clear” checked assuming you maintain that clear cells should be permitted.)
• Click OK.

Presently, accounting sheet clients will be incited to choose starting from the drop menu while entering information into that phone. Duplicate the unfilled box to different cells to incorporate the drop-down menu there.