To make sure this doesn't happen again, we can add data validation to our spreadsheet.Data validation allows you to control exactly what a user can enter into a cell.
Find all cells with/having data validation in Excel Find cells with/having the same data validation in Excel Also, you can find cells which having the same type data validation in Excel with the Select & Find function. Select a cell with the data validation you want to find in other cells.
You can go to Invoice, Part 1: Free Shipping if you'd like to start from the beginning.
The DATE function is especially useful when supplying dates as inputs to other functions like SUMIFS or COUNTIFS,...
Formulas are the key to getting work done in Excel.
Since we already have a list of shipping options in the Shipping worksheet, we're going to tell Excel to use the data in that list to control which values a user can select.
But before we do this, we'll actually need to name the cell range first.
If you want to find cells which having the data validation, you may need to click on the cell to show the arrow one by one for confirmation if you have no efficient method. In the Go To Special dialog box, check the Data validation and Same options, and finally click the OK button.
Actually, with the Excel build-in function - Find & Select, finding cells with data validation is getting easier in your work. See screenshot: Then all cells with the same type data validation as the selected cell are selected immediately.
In this step-by-step training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges.
You'll also learn how to troubleshoot, trace errors, and fix problems.
This kind of data validation allows you to build a powerful, fool-proof spreadsheet.