Get instant live Excel expert help to learn how to add data validation in excel

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

Hello I wanted to know how to use data validation but to restrict the data for a letter. For example restrict the data in cell B4 to S or D
Solved by A. H. in 22 mins
I have a problem regarding to Excel DATA VALIDATION using ISNUMBER and FIND Function
Solved by D. H. in 21 mins
I need apply to INDIRECT functions to the data validation formula box
Solved by X. B. in 11 mins
In cells A2 to A51 the following 3 values are permitted via data validation drop down list A B (Blank Cell) Requirement: If value is changed to blank or A in cells A2 toA51, then the corresponding column AG must be cleared. Example: A25 changed to blank, then AG25 contents must be cleared.
Solved by M. U. in 26 mins
I can't use data validation on the certain cells that I am trying to select. What is causing this issue?
Solved by B. F. in 19 mins
I need help with data validation for an excel cell drop down list
Solved by O. S. in 11 mins
I have created a drop down menu using data validation. The list that I used as the source for that data validation has different coloured cells, but the coulors havent transfered over to the drop down menu. How do I do that?
Solved by K. L. in 25 mins
I created a data validation list for different types of accommodation, and I want the next cell to automatically lost the price for that type of room. So I attempted an IF formula, but I need multiple options and I don't know how to do that!
Solved by S. E. in 14 mins
I choose "list" on the data validation window. Next, I press F3 to introduce the source, but the F3 key is not working. It just changes the brightness of my screen instead. Please help me with how to get the F3 key to work.
Solved by A. F. in 21 mins
hi I would like to extend the data validation but I dont know how to range it please help thanks
Solved by E. Y. in 18 mins