Dec 02, 2021 · Q22. You want to be able to restrict values allowed in a cell and need to create a drop-down list of values from which users can choose. Which feature should you use? Protect Worksheet; Conditional Formatting; Allow Users to Edit Ranges; Data Validation; Q23. Aug 16, 2017 · Excel data validation tips. Now that you know the basics of data validation in Excel, let me share a few tips that can make your rules a whole lot more effective. Excel data validation based on another cell. Instead of typing values directly in the criteria boxes, you can enter them in some cells, and then refer to those cells.