This blog article provides step-by-step instructions of allowing entries in Excel worksheet which are not yet part of the data validation. This trick will allow to enter data beyond data validation range. 

Data validation is used mostly to restrict the type of data. Data validation won't allow to enter invalid data. 

Let's discuss step-by-step.

Explore the 'intermediate data management program' using this link:

https://rajeshpathak.graphy.com/courses/Basic-to-Intermediate-Level-Excel-Program-1707484305859-65c62491e4b03a6f9f798be6