{"id":15678,"date":"2023-05-15T16:28:10","date_gmt":"2023-05-15T16:28:10","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=15678"},"modified":"2024-03-28T11:36:52","modified_gmt":"2024-03-28T11:36:52","slug":"lock-data-validation-in-excel","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/lock-data-validation-in-excel\/","title":{"rendered":"Lock Data Validation in Excel"},"content":{"rendered":"\n
Locking data validation in Excel is useful to prevent users from changing or deleting the data validation rules you have applied to a cell or range of cells.<\/p>\n\n\n\n
This tutorial shows two techniques for locking data validation in Excel.<\/p>\n\n\n\n
Consider the following dataset with data validation rules applied to cell ranges B2:B10 and C2:C10. The data validation ensures that only specific dates are entered in the cell range B2:B10, and only particular countries are entered in the cell range C2:C10.<\/p>\n\n\n\n