Qhov wikiHow no qhia koj li cas txhawm rau kho cov npe uas twb muaj lawm hauv Microsoft Excel daim ntawv nthuav tawm.
Cov kauj ruam
Txoj Kev 1 ntawm 3: Hloov Kho Cov Npe Raws Li Lub Npe Npe
Kauj Ruam 1. Qhib phau ntawv ua haujlwm uas muaj cov npe teev cia
Ob npaug nias rau cov ntaub ntawv ntawm koj lub computer yuav qhib nws hauv Microsoft Excel.
Kauj Ruam 2. Sau cov kev xaiv ntxiv rau daim ntawv teev npe
Txog qhov piv txwv no, peb yuav ntxiv ob qhov txiaj ntsig tshiab rau hauv cov npe hauv kab lus A. Ntaus txhua qhov kev xaiv ntxiv rau hauv nws tus kheej ntawm tes hauv qab ntawm daim ntawv teev npe tam sim no.
Kauj Ruam 3. Nyem rau Cov Ntawv qhia zaub mov
Nws nyob rau sab saum toj ntawm Excel.
Kauj Ruam 4. Nyem Npe Tus Thawj Coj
Nws nyob ze ntawm qhov nruab nrab ntawm kab ntawv nyob rau sab saum toj ntawm Excel. Ib daim ntawv teev cov npe muaj ntau yam yuav tshwm sim.
Kauj Ruam 5. Nyem rau kab uas muaj koj cov npe teev cia
Kauj Ruam 6. Nyem rau sab xub ntiag taw tes
Nws yog sab xis ntawm "Xa mus rau" lub thawv hauv qab ntawm Tus Thawj Tswj Lub Npe. Qhov no yuav ua rau Tus Thawj Tswj Npe rau qhov me me.
Kauj Ruam 7. Xaiv tag nrho cov cell hauv cov ntawv qhia zaub mov nco-down
Nco ntsoov suav nrog cov txiaj ntsig tshiab uas koj tau ntxiv.
Piv txwv, yog tias cov khoom hauv koj daim ntawv teev npe poob nyob hauv A2 txog A9, hais txog A2 txog A9
Kauj Ruam 8. Nyem rau khawm-taw tes khawm ntawm Tus Thawj Tswj Lub Npe
Nws nyob rau sab saum toj ntawm koj daim ntawv (lub thawv koj tau tawg ua ntej lawm). Qhov no rov nthuav dav Lub Npe Tus Thawj Coj.
Kauj Ruam 9. Nyem Kaw
Cov lus pom zoo yuav tshwm sim.
Kauj Ruam 10. Nyem Yog
Cov kev xaiv tshiab uas koj nkag mus tam sim no suav nrog hauv cov ntawv qhia zaub mov nco-down.
Txoj Kev 2 ntawm 3: Hloov Kho Cov Npe Raws Li Ntau Yam Ntawm Cov Cells
Kauj Ruam 1. Qhib phau ntawv ua haujlwm uas muaj cov npe teev cia
Ob npaug nias rau cov ntaub ntawv ntawm koj lub computer yuav qhib nws hauv Microsoft Excel.
Kauj Ruam 2. Sau cov kev xaiv ntxiv rau daim ntawv teev npe
Txog qhov piv txwv no, peb yuav ntxiv ob qhov txiaj ntsig tshiab rau hauv cov npe hauv kab lus A. Ntaus txhua qhov kev xaiv ntxiv rau hauv nws tus kheej ntawm tes hauv qab ntawm daim ntawv teev npe tam sim no.
Kauj Ruam 3. Nyem rau Data menu
Nws nyob rau sab saum toj ntawm qhov screen.
Kauj Ruam 4. Nyem rau daim ntawv teev npe
Nws yog lub xov tooj ntawm tes nyob rau sab saum toj ntawm cov npe uas muaj cov xub xub nqes taw.
Kauj Ruam 5. Nyem Cov ntaub ntawv siv tau
Nws nyob hauv pab pawg "Cov Ntaub Ntawv" hauv kab ntawv nyob rau sab saum toj ntawm Excel. Qhov no qhib qhov Kev Tshawb Xyuas Cov Ntaub Ntawv.
Kauj Ruam 6. Nyem rau xub xub taw qhia
Nws nyob ib sab ntawm "Source" teb. Qhov no tsoo lub Qhov Ntsuas Cov Ntaub Ntawv qhov rai mus rau qhov me me.
Kauj Ruam 7. Xaiv qhov ntau uas muaj txhua yam khoom hauv daim ntawv teev npe
Nco ntsoov xaiv qhov qub qub nrog rau qhov uas koj nyuam qhuav ntxiv.
Kauj Ruam 8. Nyem rau kab ntawv nqes nqes nqes mus rau ntawm lub qhov rai Tshawb Xyuas Cov Ntaub Ntawv
Nov yog lub qhov rais koj tau tawg ua ntej lawm. Lub qhov rai puv yuav rov tshwm tuaj.
Kauj Ruam 9. Kos rau lub npov tom ntej no “Siv cov kev hloov pauv no rau txhua lub cell nrog tib lub chaw
”
Kauj ruam 10. Nyem OK
Tam sim no koj cov ntawv qhia zaub mov hloov tshiab.
Txoj Kev 3 ntawm 3: Kho Cov Npe nrog Phau Ntawv Nkag Nkag
Kauj Ruam 1. Qhib phau ntawv ua haujlwm uas muaj cov npe teev cia
Ob npaug nias rau cov ntaub ntawv ntawm koj lub computer yuav qhib nws hauv Microsoft Excel.
Siv txoj hauv kev no yog tias koj daim ntawv teev npe tsis yog nyob ntawm thaj tsam ntawm cov cell, tab sis hloov cov npe sib cais uas tau nkag ncaj qha rau hauv Cov Ntaub Ntawv Txheeb Xyuas qhov rai
Kauj Ruam 2. Nyem thawj lub xov tooj ntawm tes
Nov yog lub xovtooj ntawm tes nrog tus xub-taw qhia xub.
Kauj Ruam 3. Nyem rau Data menu
Nws nyob rau sab saum toj ntawm qhov screen.
Kauj Ruam 4. Nyem Cov Ntawv Pov Thawj
Nws nyob hauv ntu "Cov Ntaub Ntawv Cov Ntaub Ntawv" ntawm kab ntawv kab nyob rau sab saum toj ntawm Excel.
Kauj Ruam 5. Ntxiv lossis tshem tawm cov khoom los ntawm qhov chaw "Source"
Nco ntsoov cais txhua yam khoom nrog tus lej (,).
Piv txwv: Liab, Xiav, Ntsuab, Daj
Kauj Ruam 6. Kos rau lub npov tom ntej no “Siv cov kev hloov pauv no rau txhua lub cell nrog tib lub chaw
”
Kauj Ruam 7. Nyem OK
Tam sim no koj cov ntawv qhia zaub mov hloov tshiab.
Q&A Zej Zog
Tshawb Nrhiav Ntxiv Lus Nug Nug Cov Lus Nug 200 cim sab laug suav nrog koj tus email chaw nyob kom tau txais lus thaum lo lus nug no tau teb. Xa
