Hi, Xor,
Do I have to select a cell with a prompt before I do that? I'm trying to follow your directions and this is what I did:
Selected cell with prompt.
Pressed F5.
Clicked on Special...
Clicked on Data Validation. All will automatically be selected.
Clicked OK.
And that does nothing. Where did I go wrong? There was no option to clear all data validation. Please see attached screenshot.
|