我想個Excel既排列方式係：出生日期。我指係：for example: 1/12/1999 先 2/12/1999後。
How can I do it?
Sorry for my Chinese, I am not too good at that~
About Microsoft Excel
2009-01-24 8:18 am
回答 (3)
2009-01-24 9:42 am
The steps are :-
1. Type all the Dates on the same column of an Excel spreadsheet
2. Highlight all the Dates
3. Select "Data" --> "Sort"
4. The Dates have been arranged in order!
1. Type all the Dates on the same column of an Excel spreadsheet
2. Highlight all the Dates
3. Select "Data" --> "Sort"
4. The Dates have been arranged in order!
2009-01-24 8:41 am
你要指定欄位為日期格式，EXCEL可以依日期排序。
2009-01-24 8:35 am
首先--你打1/12/1999
後--有個深色的框框住(1/12/1999)
後--旁邊有個白色十宇
後--變成另一個十字(黑色)
後--一直往下拉
完成
1/12/1999
2/12/1999
3/12/1999
...............
後--有個深色的框框住(1/12/1999)
後--旁邊有個白色十宇
後--變成另一個十字(黑色)
後--一直往下拉
完成
1/12/1999
2/12/1999
3/12/1999
...............
收錄日期: 2021-04-19 17:32:48
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20090124000051KK00033