Site icon Syrus

Excel: how to create a drop-down list

person using MacBook Pro

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:

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.