Want to create drop down lists in Excel like this; Lets walk through it step by step in the above example; In our example that will be =INDIRECT(“Invited”) Now you will be able to use the drop down menu to choose any name from that table into the cell range you have chosen. Please browse … Continue reading How to create drop down lists in Excel