Microsoft Excel — dropdown list

Microsoft Excel is a common tool for us. It has a lot of function and formatting.

You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow, and then clicks an entry in the list.

1. Select the cells that you want to contain the lists.