Removing

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)


SS


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





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