Thaum ua haujlwm nrog cov ntxhuav, uas suav nrog ntau ntawm cov kab lossis kab ntawv, cov lus nug ntawm cov qauv ntaub ntawv cov qauv cuam tshuam. Nyob rau hauv Excel, qhov no tuaj yeem ua tiav los ntawm kev siv pawg ntawm cov ntsiab lus sib xws. Cov cuab yeej no tso cai tsuas yog tsis tsuas yog daws cov ntsiab lus tsis txaus, uas tso cai rau koj mloog zoo rau koj cov lus ntawm rooj. Cia peb kawm saib yuav ua li cas ua ib pab pawg hauv expele.
Teeb tsa Grouping
Ua ntej ua tiav rau cov pawg lossis txhua, koj yuav tsum tau teeb tsa cov cuab yeej no kom txog thaum kawg cov txiaj ntsig tau ze rau cov neeg muaj kev cia siab.
- Mus rau "cov ntaub ntawv" tab.
- Nyob rau hauv qis sab laug kaum ntawm "tus qauv" cuab yeej thaiv ntawm Ribbon muaj ib tug me me inclined xub. Nyem rau ntawm nws.
- Ib pab pawg teeb tsa qhov rai qhib. Raws li peb pom los ntawm lub neej ntawd nws tau tsim kom cov txiaj ntsig thiab cov npe ntawm txhua tus yog nyob rau sab xis ntawm lawv, thiab nyob rau hauv kab - hauv qab no. Nws tsis haum cov neeg siv ntau, raws li nws yooj yim dua thaum lub npe tso rau saum toj. Ua li no, koj yuav tsum tshem tus zuam los ntawm cov khoom sib xws. Feem ntau, txhua tus neeg siv tuaj yeem txhim kho cov tsis raug rau nws tus kheej. Ib qho ntxiv, koj tuaj yeem tam sim ntawd suav nrog cov cwj pwm tsis siv neeg los ntawm kev txhim kho tus zuam nyob ze lub npe no. Tom qab cov chaw yog nthuav tawm, nyem rau ntawm "OK" khawm.
Ntawm qhov kev teeb tsa cov pab pawg tsis nyob hauv Excel yog ua tiav.
Pab pawg ntawm cov hlua
Ua ib pawg ntawm cov ntaub ntawv ntawm kab.
- Ntxiv ib txoj kab hla ib pawg ntawm txhua pawg lossis hauv qab, nyob ntawm seb peb yuav npaj li cas muab cov npe thiab cov txiaj ntsig. Hauv cov xovtooj tshiab peb qhia lub npe ntawm cov pab pawg tsis xws li, haum rau nws los ntawm cov ntsiab lus teb.
- Peb tau hais txog cov kab uas yuav tsum tau ua pawg, ntxiv rau txoj hlua kawg. Mus rau "cov ntaub ntawv" tab.
- Ntawm daim kab xev hauv "Cov Qauv" Tool thaiv los ntawm txhaj rau "Grind" khawm.
- Ib qhov rai me me qhib uas koj xav tau teb tias peb xav tau pab pawg - cov hlua los yog kab ntawv. Peb muab qhov hloov mus rau "txoj hlua" txoj haujlwm thiab nyem rau ntawm "OK" khawm.
Qhov kev tsim no tau ua tiav ntawm qhov no. Txhawm rau yob nws txaus kom nyem rau ntawm "rho tawm" kos npe.
Txhawm rau rov ua pab pawg, koj yuav tsum nyem rau ntawm daim paib ntxiv.
Pab pawg ntawm txhua
Ib yam li ntawd, pab pawg ntawm txhua yog nqa tawm.
- Ntawm sab xis lossis sab laug ntawm cov ntaub ntawv pawg, ntxiv ib kem tshiab thiab qhia hauv nws lub npe sib xws ntawm cov pab pawg.
- Xaiv cov cell hauv kab uas yuav mus pab pawg, tshwj tsis yog cov kem nrog lub npe. Nyem rau ntawm "Grind" khawm.
- Nyob rau hauv lub qhov rais uas qhib lub sijhawm no, peb muab qhov hloov mus rau "kab" txoj hauj lwm. Nyem rau ntawm "OK" khawm.
Cov pab pawg tau npaj txhij. Ib yam li ntawd, raws li thaum pawg ib pawg, nws tuaj yeem muab tais thiab tso tawm los ntawm nias ntawm "rho tawm" thiab "ntxiv rau".
Tsim Cov Pab Pawg Nyob Nesteded
Hauv Excel, koj tuaj yeem tsim tsis tsuas yog ua ntej-pawg, tab sis kuj tau nqis peev. Rau qhov no, nws yog ib qho tsim nyog hauv kev xa tawm pawg pab pawg kom tau hais txog qee cov cell hauv nws, uas koj yuav mus pab pawg sib cais. Tom qab ntawd nws yuav tsum ua ib qho ntawm cov txheej txheem uas tau piav saum toj no, nyob ntawm seb koj ua haujlwm nrog kab ntawv lossis kab.
Tom qab ntawd, cov pab pawg nyob neeb yuav npaj tau. Koj tuaj yeem tsim cov lej ntawm cov ntawv txuas zoo sib xws. Kev tshawb fawb ntawm lawv yog ib qho yooj yim siv, txav los ntawm cov lej uas nyob ntawm sab laug lossis sab saum toj ntawm daim ntawv, nyob ntawm seb txoj hlua lossis txhua pawg tau ua pawg.
Ntshaw
Yog tias koj xav kom hloov kho dua tshiab lossis tsuas yog rho tawm ib pab pawg, nws yuav tsum tau sib tshuam.
- Xaiv cov hlwb ntawm kab ntawv lossis kab uas yuav raug teeb meem. Nyem rau ntawm "Ungroup" khawm, nyob ntawm daim kab xev hauv "cov qauv" chaw thaiv.
- Nyob rau hauv lub qhov rai tau pom, peb xaiv qhov uas peb yuav tsum tau txiav tawm: kab lossis kab. Tom qab ntawd, peb nyem rau ntawm "OK" khawm.
Tam sim no cov pab pawg tau hais tseg yuav raug disbanded, thiab cov ntawv qauv yuav coj nws thawj.
Raws li koj tuaj yeem pom, tsim ib pawg ntawm txhua lossis kab yog qhov yooj yim heev. Nyob rau tib lub sijhawm, tom qab cov txheej txheem no, tus neeg siv yuav ua rau nws tau yooj yim dua ua haujlwm nrog lub rooj, tshwj xeeb tshaj yog tias nws loj heev. Hauv qhov no, kev tsim cov pab neeg nyob tseem muaj peev xwm pab tau. Txhawm rau nqa tawm tsis sib haum raws li qhov yooj yim raws li cov ntaub ntawv ua ke.