In Excel, we can prevent user from entering their stuff in cell by using data validation. In this article, we will get rid of data validation list in Excel.
Question: Is there a smart way in Excel to remove data validation list at all in a cell so that I can enter my own values.
The normal way is:
The problem in this approach is too much use of mouse; in order to avoid use of mouse we can use Paste Special.
We need to follow the below steps:
In this way, we can get rid of data validation dropdown list in Excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
Easy to follow direction in the article