How to solve the problem that Excel table documents cannot be filtered by color?

Color filter not working in Excel? Wondering how to fix this issue? Don't worry, PHP editor Banana has prepared a solution for you. Read on below for a step-by-step guide to fixing this issue and letting you easily color-filter your Excel data.

　How to solve the problem that Excel spreadsheet documents cannot be filtered by color?

　1. In the first step, we right-click the table document, then click the "Open with" option in the menu list, and then select the Excel option in the submenu list or pop-up box.

　　2. In the second step, after opening the table document with the Excel program, we click the filter icon on the table document page, and then select "Sort by Color" and a cell you need in the drop-down list color.

　　3. Step 3. After clicking on the cell color, we will see the prompt "To perform this operation, all merged cells must be the same size" in the pop-up box.

　　4. In the fourth step, we close the prompt box and then check whether our data area is correct. If we want to use the filtering function by cell color, we need to set the data area to only data.

5. In the fifth step, we re-select the data and its header row, then click the filter tool to cancel filtering, and click the filter tool again to add a filter icon to the selected area.

The above is the detailed content of How to solve the problem that Excel table documents cannot be filtered by color?. For more information, please follow other related articles on the PHP Chinese website!