快捷搜索:  汽车  科技

表格中按周排班(八悦分享一)

表格中按周排班(八悦分享一)欢迎您的访问。大约需要您五分钟的时间。《表格的时间排序方法》将为您介绍:EXCEL对表格内容根据时间进行排序;腾讯在线表格内容根据时间进行排序;

分享兴趣,传播快乐

增长见闻,留下美好!

亲爱的您,这里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)

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

表格中按周排班(八悦分享一)(2)

图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.

表格中按周排班(八悦分享一)(3)

图2

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

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

表格中按周排班(八悦分享一)(4)

图3

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

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

表格中按周排班(八悦分享一)(5)

图4

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

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

表格中按周排班(八悦分享一)(6)

图5

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

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

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

表格中按周排班(八悦分享一)(7)

图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.

表格中按周排班(八悦分享一)(8)

图7

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

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

表格中按周排班(八悦分享一)(9)

图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学苑整理并发出,如有侵权,请联系删除。

猜您喜欢: