Qhov wikiHow qhia yuav ua li cas los sib piv cov ntaub ntawv sib txawv hauv Excel, los ntawm ob kab hauv tib daim ntawv nthuav tawm mus rau ob daim Excel sib txawv.
Cov kauj ruam
Txoj Kev 1 ntawm 3: Sib Piv Ob Kab
Kauj Ruam 1. Tshaj tawm thawj lub xov tooj ntawm kab kem
Thaum sib piv ob kab ntawv hauv ib daim ntawv ua haujlwm, koj yuav tau txais koj cov txiaj ntsig mus rau kab uas tsis muaj dab tsi. Nco ntsoov tias koj tab tom pib ua kab ib yam li ob kab uas koj tab tom sib piv.
Piv txwv li, yog tias ob kab koj xav sib piv pib ntawm A2 thiab B2, hais txog C2
Kauj Ruam 2. Ntaus cov mis sib piv rau thawj kab
Ntaus cov qauv hauv qab no, uas yuav sib piv A2 thiab B2. Hloov cov txiaj ntsig ntawm tes yog tias koj kab pib ntawm cov cell sib txawv:
= YOG (A2 = B2, "Match", "No match")
Kauj Ruam 3. Nyem ob npaug rau Sau lub thawv hauv qab ntawm lub cell
Qhov no yuav siv cov qauv rau cov seem ntawm cov cell hauv kab ntawv, txiav kho qhov tseem ceeb kom phim.
Kauj Ruam 4. Saib rau Match thiab Tsis muaj qhov sib tw.
Cov no yuav qhia seb cov ntsiab lus ntawm ob lub cell puas muaj cov ntaub ntawv sib xws. Qhov no yuav ua haujlwm rau cov hlua, hnub tim, tus lej, thiab sijhawm. Nco ntsoov tias rooj plaub tsis raug txiav txim siab ("RED" thiab "liab" yuav phim).
Txoj Kev 2 ntawm 3: Sib Piv Ob Phau Ntawv Ua Haujlwm Ib Leeg Ib Sab
Kauj Ruam 1. Qhib thawj phau ntawv koj xav muab piv rau
Koj tuaj yeem siv View Side by Side feature hauv Excel los saib ob daim Excel sib txawv ntawm lub vijtsam tib lub sijhawm. Qhov no muaj qhov txiaj ntsig ntxiv ntawm kev rub ob nplooj ntawv ib zaug.
Kauj Ruam 2. Qhib phau ntawv ua haujlwm thib ob
Tam sim no koj yuav tsum muaj ob qhov piv txwv ntawm Excel qhib hauv koj lub computer.
Kauj Ruam 3. Nyem rau View tab ntawm ob lub qhov rai
Kauj Ruam 4. Nyem Saib Side by Side
Koj yuav pom qhov no hauv ntu Qhov rai ntawm kab. Ob phau ntawv ua haujlwm yuav tshwm nyob rau ntawm qhov screen, taw qhia kab rov tav.
Kauj Ruam 5. Nyem Npaj Txhua Yam kom hloov txoj kev taw qhia
Kauj Ruam 6. Nyem Ntsug thiab ces OK.
Phau ntawv ua haujlwm yuav hloov pauv kom ib qho nyob rau sab laug thiab lwm qhov nyob ntawm sab xis.
Kauj Ruam 7. Qhib hauv ib lub qhov rais kom txav mus rau ob qho tib si
Thaum Ib Sab Los Ib Sab tau qhib, scrolling yuav synchronized ntawm ob lub qhov rais. Qhov no yuav tso cai rau koj yooj yim nrhiav qhov sib txawv thaum koj nqes los ntawm daim ntawv teev npe.
Koj tuaj yeem kaw qhov tshwj xeeb no los ntawm txhaj rau Synchronous Scrolling khawm hauv View tab
Txoj Kev 3 ntawm 3: Sib Piv Ob Daim Ntawv rau Qhov Sib Txawv
Kauj Ruam 1. Qhib phau ntawv ua haujlwm uas muaj ob nplooj ntawv uas koj xav sib piv
Txhawm rau siv cov qauv sib piv no, ob daim ntawv yuav tsum nyob hauv tib phau ntawv ua haujlwm.
Kauj Ruam 2. Nyem rau + khawm los tsim daim ntawv tshiab
Koj yuav pom qhov no hauv qab ntawm qhov screen rau sab xis ntawm koj daim ntawv qhib.
Kauj Ruam 3. Muab koj tus cursor tso rau hauv cell A1 ntawm daim ntawv tshiab
Kauj Ruam 4. Nkag mus rau tus lej piv
Ntaus lossis luam cov qauv hauv qab no rau hauv A1 ntawm koj daim ntawv tshiab:
= YOG (Sheet1! A1 Sheet2! A1, "Sheet1:" & Sheet1! A1 & "vs Sheet2:" & Sheet2! A1, "")
Kauj Ruam 5. Nyem thiab rub lub Sau rau ntawm lub ces kaum ntawm lub cell
Kauj Ruam 6. Luag qhov Sau rau hauv qab
Luag nws qis kom deb li thawj ob nplooj ntawv mus. Piv txwv li, yog tias koj daim ntawv teev npe poob mus rau Kab 27, rub lub thawv Sau rau hauv kab ntawd.
Kauj Ruam 7. Luag qhov Sau rau sab xis
Tom qab rub nws, rub nws mus rau sab xis kom npog cov ntawv qub. Piv txwv li, yog tias koj daim ntawv nthuav qhia mus rau Kab Q, rub lub Sau rau ntawm lub kem ntawd.
Kauj Ruam 8. Saib qhov sib txawv ntawm cov cell uas tsis sib xws
Tom qab rub lub Sau lub thawv hla daim ntawv tshiab, koj yuav pom cov cell sau qhov sib txawv ntawm cov ntawv tau pom. Lub xovtooj ntawm tes yuav tso saib tus nqi ntawm xovtooj hauv thawj daim ntawv thiab tus nqi ntawm tib lub xovtooj ntawm daim ntawv thib ob.