Mukugwiritsa Ntchito Order mu Excel Spreadsheets

Kusankha ndi ndondomeko yokonzekera zinthu mwa dongosolo linalake kapena mtundu wina malinga ndi malamulo ena.

Mu mapulogalamu a spreadsheet monga Excel ndi Google Spreadsheets, pali malamulo angapo a mitundu yosiyanasiyana omwe amapezeka malinga ndi mtundu wa deta omwe amasankhidwa.

Akukwera vs Vuto Lotsalira

Kwa malemba kapena mawerengedwe, njira ziwiri zomwe mungasankhire zimakwera ndikutsika .

Malinga ndi mtundu wa deta mumasankhidwe, maulamulidwe awa adzasankha deta njira zotsatirazi:

Kwa kukwera mitundu:

• Sankhani A mpaka Z - chifukwa cha malemba
• Sungani Pang'ono Kwambiri Kuposa - kwa data ya chiwerengero
• Sankhani Zakale Kwambiri Kufikirapo - chifukwa cha deta kapena nthawi

Kutsika mitundu:

• Sankhani A mpaka Z - chifukwa cha malemba
• Sungani Kwambiri Kwakukulu Kwambiri - kwa Deta Deta
• Sakani Watsopano Kwambiri Kukalamba - chifukwa cha deta kapena nthawi

Mizere Yobisika ndi Ma Coloni ndi Kukonza

Mizere yosabisa ndi ndondomeko ya deta sizisuntheka panthawi yosankha, kotero zimayenera kusokonezedwa musanakhale mtunduwo.

Mwachitsanzo, ngati mzere 7 uli wobisika, ndipo ndi mbali ya deta yochuluka yomwe yasankhidwa, idzakhalabe mzere 7 osati kusunthira ku malo ake olondola chifukwa cha mtunduwo.

Zomwezo zimapita pazithunzi za deta. Kusankha ndi mizere kumaphatikizapo kukonzanso ndondomeko ya deta, koma ngati Pambuyo B imabisika musanakhale mtunduwo, idzakhalabe ngati Phula B ndipo sichidzasinthidwa ndizitsulo zina muzinthu zosiyana.

Kusankhidwa ndi Mtundu ndi Machitidwe a Mtundu

Kuphatikiza pa kusankha ndi mfundo, monga malemba kapena manambala, Excel ili ndi mwambo wotsatsa zomwe zimaloleza mtundu ndi:

• malemba kapena mtundu wa fosholo;
• mtundu wa selo ;
• zizindikiro zosinthika .

Popeza palibe kukwera kapena kutsika kwa mitundu, womasulira amatsatsa mtundu wa mtundu mu mtundu wa dialog box .

Sakani Chidwi chosasintha

Chitsime: Chosankha kupanga mitundu

Mapulogalamu ambiri a spreadsheet amagwiritsa ntchito maulamuliro a mtundu wosasinthika otsatirawa ndi mitundu yosiyanasiyana ya deta.

Maselo Osalongosoka : Pakati pa onse akukwera ndi kutsika machitidwe amtundu, maselo osawerengeka amakhala otsiriza nthawi zonse.

Nambala : Manambala osayenerera amaonedwa kuti ndi amtengo wapatali kwambiri, choncho nambala yaikulu yoipa nthawi zonse imayamba yoyamba ndikukwera pansi, monga:
Kukwezera Dongosolo: -3, -2, -1,0,1,2,3
Kusintha Lamulo: 3,2,1,0, -1, -2, -3

Madeti : Tsiku lakale kwambiri limaonedwa kuti ndi lochepa kapena laling'ono kuposa tsiku laposachedwa kapena latsopano.
Kukwezera Dongosolo (chakale kwambiri mpaka posachedwapa): 1/5/2000, 2/5/2000, 1/5/2010, 1/5/2012
Kusintha Lamulo (posachedwa kwambiri mpaka lakalekale): 1/5/2012, 1/5/2010, 2/5/2000, 1/5/2000

Dongosolo la Alphanumeric : Kuphatikizidwa kwa makalata ndi manambala, deta ya alphanumeric imatengedwa ngati deta ya data ndipo khalidwe lirilonse limasankhidwa kuchokera kumanzere kupita kumanja pa chikhalidwe ndi khalidwe.

Kwa chiwerengero cha alphanumeric, manambala amawerengedwa kuti ndi ofunika kwambiri kuposa malemba a kalata.

Zotsatira zotsatirazi, 123A, A12, 12AW, ndi AW12 ndondomeko yowonjezera ili:

123A 12AW A12 AW12

Kusintha mtundu wamtundu ndi:

AW12 A12 12AW 123A

M'nkhaniyi Mmene mungasamalire deta yamtundu wa Excel , yomwe ili pa webusaiti ya Microsoft.com, ndondomeko yotsatirayi imaperekedwa kwa olemba omwe ali mu data alphanumeric:

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

Dongosolo la Logical kapena Boolean : TRUE kapena FALSE miyeso yokha, ndipo FALSE imawoneka kuti ndi yochepa kwambiri kuposa CHOONA.

Zotsatira izi, ZOKHUDZA, ZOLEMBEDWA, ZOCHOKERA, NDIPONSO ZOKHUDZANA ndi dongosolo lokwezeka ndi:

ZINTHU ZOFUNIKA ZOONADI

Kusintha mtundu wamtundu ndi:

Zoona

ZINTHU ZOONA ZONSE