Kab lus no tsom mus rau yuav ua li cas sib piv cov ntaub ntawv ntawm ob daim ntawv Excel sib txawv. Thaum koj tau txais kev tswj hwm thiab sib piv cov ntaub ntawv, koj yuav xav siv Saib, Txheeb Xyuas, thiab Sib Piv los pab koj txheeb xyuas.
Cov kauj ruam
Txoj Kev 1 ntawm 4: Siv Excel's View Side by Side Feature
Kauj Ruam 1. Qhib phau ntawv ua haujlwm uas koj xav tau los sib piv
Koj tuaj yeem pom cov no los ntawm kev qhib Excel, nyem Cov ntaub ntawv ces Qhib, thiab xaiv ob phau ntawv ua haujlwm los sib piv los ntawm cov ntawv qhia zaub mov uas tshwm.
Nkag mus rau daim nplaub tshev uas koj muaj Excel phau ntawv khaws tseg, xaiv txhua phau ntawv ua haujlwm cais, thiab khaws ob phau ntawv ua haujlwm qhib
Kauj ruam 2. Nyem rau Saib tab
Thaum koj tau qhib ib qho ntawm phau ntawv ua haujlwm, koj tuaj yeem nyem rau ntawm Saib tab nyob rau sab saum toj-nruab nrab ntawm lub qhov rais.
Kauj Ruam 3. Nyem Saib Side by Side
Qhov no nyob hauv Pawg Window ntawm txoj kab rau rau Saib menu thiab muaj ob nplooj ntawv raws li nws lub cim. Qhov no yuav rub ob daim ntawv ua haujlwm mus rau hauv lub qhov rais me me ua ke ntsug.
- Qhov kev xaiv no yuav tsis tuaj yeem pom pom hauv qab Saib tab yog tias koj tsuas muaj ib phau ntawv ua haujlwm qhib hauv Excel.
- Yog tias muaj ob phau ntawv ua haujlwm qhib, tom qab ntawd Excel yuav cia li xaiv cov ntawv no ua cov ntaub ntawv los saib ib sab.
Kauj Ruam 4. Nyem Npaj Txhua Yam
Qhov teeb tsa no tso cai rau koj hloov qhov kev taw qhia ntawm phau ntawv ua haujlwm thaum lawv tau tso tawm ib sab.
Hauv cov ntawv qhia zaub mov uas tshwm tuaj, koj tuaj yeem xaiv kom muaj phau ntawv ua haujlwm Kab rov tav, Ntsug, Cascade, los yog Pobzeb.
Kauj Ruam 5. Pab kom Synchronous Scrolling
Thaum koj muaj ob daim ntawv ua haujlwm qhib, nyem rau Synchronous Scrolling (nyob hauv qab Saib Sab Ntawm Ib Sab xaiv) kom ua kom yooj yim dua los ntawm ob qho Excel cov ntaub ntawv kab-los-kab txhawm rau txheeb xyuas qhov sib txawv ntawm cov ntaub ntawv tus kheej.
Kauj Ruam 6. Scroll los ntawm ib phau ntawv ua haujlwm txhawm rau txhawm rau hla ob qho tib si
Thaum Synchronous Scrolling tau qhib, koj yuav tuaj yeem yooj yim rub los ntawm ob phau ntawv ua haujlwm tib lub sijhawm thiab sib piv lawv cov ntaub ntawv yooj yim dua.
Txoj Kev 2 ntawm 4: Siv Kev Tshawb Nrhiav
Kauj Ruam 1. Qhib phau ntawv ua haujlwm uas koj xav tau los sib piv
Koj tuaj yeem pom cov no los ntawm kev qhib Excel, nyem Cov ntaub ntawv ces Qhib, thiab xaiv ob phau ntawv ua haujlwm los sib piv los ntawm cov ntawv qhia zaub mov uas tshwm.
Nkag mus rau daim nplaub tshev uas koj muaj Excel phau ntawv khaws tseg, xaiv txhua phau ntawv ua haujlwm cais thiab khaws ob phau ntawv ua haujlwm qhib
Kauj Ruam 2. Txiav txim seb lub cell twg koj xav kom tus neeg siv xaiv los ntawm
Nov yog qhov uas cov npe teev cia yuav tshwm tom qab.
Kauj Ruam 3. Nyem rau ntawm tes
Ciam teb yuav tsum tsaus ntuj.
Kauj Ruam 4. Nyem rau DATA tab ntawm lub cuab yeej
Thaum koj tau nyem rau nws, xaiv VALIDATION nyob rau hauv cov ntawv qhia zaub mov nco-down. Ib qho pop up yuav tsum tshwm sim.
Yog tias koj siv Excel qub, DATA toolbar yuav tshwm tuaj thaum koj xaiv lub DATA tab thiab tso saib Kev Txheeb Xyuas Cov Ntaub Ntawv raws li qhov kev xaiv hloov chaw Kev lees paub.
Kauj Ruam 5. Nyem Sau hauv ALLOW list
Kauj Ruam 6. Nyem lub pob nrog tus xub liab
Qhov no yuav cia koj xaiv koj cov peev txheej (hauv lwm lo lus, koj thawj kab ntawv), uas tom qab ntawd yuav ua tiav rau hauv cov ntaub ntawv hauv cov ntawv qhia zaub mov nco-down.
Kauj Ruam 7. Xaiv thawj kab ntawm koj daim ntawv thiab nyem Enter
Nyem OK thaum cov ntaub ntawv lees paub qhov rai tshwm. Koj yuav tsum pom lub npov uas muaj tus xub ntawm nws, uas yuav poob qis thaum koj nyem xub.
Kauj Ruam 8. Xaiv lub cell uas koj xav tau lwm cov ntaub ntawv los qhia
Kauj Ruam 9. Nyem rau Insert and Reference tabs
Hauv cov ntawv qub ntawm Excel, koj tuaj yeem hla nyem rau Ntxig tab thiab tsuas yog nyem rau ntawm Kev ua haujlwm tab los rub tawm Nrhiav & Siv qeb.
Kauj Ruam 10. Xaiv Saib & Siv los ntawm cov npe pawg
Kauj Ruam 11. Nrhiav Kev Tshawb Nrhiav hauv cov npe
Thaum koj nyem ob zaug nws, lwm lub npov yuav tshwm thiab koj tuaj yeem nyem OK.
Kauj Ruam 12. Xaiv lub xovtooj ntawm tes nrog daim ntawv teev npe qis rau qhov lookup_value
Kauj Ruam 13. Xaiv thawj kab ntawm koj daim ntawv teev npe rau Lookup_vector
Kauj Ruam 14. Xaiv kab thib ob ntawm koj daim ntawv teev npe rau Result_vector
Kauj Ruam 15. Xaiv ib yam los ntawm daim ntawv teev npe
Cov ntaub ntawv yuav tsum hloov pauv.
Txoj Kev 3 ntawm 4: Siv XL Comparator
Kauj Ruam 1. Qhib koj tus browser thiab mus rau
Qhov no yuav coj koj mus rau XL Sib Piv lub vev xaib, qhov uas koj tuaj yeem xa ob phau ntawv Excel rau kev sib piv.
Kauj Ruam 2. Nyem Xaiv Cov Ntaub Ntawv
Qhov no yuav qhib lub qhov rai uas koj tuaj yeem txav mus rau ib qho ntawm ob daim ntawv Excel koj xav sib piv. Nco ntsoov xaiv cov ntawv rau ob daim teb.
Kauj Ruam 3. Nyem Next> mus ntxiv
Thaum koj tau xaiv qhov no, cov lus tshaj tawm yuav tsum tshwm nyob rau sab saum toj ntawm nplooj ntawv kom koj paub tias cov txheej txheem xa cov ntaub ntawv tau pib thiab cov ntaub ntawv loj dua yuav siv sijhawm ntev dua los ua. Nyem Ok kaw cov lus no.
Kauj Ruam 4. Xaiv kab uas koj xav kom luam theej duab
Hauv qab txhua lub npe cov ntaub ntawv yog cov ntawv qhia zaub mov nco uas hais tias Xaiv ib kem. Nyem rau ntawm cov ntawv qhia zaub mov nco-down rau txhua cov ntawv txhawm rau xaiv kab ntawv uas koj xav kom ua kom pom tseeb rau kev sib piv.
Cov npe kab yuav pom thaum koj nyem rau ntawm cov ntawv qhia zaub mov nco-down
Kauj Ruam 5. Xaiv cov ntsiab lus rau koj cov ntawv ua tiav
Muaj plaub qhov kev xaiv nrog npuas nyob ib sab ntawm lawv hauv pawg no, ib qho uas koj yuav tsum tau xaiv raws li cov txheej txheem txheej txheem rau koj cov ntaub ntawv tshwm sim.
Kauj Ruam 6. Xaiv cov kev xaiv kom yooj yim kem sib piv
Hauv qab ntawm tes ntawm cov ntawv qhia sib piv, koj yuav pom ob qhov xwm txheej ntxiv rau koj daim ntawv sib piv: Tsis quav ntsej cov ntawv loj/ntawv me thiab Tsis quav ntsej "chaw" ua ntej thiab tom qab qhov tseem ceeb. Nyem rau ntawm lub npov rau ob qho ua ntej yuav pib.
Kauj Ruam 7. Nyem Next> mus ntxiv
Qhov no yuav coj koj mus rau nplooj ntawv rub tawm rau koj cov ntaub ntawv tshwm sim.
Kauj Ruam 8. Rub koj daim ntawv sib piv
Thaum koj tau tshaj tawm koj phau ntawv ua haujlwm thiab teeb tsa koj qhov ntsuas, koj yuav muaj daim ntawv qhia kev sib piv ntawm cov ntaub ntawv hauv ob daim ntawv muaj rau rub tawm. Nyem qhov underlined Nyem qhov no text nyob rau hauv Rub tawm cov ntawv sib piv lub thawv
Yog tias koj xav khiav lwm qhov kev sib piv, nyem Kev sib piv tshiab nyob rau hauv qab-txoj cai ces kaum ntawm nplooj ntawv kom rov pib ua cov txheej txheem upload.
Txoj kev 4 ntawm 4: Nkag mus rau Excel Cov Ntaub Ntawv Ncaj Ncees los ntawm Cell
Kauj Ruam 1. Nrhiav koj phau ntawv teev npe thiab npe ntawv
-
Hauv qhov no, peb siv peb phau ntawv ua piv txwv nyob thiab muaj npe raws li hauv qab no:
- C: / Sib piv / Book1.xls (muaj ib daim ntawv hu ua "Muag 1999")
- C: / Sib piv / Book2.xls (muaj ib daim ntawv hu ua "Muag Khoom 2000")
- Ob phau ntawv ua haujlwm muaj thawj kab “A” nrog lub npe ntawm cov khoom, thiab kab ntawv thib ob “B” nrog tus nqi muag txhua xyoo. Thawj kab yog lub npe ntawm kab ntawv.
Kauj Ruam 2. Tsim phau ntawv sib piv
Peb yuav ua haujlwm ntawm Book3.xls los ua qhov sib piv thiab tsim ib kem uas muaj cov khoom lag luam, thiab ib qho nrog qhov sib txawv ntawm cov khoom no ntawm ob xyoos.
C: / Sib piv / Book3.xls (muaj ib daim ntawv hu ua "Sib Piv")
Kauj Ruam 3. Muab lub npe ntawm kab ntawv
Tsuas yog nrog "Book3.xls" qhib, mus rau ntawm tes "A1" thiab ntaus:
- = 'C: / Sib piv [Book1.xls] Muag Xyoo 1999'! A1
- Yog tias koj siv lwm qhov chaw hloov "C: / Sib piv \" nrog qhov chaw ntawd. Yog tias koj siv lwm lub npe ntawv tshem tawm "Book1.xls" thiab ntxiv koj lub npe ntawv hloov chaw. Yog tias koj siv lwm daim ntawv hloov npe "Muag 1999" nrog lub npe ntawm koj daim ntawv. Ceev faj tsis txhob muaj cov ntawv koj hais ("Book1.xls") qhib: Excel tuaj yeem hloov pauv qhov koj siv yog tias koj qhib. Koj yuav xaus nrog lub xovtooj uas muaj cov ntsiab lus zoo ib yam li lub xovtooj uas koj xa mus.
Kauj Ruam 4. Drag down cell “A1” kom teev tag nrho cov khoom lag luam
Lob nws los ntawm kab hauv qab txoj cai thiab rub nws, theej txhua lub npe.
Kauj Ruam 5. Npe lub kem thib ob
Hauv qhov no, peb hu nws "Sib txawv" hauv "B1".
Kauj Ruam 6. (Piv txwv) Kwv yees qhov sib txawv ntawm txhua yam khoom
Hauv qhov no, los ntawm kev ntaus hauv cell "B2":
- = 'C: / Sib piv [Book2.xls] Muag 2000'! B2-'C: / Sib piv [Book1.xls] Muag 1999 '! B2
- Koj tuaj yeem ua haujlwm ib txwm ua haujlwm Excel nrog lub xovtooj xa los ntawm cov ntaub ntawv xa mus.
