分享兴趣,传播快乐,

增长见闻,留下美好!

亲爱的您,这里LearningYard学苑。

今天小编为大家带来的是

《表格的时间排序方法》将为您介绍:

EXCEL对表格内容根据时间进行排序;

腾讯在线表格内容根据时间进行排序;

大约需要您五分钟的时间。

欢迎您的访问。

Share interest, spread happiness,

increase knowledge, and leave beautiful!

Dear , this is LearningYard Academy.

Today,the editor brings you

"The Chronological Method of Tables“ will introduce you to:

EXCEL sorts the table contents according to time;

Sort the contents of Tencent's online form by time;

It will take you about five minutes.

Welcome to visit.




1.EXCEL对表格内容根据时间进行排序

图1

步骤1:打开excel表格,如图1已经在A列中输入了乱序的时间数据,在B列中输入了任务内容。

Step 1: Open the excel sheet, as shown in Figure 1, the out-of-order time data has been entered in column A, and the task content has been entered in column B.


图2

步骤2:鼠标选中A列和B列

Step 2: Select column A and column B with the mouse.


图3

步骤3:点击excel菜单栏上的“数据”选项,找到“排序”并点击进入。

Step 3: Click the "Data" option on the excel menu bar, find "Sort" and click to enter.


图4

步骤4:选择”主要关键字—按照时间排序”、“排序依据—数值”、“次序—升序”,点击确定按钮。

Step 4: Select "Main Keyword - Sort by Time", "Sort By - Value", "Order - Ascending", and click the OK button.


图5

排序结果如图5,已经按照时间顺序排列了。

The sorting results are shown in Figure 5, which have been arranged in chronological order.




2.腾讯在线表格内容根据时间进行排序

图6

步骤1:打开腾讯在线表格,如图6已经在A列中输入了乱序的时间数据,在B列中输入了任务内容。

Step 1: Open the Tencent online form, as shown in Figure 6, the time data has been entered out of order in column A, and the task content has been entered in column B.

图7

步骤2:选中所要排序的单元格,并在菜单栏上“排序”并点击升序。

Step 2: Select the cells to be sorted, and click "Sort" on the menu bar and click Ascending.


图8

排序结果如图8,已经按照时间顺序排列了。

The sorting results are shown in Figure 8, which have been arranged in chronological order.



END



今天的分享就到这里了。

如果您对今天的文章有独特的想法,

欢迎给我们留言,让我们相约明天,

祝您今天过得开心快乐!

That's all for today's sharing. If you have a unique idea for today's article, feel free to leave a message and let's meet tomorrow. I wish you a happy and happy day!


参考资料:百度、谷歌翻译

本文由Learning Yard学苑整理并发出,如有侵权,请联系删除。