Usebenzisa Uhlobo Lwe-Order ku-Excel Spreadsheets

Ukuhlunga kuyindlela yokuhlela izinto ngokulandelana okuthile noma ukuhleleka ngokulandelana kwemithetho ethile.

Kuzinhlelo zesipredishithi ezifana ne-Excel nama-Google Spreadsheet, kunezinombolo eziningi zama-oda wezinhlobo ezihlukene ezitholakalayo kuye ngokuthi uhlobo lwedatha luhlelwa kanjani.

Ukukhuphuka ngokunyuka kwe-Sort Sort Order

Ukuze uthole umbhalo noma izinombolo zezinombolo, izinketho ezimbili zokuhlelwa kwe-oda zikhuphuka futhi zehla .

Kuye ngohlobo lwedatha ebangeni elikhethiwe, le miyalo ehlelekile izohlunga idatha ngezindlela ezilandelayo:

Ngokuba izinhlobo ezikhuphukayo:

• Hlunga u-A ukuya ku-Z - idatha yedatha
• Hlunga amancane kunazo zonke ukuze ukhulu kakhulu - idatha yedatha
• Hlunga endala kunazo zonke kuNewest - kwedatha noma idatha yesikhathi

Ngokuba ukwehla izinhlobo:

• Hlunga u-A ukuya ku-Z - idatha yedatha
• Hlunga kakhulu kunazo zonke ezincane kunazo zonke - ngenombolo yedatha
• Hlunga Kusha Kakhulu Kokudala Kakhulu - kwedatha noma idatha

Imigqa Efihlekile kanye Namakholomu Nokuhlelwa

Imigqa efihliwe namakholomu wedatha awahanjiswa ngesikhathi sokuhlunga, ngakho-ke kudingeka adalulwe ngaphambi kokuba uhlobo lube khona.

Isibonelo, uma irowu 7 lifihlekile, futhi liyingxenye yolwazi oluhlehlisiwe, luzohlala njengolayini 7 kunokuba luhanjiswe endaweni yalo efanele ngenxa yoluhlobo.

Okufanayo kuya kumakholomu wedatha. Ukuhlunga ngemigqa kuhilela ukuvuselela amakholomu wedatha, kodwa uma ikholomu B ifihliwe ngaphambi kohlobo, izohlala njengekholomu B futhi ingabuyiselwanga namanye amakholomu ebangeni elihlelwe.

Ukuhlunga ngombala nohlobo lohlobo

Ngaphezu kokuhlunga ngamagugu, njengombhalo noma izinombolo, i-Excel inezinkambiso zenkambiso ezivumela ukuhlunga ngombala we:

• umbhalo noma umbala wefonti;
• umbala weseli ;
• izimpawu zokufometha okunemibandela .

Njengoba kungekho okwenyukayo noma wehlelwa imibala, umsebenzisi uchaza umbala wokuhlela umbala ebhokisini lebhokisi lezinhlobo .

Hlunga ukuhleleka kwe-oda

Umthombo: Ama- oda wokuhlela okuzenzakalelayo

Izinhlelo eziningi zesipredishithi zisebenzisa ama-oda alungiselelo alandelayo ahlukene ngezinhlobo ezahlukene zedatha.

Amaseli angenalutho : Kokubili kokukhuphuka nokwehla kwama-oda wezinhlobo, amangqamuzana angenalutho ahlale egcinwe ekugcineni.

Izinomboro : Izinombolo ezimbi zibhekwa njengamanani amancane kunazo zonke, ngakho inombolo eningi kunazo zonke ifika kuqala ekulandeni kwenhlobo ekhuphukayo futhi ekugcineni ihlehla, njengokuthi:
Ukunyuka kwe-oda: -3, -2, -1,0,1,2,3
Ukuhlehla kwe-oda: 3,2,1,0, -1, -2, -3

Izinsuku : Usuku oludala kunqatshelwe ukuthi lunenani eliphansi noma elincane kunezinsuku eziningi zakamuva noma ezintsha.
Ukunyuka kwe-oda (endala kunazo zonke zakamuva): 1/5/2000, 2/5/2000, 1/5/2010, 1/5/2012
Yehla i-oda (yakamuva kakhulu kuya endala): 1/5/2012, 1/5/2010, 2/5/2000, 1/5/2000

Idatha ye-Alphanumeric : Inhlanganisela yamagama nezinombolo, idatha ye-alphanumeric ithathwa njengedatha yombhalo futhi uhlamvu ngalunye luhlungwa kusuka kwesobunxele kuya kwesokudla kumlingisi ngesisekelo sobunjwa.

Ngedatha ye-alphanumeric, izinombolo zibhekwa njengezinenani eliphansi kunezinhlamvu zamagama.

Ukuze uthole idatha elandelayo, i-123A, A12, 12AW, ne-AW12 ukuhleleka kwenqubo ephakanyisiwe yi:

123A 12AW A12 AW12

Ukuhlehlisa ukuhleleka kwenhlobo ku:

I-AW12 A12 12AW 123A

Kulesi sihloko Indlela yokulungisa kahle idatha ye-alphanumeric ku-Excel , etholakala kwiwebhusayithi ye-Microsoft.com, i-oda elilandelayo lunikezelwa izinhlamvu ezitholakala ku-data alphanumeric:

0 1 2 3 4 5 6 7 8 9 (isikhala)! "# $% & () *,. /:;? @ @ [\] ^ _` {|} ~ + <=> ABCDEFGHIJKLMNOPQRSTU VWXYZ

Idatha eqondayo noma ye-Boolean : TRUE noma ama-FALSE amanani kuphela, futhi i-FALSE ibhekwa njengenani elincane kune-TRUE.

Ukuze uthole idatha elandelayo, TRUE, FALSE, TRUE, futhi FALSE ukuhleleka kwenhlobo ekhuphukayo:

I-FALSE IFALSE TRUE TRUE

Ukuhlehlisa ukuhleleka kwenhlobo ku:

Iqiniso

IQINISO LOKUQALA LOKUQALA