Support

How to Filter a Worksheet Table by Color in Spreadsheets 2013

In Kingsoft Spreadsheets (9.1.0.4480, 9.1.0.4490), if you have applied different colors to the data or different cell colors, you can filter the data by these colors.

Using AutoFilter to filter data is a quick and easy way to find and work with a subset of data in a range of cells or table. Once you have filtered data in a range of cells or table, you can either reapply a filter to get more accurate data, or clear a filter to redisplay all of the data.

Filter by cell color, font color

Follow these steps to filter data by cell color / font color.

Step 1 Open a worksheet with Spreadsheets 2013.

Step 2 Select the range of cells you want to filter.

Step 3 Go to Home or Data tab, click on Autofilter.

Step 4 Click on the drop-down arrow in each cell of the first line in the selected range. In the autofilter option dialog, click on Filter by Color.

filter data by color

You can either filter the data by cell color or font color, in case you have formatted the cells by both cell color and font color.

Click one color from the above font color and cell color list. For example, select the font color of Red. You will see the data is filtered like below:

filter data by color

Remove Color Filter

If you want to remove the color filter you have applied to the worksheet data, follow these steps to clear the filter from the worksheet.

Step 1 Click on the autofilter icon in the column header.

Step 2 In the autofilter option dialog, click on Clear.

remove filter data by color

The filter is removed. If you want to reaply the filter, please go to Home or Data tab, click on AutoFilter option and choose Reapply from the drop-down list.

See the above steps in the following video: