Haddii aad hore u haysatid xaashida faafinta oo aad u baahan tahay inaad xogta ku kala soocdo taariikhda ku jirta Microsoft Excel ama Excel Online , waxaad raaci kartaa tillaabadan hage tallaabo ah. Uma baahnid inaad isticmaasho wax shaqo ah ama qaacido^{(use any function or formula)} si aad u kala saarto xogta sida shuruudahaaga.

Sida Taariikhda loogu kala saaro Excel

Si aad u kala soocdo xogta taariikhaha Microsoft Excel , raac talaabooyinkan-

1. Ku fur xaashida xaashida Excel.
2. Dooro tiirka taariikhda jiirkaaga.
3. Guji badhanka Kala soocida & Shaandhaynta^{(Sort & Filter)}
4. Dooro Kala soocida ugu da'da weyn ilaa^{(Sort Oldest to Newest)} kan ugu cusub ama kan ugu cusub^{(Newest to Oldest)} .
5. Dooro balaadhi doorashada^{(Expand the selection)} .
6. Guji badhanka kala soocida^(Sort)

Aynu si faahfaahsan u eegno tillaabooyinkan.

Ku fur xaashida faafinta ee Microsoft Excel kombayutarkaaga^{(Microsoft Excel)} . Intaa ka dib, waa in aad aragto tiir ka kooban taariikhaha oo dhan. Waxaad u baahan tahay inaad doorato dhammaan unugyada taariikhda leh. Si kale haddii loo dhigo, waa inaadan dooran safka madaxa.

Kadib, iska hubi inaad ku jirto tabka Guriga . ^(Home)Haddii ay sidaas tahay, waxaad arki kartaa badhanka la yiraahdo Kala soocida & Shaandhaynta^{(Sort & Filter)} . Ka dib markaad gujiso badhankan, waa inaad gujisaa Kala soocida ugu da'da wayn ilaa^{(Sort Oldest to Newest )} kan ugu cusub ama kala sooci kan ugu da'da wayn^{(Sort Newest to Oldest)} doorashada.

Sida xogta kale ee xaashida ay tahay in la beddelo si waafaqsan tiirka taariikhda, Microsoft Excel waa in ay ku tusto digniin markan. Waxaad u baahan tahay inaad hubiso in balaadhi doorashada^{(Expand the selection )} xulashada la doortay. Hadday haa tahay, waxaad riixi kartaa badhanka kala soocida^{(Sort )} .

Hadda, taariikhdaada waa in lagu habeeyaa taariikh.

Sida loo habeeyo xogta taariikhda gudaha Excel Online

Si aad u kala soocdo xogta taariikhda gudaha Excel Online , raac talaabooyinkan-

1. Ku fur xaashida faafinta ee Excel Online.
2. Riix Ctrl+ A si aad u doorato xaashida faafinta oo dhan.
3. Guji badhanka Kala soocida & Shaandhaynta^{(Sort & Filter)} ee tabka Guriga .^(Home)
4. Dooro ikhtiyaarka kala soocida Custom .^{(Custom Sort)}
5. Sax ku samee xogtaydu waxay leedahay^{(My data has headers)} sanduuqa madaxa.
6. Dooro tiirka taariikhda, Qiimaha Unugyada^{(Cell Values)} , oo kala saar kor^{(Sort Ascending)} u kaca ama kala soocida^{(Sort Descending)} .
7. Guji badhanka OK

Akhri si aad wax badan uga ogaato talaabooyinkan.

Marka hore, ku fur xaashida xisaabaadka ee Excel Online oo dooro xaashida oo dhan. Haddii aadan aqoon habka, waxaad raaci kartaa talooyinka iyo tabaha Microsoft Excel^{(Microsoft Excel tips and tricks)} si aad u ogaato.

Hadda, iska hubi inaad ku jirto tabka Guriga . ^{(Home )}Halkan waxaad ka heli kartaa ikhtiyaarka la yiraahdo Kala soocida & Shaandhaynta^{(Sort & Filter)} . Kadib markaad gujiso badhankan, waxaad u baahan tahay inaad dooratid ikhtiyaarka kala soocida Custom .^{(Custom Sort )}

Taas ka dib, ka dooro tiirarka taariikhda liiska sadarrada^{(Column )} , ka dooro Qiimaha Unugyada^{(Cell Values)} Liiska Kala-soocida^{(Sort On )} , oo ka dooro Kala^{(Sort Ascending )} -soocida Kor u kaca ama Kala-soocida Soodejinta^{(Sort Descending)} liiska dalabka^(Order) . Ugu dambeyntii, dhagsii badhanka OK .

Xogtaada waa in lagu xaliyaa taariikhda.

Waa intaas! Rajo in ay ku caawin

How to Sort by Date in Excel

If yoυ already have a spreadsheet and yoυ need to sort data by date in Microsoft Excel or Excel Online, you can follow this step by step guide. You do not have to use any function or formula to sort data as per your requirements.

How to Sort by Date in Excel

To sort data by dates in Microsoft Excel, follow these steps-

1. Open the spreadsheet with Excel.
2. Select the date column with your mouse.
3. Click the Sort & Filter button.
4. Select Sort Oldest to Newest or Newest to Oldest.
5. Select Expand the selection.
6. Click the Sort button.

Let’s check out these steps in detail.

Open the spreadsheet with Microsoft Excel on your computer. After that, you should see a column containing all the dates. You need to select all the cells that have a date. In other words, you should not choose the header row.

Then, make sure that you are in the Home tab. If so, you can see a button called Sort & Filter. After clicking this button, you should click the Sort Oldest to Newest or Sort Newest to Oldest option.

As the other data of the spreadsheet must be changed according to the date column, Microsoft Excel should show you a warning at this point. You need to ensure that the Expand the selection option is selected. If yes, you can click the Sort button.

Now, your date should be sorted by date.

How to sort data by date in Excel Online

To sort data by date in Excel Online, follow these steps-

1. Open spreadsheet with Excel Online.
2. Press Ctrl+ A to select the whole spreadsheet.
3. Click the Sort & Filter button in the Home tab.
4. Select the Custom Sort option.
5. Make a tick in the My data has headers box.
6. Select the date column, Cell Values, and Sort Ascending or Sort Descending.
7. Click the OK button.

Read on to know more about these steps.

At first, open the spreadsheet with Excel Online and select the whole sheet. In case you do not know the process, you can follow our Microsoft Excel tips and tricks guide to know.

Now, make sure that you are in the Home tab. Here you can find an option called Sort & Filter. After clicking this button, you need to select the Custom Sort option.

After that, choose the date column from the Column list, select Cell Values from Sort On list, and choose Sort Ascending or Sort Descending from the Order list. At last, click the OK button.

Your data should be sorted by date.

That’s all! Hope it helps.

Related posts

• Sida loo muujiyo Taariikhda iyo Waqtiga Hadda ee Excel iyo Google Sheets

• Sida loo beddelo Serial Number taariikhda Excel

• Sida Taariikh ahaan loogu kala saaro Excel

• Si degdeg ah ugu dar taariikhda iyo wakhtiga Stamps xaashida shaqada ee Excel

• Sida loo isticmaalo Percentile.Exc function gudaha Excel

• Sida loo beddelo midabka warqadda shaqada ee Excel

• Sida loogu daro Koodhka Dalka ama Goobta Liiska Lambarka Taleefanka ee Excel

• Sida loo bilaabo Word, Excel, PowerPoint, Outlook in Mode Safe

• Sida loo tiriyo qiyamka nuqul ka mid ah tiirka Excel

• Sida loo midoobo oo loo kala saaro unugyada Excel

• Sida loo isticmaalo DCOUNT iyo DCOUNTA Function gudaha Excel

• Sida loo beddelo qaabka faylka caadiga ah ee lagu kaydiyo Word, Excel, PowerPoint

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo isticmaalo Find and FindB functional in Excel

• Sida loo isticmaalo Muddada Dhaqaale Function gudaha Excel

• Sida loo geliyo shaxda firfircoon ee xaashida Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo isticmaalo shaqada HLOOKUP ee Microsoft Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows