excel取消按颜色排序_在Excel中按颜色排序

最新推荐文章于 2021-11-19 17:26:53 发布

culiao2169

最新推荐文章于 2021-11-19 17:26:53 发布

阅读量2.1k

点赞数

文章标签：列表 excel java python poi

原文链接：https://contexturesblog.com/archives/2010/02/24/sort-by-colour-in-excel/

版权

excel取消按颜色排序

In the old days, the Sort dialog box in Excel only had 3 levels. However, with a bit of planning, you could sort Excel data by 4 columns or more, and once you learned that trick, life was good. Or at least it was sort of good. 😉

过去，Excel中的“排序”对话框只有3个级别。但是，通过一些计划，您可以按4列或更多列对Excel数据进行排序，一旦学会了这种技巧，生活就变得很美好。或者至少这是一件好事。 😉

In Excel 2007, the Sort dialog box is much fancier, and you can include up to 64 sorting levels.

在Excel 2007中，“排序”对话框更加新颖，您最多可以包括64个排序级别。

I've never needed anywhere near that many – 5 or 6 fields is plenty for most tables that I've had to sort.

我从来不需要这么多的地方– 5到6个字段对于我不得不排序的大多数表来说已经足够了。

按颜色排序 (Sort By Colour)

Another new feature in Excel 2007 is the ability to sort by cell or font colour, or by cell icon.

Excel 2007中的另一个新功能是可以按单元格或字体颜色或按单元格图标排序的功能。

If you have different colours in a column, you can choose one to show up at the top or bottom of a sorted list.

如果一列中有不同的颜色，则可以选择一种颜色显示在排序列表的顶部或底部。

If you used conditional formatting to add cell icons, such as traffic lights, you can sort by those icons.

如果您使用条件格式添加了单元格图标(例如交通信号灯)，则可以按这些图标进行排序。

To put the colours or cell icons in a specific order, you can add the same field multiple times in the Sort dialog box, and choose a different colour or cell icon for each sorting level.

要将颜色或单元格图标按特定顺序放置，可以在“排序”对话框中多次添加相同的字段，并为每个排序级别选择不同的颜色或单元格图标。

This won't be too difficult if you have only a few colours in the list, but will be more challenging if you have lots of colours.

如果列表中只有几种颜色，这不会太困难，但是如果您有很多颜色，这将更具挑战性。

The list on my worksheet, that was previously sorted by date, is now sorted by the colours, in the order that I selected above. Yellow isn't in the Sort level specifications, so it appears at the bottom of the list.

我的工作表上的列表以前按日期排序，现在按颜色在上面选择的顺序排序。黄色不在“排序级别”规范中，因此它显示在列表的底部。

按颜色排序，风险自负 (Sort By Colour At Your Own Risk)

Even though you can sort by colour now, I wouldn't recommend it. I've seen too many rainbow coloured Excel worksheets, where nobody can remember what the colours mean. Is yellow good? Is blue bad? Is there a colour code somewhere?

即使您现在可以按颜色排序，我也不推荐。我看过太多彩虹色的Excel工作表，没人能记住颜色的含义。黄色好吗？蓝色不好吗？某处有颜色代码吗？

I'd rather add another column in the worksheet, and put a number code or text comment there. So, instead of marking the overdue accounts with a red fill colour, type "Overdue" in another column, or use a formula to calculate which accounts are overdue.

我宁愿在工作表中添加另一列，并在其中添加数字代码或文本注释。因此，不要用红色填充颜色标记过期的帐户，而是在另一列中键入“过期”，或使用公式计算过期的帐户。

Or, instead of highlighting the customer names that you want to send an email to, type an X in an Email column.

或者，不要突出显示要向其发送电子邮件的客户名称，而是在“电子邮件”列中键入X。

Then, you can sort or filter the Overdue accounts or the Email column, to focus on the rows of interest.

然后，您可以对逾期帐户或“电子邮件”列进行排序或过滤，以关注感兴趣的行。