Tsi nyob rau hauv Excel. Ua hauj lwm nyob rau hauv Excel. Excel piv txwv

Microsoft Excel software yog indispensable mus ua hauj lwm nrog cov zauv thiab cov ntxhuav. Nws tso cai rau koj mus tau yooj yim ua txoj suav, kos duab thiab cov kab kos. Ua hauj lwm nrog cov ntxhuav uas muaj ib daim ntawv teev saib, Microsoft Excel tso cai rau koj mus xaiv tus yam qhov tseem ceeb thiab txheeb kab. Cov ntaub ntawv yuav tsum txheeb nyob rau hauv ascending los yog nqis kev txiav txim raws li qhov tseem ceeb uas yog nyob rau hauv lub hlwb. Cov tib manipulation yuav ua tau nrog cov ntawv nyeem cov ntaub ntawv uas, nws yuav tsum tau nyob yog nyob rau hauv alphabetical thiaj los nyob rau hauv rov qab alphabetical. Tsi nyob rau hauv Excel yog yuav tsum tau los xyuas kom meej tias cov lus qhia yog muaj rau xaav thiab yooj yim rau kev nyeem ntawv.

Tsim koj tus kheej tsi thiaj

Tej zaum tej lub sijhawm tshwm sim thaum uas koj yuav tau tsi cov ntaub ntawv nyob rau hauv qhov kev txiav txim uas yog txawv los ntawm uas twb muaj lawm sawv daws yuav. Nyob rau hauv cov ntaub ntawv no, koj muaj peev xwm tsim koj tus kheej kev txiav txim, uas yog yuav tsum tau rau ntxiv ua hauj lwm.

Yuav kom tsim ib tug kev cai kev txiav txim, koj yuav tsum mus rau lub tab "cuab yeej" thiab mam li xaiv "Options." Muaj ib tug zaub mov ntawm "bar", qhov twg rau sab laug sab ntawm lub qhov rais nyob uas twb muaj lawm npe siv rau sorting. "Tshiab daim ntawv teev", xaiv cov kev xaiv los tsim koj tus kheej kev txiav txim. Tag nrho cov "Sau cov khoom" tseem ceeb tsim nyog thiab tsis yuav tsum tau teev nyob rau hauv lub teb.

Tswv yim tseem ceeb yog sib cais siv lub "Sau" qhov tseem ceeb. Yuav kom nkag mus rau tag nrho cov ntaub ntawv uas koj xav tau nyob rau hauv qhov kev txiav txim, raws li uas yav tom ntej yuav tsum txheeb daim ntawv teev. Thaum tag nrho cov qhov tseem ceeb yog teem, nias lub khawm "Ntxiv". Import ib daim ntawv uas yog twb ntaus rau lub desktop, koj yuav tsum tau siv qhov kev xaiv "Ntshuam ib daim ntawv teev cov hlwb," hais tias tej yam cell chaw nyob. Tab sis nws yuav ua tau tsuas yog thaum uas twb muaj lawm daim ntawv teev muaj cov khoom nyob rau hauv qhov kev txiav txim, uas yog yuav tsum tau rau ntxiv sorting qhov tseem ceeb. Thaum kawg koj yuav tsum nias rau ntawm "Ntshuam."

Tam sim no nws yog ib qho yooj yim mus npaj ntaub ntawv, mus ua hauj lwm nyob rau hauv Excel yog xis. Ua li no, mus rau lub "Cov ntaub ntawv" ntawv qhia zaub mov thiab ces xaiv lub tab "Sorting". Nyob rau hauv lub "Tsi yog ..." yuav tsum tau teem ib qho tsis, thiab nias cov coj khawm. Nyob rau qhov kev tshuaj ntsuam zoo nkaus li lub qhov rais "Tsi Options", qhov uas koj qhia kom meej rau tsi kev txiav txim ntawm cov ntaub ntawv.

Tom qab ntawd koj yuav tsum tau xaiv rau koj tus kheej tsi kev txiav txim thiab paub meej tias koj xaiv los ntawm nias OK.

Nyob rau hauv thiaj li yuav txheeb nyob rau hauv Excel tau nqa tawm, koj yuav tsum mus rau qhov chaw lub cursor nyob rau hauv ib tug ntawm tes, thiab nias rau ntawm cov nyees khawm coj mus rau cov tsi nyob rau hauv ascending los yog nqis kev txiav txim. Lawv muaj nyob rau ntawm lub toolbar.

Tsi yog lub npe thiab cov nyiaj hli

Feem ntau ntawm cov qhauj muaj yog ib tug teeb meem no thaum koj yuav tau tsi cov ntaub ntawv raws li lub xeem neeg ua hauj lwm. Qhov no yog yooj yim nyob rau hauv cov ntaub ntawv hais txog ib tug kev ua hauj lwm, yuav tsum nyob rau hauv tib txoj kab.

Rau clarity, cov ntaub ntawv yog txheeb tsis tau tsuas yog los ntawm lub npe, tab sis, nyob rau tus nqi ntawm cov nyiaj hli. Nyob rau hauv cov ntaub ntawv no, muaj ib co tsi nyees khawm yuav tsis ua li cas. Yog hais tias koj xav tau no tsi ntawm cov ntaub ntawv, Excel muab cov nram qab no tso zis:

• Koj yuav tsum mus qhib qhov hais kom ua "Cov ntaub ntawv" thiab ces "Sorting".
• Nyob rau hauv lub qhib qhov rais "Ntau qhov" koj yuav tsum xaiv "Tsi yog ..." thiab qhia kom meej ib tug kiag. Ces koj yuav tsum tsiv mus nyob rau pointer mus rau lub kev kawm txoj hauj lwm: ascending los yog nqis kev txiav txim.

Rau qhov thib ob teb no yog nqa tawm analogously rau sorting. Qhov kev pab cuam yuav txheeb cov npe ntawm tsuas yog cov neeg ua hauj lwm uas muaj rau tib cov nyiaj hli.

Yog hais tias cov ntaub ntawv yog heev loj, koj muaj peev xwm tsim koj tus kheej npe rau miv koj cov ntaub ntawv. Qhov no yuav pab tsis txhob kom raug thaum ua hauj lwm nrog rau cov khoom, dhau li nws yuav yooj yim rau ko.

tsi alphabetically

Yuav kom xaiv tau cov cov ntaub ntawv nyob rau hauv alphabetical kev txiav txim, koj yuav tsum mus rau lub "Cov ntaub ntawv" ntawv qhia zaub mov. Pre-yuav tsum tau xaiv cov kem uas tus muaj nuj nqi yog yuav tsum tau ua ntawv thov. Cov ntaub ntawv yuav tsum txheeb los ntawm nias lub icon "A mus txog Z", los yog vice versa. Tom qab hais tias, lub screen qhia ib lub qhov rais uas muaj cov nqe lus nug: "Kuv puas yuav tsum nthuav lub ntau yam ntawm cov ntaub ntawv yeej?" Nws yog tsim nyog los txais thiab nias "Txuag". Tag nrho cov ntaub ntawv tsis poob nws cov ntsiab lus, thiab tus so ntawm cov ntaub ntawv txhua sib haum mus rau cov kev hloov.

Tsi nyob rau hauv Excel yuav ua tau nyob rau hauv lwm txoj kev. Xaiv ib tug ntawm tes, koj yuav tsum nias rau ntawm lub icon. Tab sis nyob rau hauv cov ntaub ntawv no rau lo lus nug ntawm lub expansion ntawm lub ntau yam tsis tshwm sim, nws expands txiav.

Multi-theem sorting

Thaum ua hauj lwm nrog cov ntaub ntawv, thiab tej zaum yuav ib tug multi-level sorting nyob rau hauv Excel. Yuav kom siv tau qhov no feature, koj yuav tau xaiv ib tug ntawm tes nyob rau hauv daim ntawv teev thiab nias rau ntawm qhov kev xaiv "Tsi" nyob rau hauv nws. Ib theem muaj yuav, thiab nws tseem tau los xaiv lub, xws li los ntawm hnub. Ua li no, nias qhov "Ntxiv txheej". Rau qhov yooj yim ntawm kev ua tau ua nyob rau hauv ntau ntau ntawm daim ntawv teev txheeb los ntawm lub ntsiab lus.

Yog hais tias tsim nyog, ntau ntau tus tsiv los yog down, uas hloov lawv tseem ceeb. Ua li no, xaiv lub tiaj thiab nias rau ntawm lub xub icon. Tsis tas li ntawd, ntau yooj yim theej los yog deleted.

Qauv nyob rau hauv Microsoft Excel

Qauv nyob rau hauv Excel yog kab zauv uas pib nrog "sib npaug" kos npe rau, muaj li ntawm hais txog zauv tseem ceeb, cell chaw nyob, npe los yog lub zog. Tag nrho cov ntawm lawv yog kev cob cog rua rau tej yam tshwm sim ntawm xam hauj lwm: multiplication, division, kev rho tawm, los yog exponentiation.

Lag luam nyob rau hauv cov mis muab faib raws li tseem ceeb:

• Cov kev qhia nyob rau hauv pab pawg thiab exponentiation.
• Cov kev faib thiab npaug.
• Rho thiab ntxiv.

Lub cell qhia tsuas yog tus ntawd, tab sis cov mis mos nws tus kheej yog nyob rau hauv cov mis bar. Yog hais tias koj hloov lub kawg yog hloov tau.

Yuav ua li cas yuav ua rau ib tug kev hloov nyob rau hauv cov mis?

Yog hais tias muaj yog ib tug yuav tsum tau hloov cov mis, koj yuav tsum nias nyob rau hauv cov mis bar los yog nias lub khawm F2. Tom qab tag nrho cov kev kho me ntsis tsim nyog mus nias «Sau» los yog cov tswv yim icon nyob rau hauv kab. Cov kev hloov tseem yuav tsum muaj ntaub ntawv ncaj qha nyob rau hauv lub cell. Yuav kom qhov no kawg, lub xaiv cheeb tsam yuav tsum nias ob zaug.

Cell ua tim khawv thiab lub zog ntawm cov qauv

Tej hau kev kawm mus Excel, nyob rau cov qauv, koj yuav pom kev mus. Siv mus pub rau siv cov ntaub ntawv nyob rau hauv lub neeg pab leg ntaubntawv hais tias yog nyob rau hauv txawv qhov chaw ntawm daim ntawv. Tau siv cell ua tim khawv, nyob rau hauv lwm yam workbooks los yog daim ntaub ntawv.

Tom qab nkag mus rau lub cell nws mis yuav pab tau los yog tau theej rau lwm qhov chaw. Nyob rau hauv no cell, uas yog nyob mis yuav pub dawb. Hloov tsuas yog tus txheeb ze mus thiab tsis tshua tas li.

Txav ib lub mis, muab tus cursor ntawm lub ces kaum ntawm lub cell mus tso saib lub ob mog xub. Tuav cia tus nas khawm, koj yuav cab nws mus rau lub kev kawm qhov chaw.