Detailed method to set sorting by color in excel2013

php editor Xigua shared the detailed method of setting sorting by color in excel2013. This function can quickly filter and organize data tables. First, find the "Sort & Filter" button in the "Data" tab, and then select "By Color" to sort. Then select the custom sorting rule to sort the data according to the cell background color and process the data conveniently and quickly.

1. Open the excel2013 worksheet.

2. Click the top data label.

3. Select the data cells to be rearranged, and then click the [Sort] button.

4. Select the cell color in sequence.

5. Choose the ones you think are important in order, such as red.

6. After clicking [OK], you can see that the red color is at the top.

The above is the detailed content of Detailed method to set sorting by color in excel2013. For more information, please follow other related articles on the PHP Chinese website!