OPENING EXCEL ON A WEB PAGE CANNOT BE FILTERED

Plan 1 [New P].

Note [Original]:

1 In safe mode, the effect is even better!

2.All the software to be used below should be installed or upgraded to the latest version to ensure the effectiveness of use.

3.It is not antivirus, and the following methods can be used directly. If it doesn't work, use a high-quality antivirus (e.g. Kaspersky) in safe mode to kill it, and it's best to use 360 Security Guard as well.

Use 360 Security Guard's "Trojan Horse" - Full Scan". Kill and restart. ）

You don't have to use all of the following methods, you can try them one by one. Sometimes, just the first one works.

One. Close the browser, open the "System Repair" of the new version of 360 Security Guard, and select "Home Repair", "System Repair" and "IE Repair" as a tick (you can also select all.) At least select "System Repair"), and then click "One-click Repair".

Too lazy to install it, just use the 360 first aid kit) .

Then use the 360 first aid kit. [Follow the steps: "Start First Aid" first; After scanning, if a Trojan horse appears, click "Isolation"; Then click "Repair" (you can select all of them to Fix Now".

Next, click on "Recover Lost DLL Files", add the missing DLL files that the system detected during detection, and then click "Repair Now". Repair Network is a case-by-case decision to fix or not. When you're done, you should restart.

Two. Scan with 360 Security Guard's "Clean Plugins" to clean up malicious plugins. When you're done, you should restart.

Three. Use Windows Cleanup Assistant (from the web**). After scanning (if you sweep things out, check them all and clean them), then use Fault Repair (select all), and then right-click on the desktop to refresh. Works well in safe mode.

You can also consider using the Kingsoft First Aid Kit [After point scanning, if there are items that can be repaired, after selecting all, point repair can be done. 】

Emphasis ---1In the repair, when there is a prompt in Kill Soft or 360, please click Allow. Restart the computer if prompted to restart during operation.

2.When the effect is not good, look at the three points in "Attention". 3.

After that, if the effect is not good, you can also consider system restoration (choose a restore point).

1. The first step, in the area where there is a merge, cancel the merge, and one of the steps that need to be done is to copy to other blank areas of ** for backup.

2. The second step, after that, in the previous part of the cancel, we select the area, and there is the option to locate a null value, we need to add the content, and the positioning in advance can quickly complete the filling.

3. The third step, the content of the filling, you need to enter it in the formula bar, and it is to hold down the Ctrl and Enter keys, two together, before you can fill in batches, and the content of the filling is equal to the first cell in front.

4. The fourth step, after the batch is filled, because it is the existence of the formula, it needs to be converted to an ordinary value.

5. In the fifth step, the previous reserved in the blank position will work, select the format painter, copy its format, and use it in the data area to achieve a center alignment effect.

6. The sixth step, finally, is to see the actual effect, see if it can be displayed normally after modification, and then carry out a screening.

The worksheet is protected, and if the worksheet is protected and filtering is restricted, it cannot be filtered. Here's how to fix it:

Operating Equipment: Dell Computer.

Operating system: win10

1. In the area where a merge appears, cancel the merge and copy it to other blank areas of ** for backup, as shown in the figure below.

3. Enter, and hold down the Ctrl and Enter keys, as shown in the figure below.

4. Convert to ordinary values, copy and paste them as values, as shown in the figure below.

5. Select the format painter and copy its format, as shown in the figure below.

6. Finally, a screening can be completed, as shown in the figure below.

Check whether several of your tables are in the working group state, which cannot be filtered.

Right-click on the worksheet tab, and if this option exists, click "Ungroup Worksheets".

Turn it off and open it again, try if it's someone else sent you** If you use a different version, there will be such a problem.

The file is incorrect, uninstall it and reinstall the genuine version.

Summary. Dear, hello, 1) There are blank rows in the data, resulting in the following blank rows cannot be screened;

Workaround: Delete blank lines.

2) Filtering has been added to one or more columns of other columns, resulting in only part of the filtered data being seen when the numbered column is selected again;

Solution: You can go to other columns to check whether the filter conditions are added; If you really can't see it, then cancel the automatic filter and add the automatic filter from the menu again.

3) Some rows are manually set to hide, so that this part of the data cannot be seen when selecting filtering;

Solution: Select all rows, right-click and select "Unhide". Or select "(All)" in the drop-down table of automatic filtering, and then check whether it is all out.

Excel AutoFilter doesn't show you what's going on with the filtered content.

Dear, hello, 1) There are blank rows in the data, resulting in the following blank rows cannot be screened; Workaround: Delete blank lines. 2) Filtering has been added to one or more columns of other columns, resulting in only part of the filtered data being seen when the number and sell columns are re-selected; Workaround:

You can go to the other columns to check whether the filter conditions have been added; If you really can't see it, then cancel the automatic filter, go back and add the automatic filter from the menu. 3) Some rows are manually set to hide, so that this part of the data cannot be seen when selecting filtering; Solution: Select all rows, right-click and select "Unhide". Or select "(All)" in the drop-down table of automatic filtering, and then check whether it is all out.

Wrong. Dear, hello, you have to select all the data areas, and then establish the sieve limb number sock selection, otherwise you can't filter to the data below the blank line or only show the first 1000 different items in the auto-filtered list. More than 1000 pieces of slag will not be displayed, although it is not displayed, but it actually exists, you can find the items that are not displayed through custom filtering.

Method 1: It may be that there are merged cells in **.

After opening the excel file, when we filter you, we will not be able to filter because there are cells that have been merged.

Please click Enter a description.

Please click Enter a description.

Please click Enter a description.

End method 2: Data cannot be filtered when it is protected.

After we open the excel file, select the data, and click [Sort and Filter] is invalid, because **can only be viewed and cannot be operated.

Please click Enter a description.

Then we click on the Review tab, and click on [Revoke Worksheet Protection] under Review.

Please click Enter a description.

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

Please click Enter a description.

Because the data area that needs to be filtered is not selected, there is no response when you click on filter, and the method of filtering data in excel is as follows:

1. Select the data "performance" that needs to be filtered, and the following is an example of screening performance greater than 7000.

2. Click the filter button. Split sails.

3. Click on the lower triangle symbol next to the performance.

4. Select the number filter from the drop-down list.

5. Confirm the filter conditions for hail, select greater than option, enter 7000, and click Confirm.

6. You can screen Bifan to find personnel with more than 7000 performance.

In the daily life of Yunshu, many computer users do not know the problem that excel cannot be filtered, so let's share the solution of ** can not be filtered.

1. First open the excel document and click the [View] option in the menu.

2. Click the [Freeze Window] option in the toolbar.

3. Then in the options that open, cancel the freeze setting.

4. After cancellation, you can re-enter the defeat and elimination screening.

Cancel an existing auto-filter.

Select the entire column of the region where the data is located (for example.

a:e) and then apply the automatic filter.

Dear, hello, I'm glad to answer for you what is the reason why excel can't be filtered A1, the worksheet is protected, if the worksheet is protected and the filtering is restricted, it can't be filtered. 2. Solution: Lift protection:

Click the "Tools" menu, execute the "Protection" command, select "Revoke Workbook Protection" in the menu, enter the password in the pop-up password field, and click OK to revoke the protection. 3. Hidden objects. Tools - Options --- View - Objects - Hides all objects.

If you do the above, you will not be able to filter. 4. Solution: Unhide it, you need to click the right button on the worksheet tab, and then select the unhide option, then a dialog box will pop up, select the worksheet that needs to be unhidden, and then click OK.

If my answer is helpful to you, please give a thumbs up (comment on the stupid corner at the bottom left), look forward to your like, your efforts are very important to me, and your support is also the driving force for my progress. If you feel that my answer is still satisfactory, you can click on my avatar for one-on-one consultation. Finally, I wish you good health and a good mood!

Causes and solutions:

1. There are merged cells. -- Revert the merged cells to normal cells.

2. There is a blank line under the first column. -- Check and remove extra blank lines.

Because there are merged cells, you can't filter them.