表格中按周排班(八悦分享一)
表格中按周排班(八悦分享一)欢迎您的访问。大约需要您五分钟的时间。《表格的时间排序方法》将为您介绍: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.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学苑整理并发出,如有侵权,请联系删除。