Muaj cov xwm txheej thaum nyob hauv ib daim ntawv koj yuav tsum hloov ib lub cim (lossis pawg ntawm cov cim) nrog lwm tus. Nws tuaj yeem muaj ntau lub laj thawj, pib los ntawm qhov tsis tseem ceeb, thiab xaus nrog kev rov ua dua tus lossis tshem cov chaw. Cia peb kawm seb yuav ua li cas hloov cov cim hauv Microsoft Excel.
Yuav ua li cas los hloov cov cim hauv Excel
Ntawm chav kawm, qhov yooj yim tshaj plaws los hloov ib lub cim nrog lwm tus yog los kho cov hlwb. Tab sis, raws li kev xyaum qhia, hom no tsis yog ib qho yooj yim ib txwm muaj qhov yooj yim ntawm cov rooj loj-loj, qhov twg cov naj npawb ntawm cov cim ntawm tib hom uas yuav tsum tau hloov pauv tuaj yeem mus txog tus lej ntau. Txawm hais tias nrhiav tau lub hlwb zoo yuav tuaj yeem siv sijhawm ntau, tsis txhob hais lub sijhawm coj los kho txhua qhov.
Qhov zoo, Excel lub cuab tam muaj qhov pom thiab hloov chaw uas pab koj nrhiav cov hlwb sai uas koj xav tau thiab ua tus cwj pwm hloov hauv lawv.
Tshawb nrog hloov
Kev hloov pauv yooj yim nrog kev tshawb fawb cuam tshuam nrog hloov ib qho sib law liag thiab cov chaw nyob ruaj ruaj (cov naj npawb, cov lus, cov cim, thiab lwm yam) nrog lwm qhov tom qab cov cim no pom pom siv cov cuab yeej tshwj xeeb hauv cov cuab yeej.
- Nyem rau feem khawm Nrhiav thiab Highlightnyob rau hauv lub tab "Tsev" hauv cov chaw thaiv "Editing"Cov. Hauv daim ntawv uas tshwm tom qab no, mus rau yam khoom ntawd Hloov.
- Qhov rai qhib Nrhiav thiab Hloov hauv lub tab HloovCov. Hauv dab teb Nrhiav tau ntaus tus lej, lo lus lossis cim uas koj xav nrhiav thiab hloov. Hauv dab teb "Hloov nrog" peb ua cov ntaub ntawv tawm tswv yim seb qhov twg hloov yuav ua.
Raws li koj tuaj yeem pom, hauv qab ntawm lub qhov rais muaj cov nyees khawm hloov - Hloov Txhua Yam thiab Hloov, thiab tshawb cov nyees khawm - Nrhiav Txhua thiab "Nrhiav tom ntej"Cov. Nyem rau feem khawm "Nrhiav tom ntej".
- Tom qab ntawv, daim ntawv no raug tshawb rau lo lus tshawb. Los ntawm lub neej ntawd, tshawb kev taw qhia yog ua tiav kab los ntawm kab. Tus cursor nres ntawm qhov tshwm sim thawj zaug uas ntais ntawv. Txhawm rau hloov cov ntsiab lus ntawm lub ntsej muag, nyem rau ntawm lub pob Hloov.
- Txhawm rau tshawb mus txuas ntxiv cov ntaub ntawv, rov qab nyem rau ntawm lub pob ntawd "Nrhiav tom ntej"Cov. Tib txoj kev, peb hloov cov txiaj ntsig hauv qab no, thiab lwm yam.
Koj tuaj yeem pom tag nrho cov txiaj ntsig uas txaus siab koj qhov lus nug tam sim ntawd.
- Tom qab nkag mus rau cov lus nug tshawb thiab cov cim hloov, nyem rau ntawm lub pob Nrhiav Txhua.
- Txhua tus muaj feem cuam tshuam tshawb. Lawv cov npe, uas qhia txog tus nqi thiab chaw nyob ntawm txhua tus xov tooj ntawm tes, qhib rau hauv qab ntawm qhov rais. Tam sim no koj tuaj yeem nyem rau ntawm ib qho ntawm lub hlwb uas peb xav kom hloov, thiab nias rau lub pob Hloov.
- Tus nqi yuav raug hloov, thiab tus neeg siv tuaj yeem txuas ntxiv rau hauv cov txiaj ntsig ntawm qhov kev tshawb fawb los tshawb qhov txiaj ntsig uas nws xav tau rau cov txheej txheem rov ua dua.
Pib Hloov
Koj tuaj yeem ua qhov hloov ua haujlwm tsis siv neeg nrog nias ntawm ib tus khawm. Txhawm rau ua qhov no, tom qab nkag mus rau qhov tseem ceeb uas yuav tsum tau hloov, thiab cov txiaj ntsig uas tab tom hloov, nias lub pob Hloov Txhua.
Cov txheej txheem yuav ua tiav yuav luag tam sim ntawd.
Qhov zoo ntawm cov qauv no yog nrawm thiab yooj yim. Qhov tseem ceeb rho tawm yog tias koj yuav tsum paub tseeb tias cov cim nkag los yuav tsum tau hloov hauv txhua lub hlwb. Yog tias nyob hauv cov txheej txheem dhau los nws tuaj yeem ua kom pom thiab xaiv lub hlwb tsim nyog rau kev hloov pauv, tom qab ntawd thaum siv qhov kev xaiv no, qhov kev muaj peev xwm no cais tawm
Zaj lus qhia: yuav ua li cas los hloov qhov taw tes nrog comma hauv Excel
Ntxiv kev xaiv
Ib qho ntxiv, tseem muaj qhov ua tau ntawm kev ua haujlwm siab thiab hloov los ntawm cov haujlwm ntxiv.
- Tau rau hauv "Hloov" tab, hauv "Nrhiav thiab Hloov" lub qhov rai, nyem rau ntawm Xaiv khawm.
- Lub siab xaiv qhov rais qhib. Nws yuav luag zoo tib yam rau lub siab nrhiav ntawm lub qhov rais. Qhov tsuas yog qhov txawv yog qhov muaj nyob ntawm qhov chaw txwv. "Hloov nrog".
Tag nrho hauv qab ntawm lub luag haujlwm yog lub luag haujlwm nrhiav cov ntaub ntawv uas yuav tsum tau hloov. Ntawm no koj tuaj yeem teev qhov twg los tshawb (ntawm daim ntawv lossis thoob plaws phau ntawv) thiab yuav ua li cas los tshawb (ntawm kab lossis kab ntawv). Tsis zoo li kev tshawb nrhiav tas li, kev tshawb fawb hloov chaw yuav ua tau los ntawm cov qauv, uas yog, los ntawm cov txiaj ntsig uas tau qhia hauv cov qauv mis thaum xaiv lub cell. Tsis tas li ntawd, nyob rau ntawd, los ntawm kev kuaj lossis tsis kos lub thawv, koj tuaj yeem qhia meej seb puas yuav tshawb cov ntawv uas muaj cov tsiaj ntawv lossis yuav tsum tshawb nrhiav cov ntawv sib luag hauv lub hlwb.
Tsis tas li, koj tuaj yeem sau qhia ntawm cov hlwb ntawm hom ntawv twg tshawb nrhiav yuav ua. Txhawm rau ua qhov no, nyem rau ntawm "Hom ntawv" khawm txawv "ntsuas" parameter.
Tom qab ntawd, lub qhov rais yuav qhib rau qhov twg koj tuaj yeem hais cov hom qauv ntawm cov hlwb los tshawb.
Qhov tsuas teeb rau tus nqi yuav tsum tau tso yuav yog tib hom ntawv ntawm tes. Txhawm rau xaiv cov hom ntawv tso nrog tus nqi, nyem rau ntawm lub pob nrog tib lub npe sib xws "Hloov nrog ..." ntsuas.
Lub qub qhov rais qhib raws li nyob rau hauv cov ntaub ntawv dhau los. Qhov no teeb tsa li cas cov hlwb yuav raug teeb tsa tom qab hloov lawv cov ntaub ntawv. Koj tuaj yeem tsim kho kom haum, tus lej hom, tus xov tooj ntawm tes, ciam teb, thiab lwm yam.
Ntxiv mus, los ntawm nyem rau ntawm cov khoom siv tau los ntawm qhov muab tso tawm hauv qab khawm "Hom ntawv", koj tuaj yeem tsim hom ntawv zoo ib yam rau txhua tus xovtooj ntawm xaiv ntawm nplooj ntawv, tsuas yog xaiv nws.
Kev tshawb nrhiav kab txuas ntxiv tuaj yeem yog qhov qhia txog ntawm ntau hom hlwb ntawm cov kev tshawb fawb thiab hloov chaw yuav raug ua. Ua li no, cia li xaiv cov yam xav tau ntawm tus kheej.
- Tsis txhob hnov qab nkag mus rau qhov tsim nyog hauv thaj chaw "Nrhiav" thiab "Hloov nrog ..." teb. Thaum txhua qhov kev teeb tsa tau qhia, peb xaiv txoj kev ntawm cov txheej txheem. Tsis yog nyem rau ntawm "Hloov tag nrho" khawm, thiab hloov hloov tshwm sim cia li, raws li cov ntaub ntawv nkag mus, lossis nyem rau ntawm "Nrhiav Txhua Tus" khawm, thiab cais tawm hloov hauv txhua ntawm tes raws li cov txheej txheem piav qhia saum toj no.
Zaj lus qhia: Yuav ua li cas thiaj tshawb hauv Excel
Raws li koj tuaj yeem pom, Microsoft Excel muab cov cuab yeej ua haujlwm zoo thiab yooj yim rau kev nrhiav thiab hloov cov ntaub ntawv hauv cov ntxhuav. Yog tias koj yuav tsum tau hloov kiag li txhua hom ntawm cov nuj nqis nrog kev qhia tshwj xeeb, ces qhov no tuaj yeem ua los ntawm nias ib lub pob. Yog tias xaiv yuav tsum tau ua ntau dua, tom qab ntawd cov yam ntxwv no tau muab tag nrho rau hauv cov txheej txheem no.
