Why the Excel table cannot be filtered? What is the solution to the problem that the filtering function in the table cannot be used normally?

Many users use Excel spreadsheet software for data processing. It is powerful and very convenient to use. However, recently some users have found that they cannot click when using the filtering function of the software. What should they do if the Excel spreadsheet cannot filter? In response to this problem, this article brings a detailed solution to share with everyone. Why can't the Excel table be filtered? 1. The worksheet is protected. If the worksheet is protected and filtering is restricted, filtering is not possible. Solution: Unprotect: Click the "Tools" menu, execute the "Protect" command, select "Unprotect Workbook" in the menu, enter the set password in the pop-up password field, and click OK to unprotect. 2. The object is hidden. Tools-Options-View-Objects-Hide all objects. If the above operation is performed, filtering will not be possible. Solution: To unhide, you need to right-click on the worksheet label, and then select the Unhide option. A dialog box will pop up, select the worksheet that needs to be unhidden, and then click OK. 3. There may be merged cells in the table. Solution: After opening the excel file, when we filter you, you will not be able to filter because there are already merged cells. Then unmerge the merged cells and select the data to be filtered. After selecting the data, click the [Filter] function under [Sort and Filter] to filter the data. The Excel table filter cannot be used. Solution: 1. It may be that there are merged cells in the table. After opening the excel file, we When you are filtering, you will not be able to filter because there are merged cells, as shown below:

Then unmerge the merged cells and select the data to be filtered. as the picture shows.

After selecting the data, click the [Filter] function under [Sort and Filter] to filter the data. as the picture shows.

2. It is impossible to filter when the data is protected. After we open the excel file, select the data and click [Sort and Filter] to be invalid, because the table can only be viewed and cannot be operated.

Then we click on the Review tab and click [Unprotect Worksheet] under Review.

Then the [Unprotect Worksheet] dialog box pops up, enter the password in the password, and click [OK] to filter.

The above is the detailed content of Why the Excel table cannot be filtered? What is the solution to the problem that the filtering function in the table cannot be used normally?. For more information, please follow other related articles on the PHP Chinese website!