i have an excel and i want to create a drop down menu. if to do it by adding the data of the drop down in different cells and set as source it works. if go to data -->data validation --> list -->chec...
ichatz77 Can you screenshot your Data validation? Since I just choose List and put in Source field yes, no and it works fine with each option is a separate line.
