1. Click the office icon in the upper left corner of excel, which is the icon marked with a red box.

2. Click the drop-down option, and then click the excel option in the drop-down option.

3. After clicking, the dialog box as shown in the figure will pop up. You can see that a development tool "tab" is displayed on the ribbon. At this point, the box in front of this option is cleared, and click the OK button below.

How to cancel the set options in excel.

Select a blank area, and under the Start option, in Edit, select Clear All.

How to delete a drop-down selection in an excel cell

Set data validity for drop-down options in Excel. To remove the drop-down option, simply change the data validity setting.

Operating system: XP; Software version: Office2007

The method is as follows:

The 1 column has a drop-down option. B, so delete it:

2. Select parts with drop-down options, data and data validity:

3. At this point, you can see the settings of the drop-down options:

4. Change the "sequence" in the permission to "any value":

5. In this way, the drop-down option is deleted:

How to delete cells in the table in PPT20 13, and why there is no right-click option to delete cells.

1. Select the cell to delete.

Right-click and select Delete Row and Delete Column.

How to remove formatting from excel tables

Edit Toolbar-Clear-Clear Format

Ctrl+ 1, choose other number formats, such as universal.

How to set up an excel worksheet Some contents cannot be deleted, while others can be deleted.

First, define the name.

Select the cell to be deleted, and click the menu bar-Insert-Name-Definition (set the cell range definition name to Delete).

Second, positioning.

Edit-Positioning-Reference PositionEnter Delete-OK and press Delete.

How to get rid of the automatic framework in Excel?

In Excel, the solution to how to get rid of the table automatic box is as follows:

1. Open the excel document to be processed.

2. Click the menu tool and select the option.

3. Select the window option of the View tab in the open window.

4. Put the checkmark in front of the grid line.

That's enough.

How to cancel the drop-down list in excel table? This is urgent.

What is the drop-down list? One is formed by automatic data screening, and the other is formed by data validity.

If automatic filtering is formed, it means: Data-Filter-Remove the check in front of automatic filtering.

If data validity is generated, it is: Data-Validity-Click Clear All at the bottom.

How to delete the same entries in EXCEL tables in batches

The simplest method is to sort by ID number (names may have duplicate names), assuming that "ID number is in column A"

1, sort by one column

2. Insert a row (blank) in the first row and a column (B column) after column A..

3. Look at the input "=A2=A 1" in cell B2. Pour it to the bottom, and the following is paved: B3=A2=A 1, B4=A3=A2. ............................................................................................

4. The first line (blank line)-Data-Filter-Select "True"

5. Delete all the whole lines of "ture" (optional), that is, there is no repetition.

Explain, sort first, and put all duplicates together. In the previous cell, it is equal to the next cell. Repeat what is right, and don't repeat what is wrong. This method should be the simplest.

My expressive ability is limited. If you don't understand, you'd better send me the form directly and I'll do it for you. My email address: [email protected]

How to delete redundant blank tables in excel?

Delete blank lines directly

1

First, open the excel table, put the mouse on a blank line, then click the right mouse button and select the Delete menu from the pop-up menu. (as shown in the figure below)

2

In the pop-up deletion confirmation window, select Delete the whole line, and then click OK. (as shown in the figure below)

three

Then repeat the above steps until all blank lines are deleted. (as shown below), this method is suitable for excel tables with few blank lines.

end

Delete blank lines in batch

1

Open the excel table, then hold down the "Ctrl" key on the keyboard, and then click the blank lines with the mouse to select all the blank lines. (as shown in the figure below)

2

After selecting all blank lines, click the right mouse button again and select Delete in the pop-up menu function. (as shown in the figure below)

three

Then in the confirmation window that pops up, select the whole line, and then click OK to delete all blank lines. (See figure 1 and figure 2 below)

end

Find and delete blank lines.

The above two methods are still not fast enough. If there are many blank rows, you can first locate the blank rows and select all the data. (as shown in the figure below)

In all the tools under the Start menu, find the "Find and Select" tool in the upper right corner, click the drop-down icon, and select "Positioning Condition". (as shown in the figure below)

In the Positioning Criteria window, select a null value and click OK. (as shown in the figure below)

After locating conditions, all empty values in the table are selected, then click the right mouse button and select Delete menu. (as shown in the figure below)

In the "Delete OK" window, select "Delete Whole Line" and then click "OK", so that all the located blank lines are deleted successfully. (See figure 1 and figure 2 below)