1.排序:简单排序、多条件排序、按颜色排序、自定义排序、利用排序插入行
2.筛选:简单筛选、 在筛选中使用多个条件、高级筛选
1.排序
1.1 简单排序
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200402200623666-523476504.png)
1.2 多条件排序
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200402201021694-571776286.png)
1.3 按颜色排序
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200402201912496-200975358.png)
1.4 自定义排序
原有排序有些时候不尽人意
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200402202650841-528924564.png)
选择自定义排序序列
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200402202954735-1578172392.png)
编辑并应用自定义序列
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200402203152669-22563912.png)
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200402203304309-406908926.png)
成果
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200402203321965-1532640278.png)
1.5 利用排序插入行:添加辅助列排序
如下图的工资条表,打印时要求每个人的工资条都有表头,即表头-汪梅工资-表头-郭磊工资
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200403135307824-214582129.png)
做法
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200403140046461-781334687.png)
成果
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200403140135386-1853621873.png)
2. 筛选
2.1 简单筛选
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200403144343719-1464730248.png)
直接选择筛选,然后复制筛选后的内容到新的工作表就行了
2.2 在筛选中使用多个条件
先筛选一列,接着筛选另一列。
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200403145527260-1938958951.png)
文本筛选![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200403145904484-1459144361.png)
2.3 高级筛选
筛选不重复值
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200403150939215-108522664.png)
多个或条件筛选
![](https://img2020.cnblogs.com/blog/1592754/202004/1592754-20200403153211546-408049969.png)