excel筛选和排序哪个部分最好(学习笔记(十四)|Excel排序与筛选)

首页常识更新时间:2023-01-20 16:15:29

分享兴趣,传播快乐,增长见闻,留下美好!

亲爱的您,这里是LearningYard学苑。

今天小编为大家带来“学习笔记(十四)|Excel排序与筛选”,欢迎您的访问。

Share your interests, spread your joy, grow your insights, and leave your beauty behind!

Dear you, this is LearningYard Academy.

Today I bring you "Learning Notes (XIII) | Excel Sorting and Filtering", welcome to visit.

排序

数据—排序

开始—排序和筛选—自定义排序

分别按照字段,依据(数值,单元格样式等),次序(升序,降序还是自定义排序(回车进行排序))进行排序。选项中可以按照笔画进行排序。

字段的选择,可以有多个,按要求进行上移下移,确定主次顺序。

Data-Sorting

Start - Sorting and Filtering - Custom Sorting

Sort by field, by basis (value, cell style, etc.), by order (ascending, descending or custom sort (enter to sort)). Options can be sorted by strokes.

The selection of fields, which can have more than one, is moved up and down as required to determine the primary and secondary order.

筛选

把符合条件的数据显示出来,不符合条件的数据隐藏起来。

高级筛选:分为列表区域,条件区域,结果所在区域三个部分。

在结果区域输入条件,选择高级筛选,在列表区域选择原始数据,在条件区域选择刚刚输入的条件,在结果区域按照题目要求进行选择。

注:在结果选项表中进行高级筛选。

Show the data that meet the conditions and hide the data that do not meet the conditions.

Advanced filtering: divided into three parts: list area, condition area, and result area.

Enter the conditions in the result area, select advanced filtering, select the original data in the list area, select the conditions just entered in the condition area, and select in the result area according to the requirements of the topic.

Note: Advanced filtering in the result option table.

今天的分享就到这里,如果您对今天的文章有独到的见解,欢迎给我们留言,让我们相约明天,祝您今天过得开心快乐!

Today's share is over here, if you have unique views on today's article, welcome to leave a message for us, let us meet tomorrow, I wish you a happy and happy today!‍

参考资料:文字:百度;图片:微博;翻译:百度翻译

本文由LearningYard新学苑原创,部分图片文字来自网络,如有侵权请联系。

,
展开阅读全文
推荐内容
热门内容
热门文章

© 2007-2022 http://www.anhuiqq.cn,All Rights Reserved.