Leading the way in Microsoft Office Development

Step 1 - Removing Data Validation

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.

Step 2 - Using (Edit > Paste)

Step 3 - 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" ??