How to cancel the drop-down option in excel Tutorial on how to cancel the drop-down option in excel

How to cancel the drop-down option in excel? In fact, the method is very simple. Users can directly select the excel page in the open mode, and then open the data verification under the data tool to perform the operation. Let this site provide users with a detailed tutorial on how to cancel the excel drop-down option. Tutorial on how to cancel the excel drop-down option 1. In the first step, we right-click the table, then click the Open With option in the menu list, and then select the Excel option in the submenu list.

2. In the second step, after entering the Excel page, we select the entire table on the page, and then click to open the data tool in the toolbar.

3. In the third step, in the sub-toolbar of the data tool, we find the data verification option and click to open this option.

4. Step 4. After clicking the data verification tool, we click the OK option in the pop-up box of whether to clear the current settings and continue.

5. Step 5: After clicking the OK option in the whether to clear current settings and continue pop-up box, we then click the Clear All option in the data verification pop-up box, and finally click the OK option That’s it.

The above is the detailed content of How to cancel the drop-down option in excel Tutorial on how to cancel the drop-down option in excel. For more information, please follow other related articles on the PHP Chinese website!