In Microsoft excel, can I do a large multi select list?

In Microsoft excel, can I do a large multi select list?

Hi,

Yes you can do multiple select by simple way just click on the cell from where you want to select and then press shift and select till you wanted to.

To accomplish drop down list you have to put formula and there is another way also. Here is the URL for videos by which you will get help how you can do it

https://support.office.com/en-us/article/create-a-drop-down-list-7693307a-59ef-400a-b769-c5402dce407b

http://www.metacafe.com/watch/3423614/create_a_drop_down_list_in_excel/