There are several different ways you can remove data validation from cells:
1) Using the (Edit > Paste) or shortcut key (Ctrl + V) to paste new data over the top u
2) Using the (Edit > Clear > All) menu.

Using (Edit > Paste)

Using (Edit > Clear > All)


You can remove data validation by pressing F5, clicking Special. Select (Data > Validation) OK. Then select (Data > Validation) and select "Clear All" ??

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext