Forum Discussion

trodgers's avatar
trodgers
Copper Contributor
Sep 24, 2020

Data validation problem

In Office 365 my student cannot create a dropdown menu using Data Validation. When choosing Settings > Allow > List, the Source field will not accept a range of values (for example =$B$4:$B$8). This ...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Sep 24, 2020

trodgers 

Maybe this information can help you...

Excel Data Validation Examples

See the file "Data Validation Exambles.xlsx"

Link:

https://support.microsoft.com/en-gb/office/apply-data-validation-to-cells-29fecbcc-d1b9-42c1-9d76-eff3ce5f7249?ui=en-us&rs=en-gb&ad=gb

 

Microsoft gives this info for: Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web Excel 2019 Excel 2016 Excel 2019 for Mac Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Starter 2010.

 

Thank you for letting me offer you my help, I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

 

zenluiz's avatar
zenluiz
Copper Contributor
Aug 11, 2023
This doesn't solve the OP's answer. I have the same one btw.
  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Aug 12, 2023

    zenluiz 

    Depends on where do you keep your file. For OneDrive or SharePoint it shall work.

Resources