Loading suggested videos
Data Validation.Settings tab, then under Allow, choose Any Value.OK to confirm and apply the change.Result: The selected cells will no longer be restricted — users can now type any value freely.
Tip: If you don’t see the Data Validation option, make sure the worksheet isn’t protected or locked.
Your feedback helps us improve our content.