How to Remove Data Validation in Microsoft Excel

Показать описание

In this video I'll show you how to remove data validation in a Microsoft Excel spreadsheet.

Timestamps:
Introduction: 0:00
Steps to Remove Data Validation in Microsoft Excel: 0:39
Conclusion: 1:55

Video Transcript:
Using data validation in your Microsoft Excel spreadsheet makes it easy to control the data that ultimately gets entered into your spreadsheet. However, whether you inherited an Excel document from someone else and you don't want to use data validation to collect information, or you want to remove all of the existing data validation in your spreadsheet and start again, Microsoft makes it relatively easy to remove data validation in Excel.

Now let's walk through the steps to remove data validation in a Microsoft Excel spreadsheet.

Step 1. Open the Microsoft Excel document that contains data validation you want to remove.

Step 2. If you have specific cells you want to remove data validation from you'll need to hold down the "Control" key, and then click each of those cells to highlight them individually. Alternatively, in this spreadsheet I want to remove data validation from the entire spreadsheet, so I'll click the "Select All" button in the top left corner of the Excel spreadsheet.

Step 3. Click to select "Data" in the menu along the top of the screen. You'll see Data options displayed in the ribbon toolbar.

Step 4. Navigate to the Data Tools section, and then click "Data Validation." If you get a message letting you know that some cells don't contain data validation, just click "Yes" to continue. The Data Validation window is displayed.

Step 5. Click "Clear All." The Data Validation window closes and you'll return to your spreadsheet, where all of the data validation will now be removed.