Qhov wikiHow no qhia koj li cas los sib piv ob daim ntawv sib txawv hauv Microsoft Excel, los ntawm ob kab ntawv ntawm tib daim ntawv nthuav qhia rau ob daim Excel sib txawv.
Kauj ruam
Txoj Kev 1 ntawm 3: Sib Piv Ob Kab
Kauj Ruam 1. Kos thawj lub xovtooj ntawm kab ntawv seem
Thaum koj xav sib piv ob kab ntawv hauv tib daim ntawv ua haujlwm, koj yuav tsum tso saib cov txiaj ntsig ntawm kev sib piv hauv ib kem seem. Xyuas kom koj xaiv cov cell nyob hauv kab ib yam li ob kab uas koj xav sib piv.
Piv txwv li, yog tias kab ntawv koj xav muab piv rau hauv cov hlwb A2 thiab B2, hais txog xov tooj ntawm tes C2
Kauj Ruam 2. Ntaus cov mis sib piv rau thawj kab ntawv
Ntaus cov qauv hauv qab no los sib piv cov ntaub ntawv hauv kab A2 thiab B2. Hloov tus nqi ntawm tes yog tias kab pib hauv lwm lub cell:
= YOG (A2 = B2, "Match", "No match")
Kauj Ruam 3. Muab ob npaug rau nyem rau ntawm lub npov hauv qab ntawm lub cell
Tom qab ntawd, cov qauv yuav raug siv rau txhua lub cell hauv kab lus tshwm sim. Yeej, cov cell hauv kab lus yuav raug kho kom haum lossis tsis sib xws cov ntaub ntawv hauv kab A2 thiab B2.
Kauj Ruam 4. Ua tib zoo saib Cov Match thiab Tsis muaj daim ntawv lo sib phim
Daim ntawv lo yuav qhia seb cov ntsiab lus ntawm cov cell hauv ob kab ntawv sib piv puas muaj cov ntaub ntawv tsim nyog lossis tsis yog. Qhov no tseem siv rau cov hlua, hnub tim, tus lej, thiab sijhawm. Nco ntsoov tias rooj plaub loj tsis txawv (piv txwv li "RED" thiab "liab" raug kho raws li cov ntaub ntawv qub).
Txoj Kev 2 ntawm 3: Sib Piv Ob Cov Ntaub Ntawv (Phau Ntawv Ua Haujlwm) Ib Sab
Kauj Ruam 1. Qhib thawj Excel cov ntawv lossis cov ntawv ua haujlwm uas koj xav kom sib piv
Koj tuaj yeem siv Excel's View Side by Side feature los saib ob daim ntawv sib txawv ntawm ib qho screen ib zaug. Nrog cov yam ntxwv no, koj tuaj yeem xaub cov ntawv ua haujlwm tib lub sijhawm.
Kauj Ruam 2. Qhib daim ntawv thib ob
Tam sim no, muaj ob daim ntawv Excel qhib hauv koj lub computer.
Kauj Ruam 3. Nyem rau View tab hauv txhua lub qhov rai file
Kauj Ruam 4. Nyem rau View Side by Side button
Nws nyob hauv Windows ntu ntawm. Tom qab ntawd, ob daim ntawv yuav tshwm ntawm qhov screen kab rov tav.
Kauj Ruam 5. Nyem Npaj Txhua Yam kom hloov txoj kev taw qhia
Kauj Ruam 6. Nyem Ntsug, ces xaiv OK
Tom qab ntawd, cov duab ntawm daim ntawv yuav hloov kom ib qho ntawm cov ntawv raug nthuav tawm ntawm sab laug, thiab lwm daim ntawv tau tshwm ntawm sab xis.
Kauj Ruam 7. Xaub nplooj ntawv hauv ib lub qhov rais kom rub nplooj ntawv hauv ob lub qhov rais
Thaum Sab Ib Leeg feature tau qhib, cov vijtsam hloov pauv siv rau ob qho tib si Excel windows. Txoj kev no, koj tuaj yeem pom qhov sib txawv ntawm cov ntaub ntawv thaum swb daim ntawv ua haujlwm.
Koj tuaj yeem kaw qhov tshwj xeeb no los ntawm txhaj rau "Synchronous Scrolling" khawm ntawm "View" tab
Txoj Kev 3 ntawm 3: Nrhiav Qhov Sib Txawv Ntawm Ob Daim Ntawv
Kauj Ruam 1. Qhib cov ntawv uas muaj ob nplooj ntawv koj xav muab piv rau
Txhawm rau siv cov qauv sib piv no, ob daim ntawv yuav tsum muab khaws cia rau hauv tib cov ntawv lossis cov ntawv ua haujlwm.
Kauj Ruam 2. Nyem rau + khawm los tsim nplooj ntawv/ntawv tshiab
Koj tuaj yeem pom lub pob nyob hauv qab ntawm lub vijtsam, nyob ib sab ntawm daim ntawv nthuav tawm/qhib.
Kauj Ruam 3. Muab tus cursor rau ntawm cell A1 hauv daim ntawv tshiab
Kauj Ruam 4. Nkag mus rau tus lej piv
Ntaus lossis luam cov qauv hauv qab no rau hauv cell A1 hauv daim ntawv tshiab:
= YOG (Sheet1! A1 Sheet2! A1, "Sheet1:" & Sheet1! A1 & "vs Sheet2:" & Sheet2! A1, "")
Kauj Ruam 5. Nyem thiab luag lub thawv rau hauv lub kaum hauv qab ntawm cell A1
Kauj Ruam 6. Luag lub thawv ntim rau hauv qab
Luag cov cell kom deb li deb ntawm cov cell uas muaj cov ntaub ntawv hauv thawj daim ntawv. Piv txwv li, yog tias cov ntaub ntawv hauv thawj kab lus tau nthuav tawm txog kab 27th, rub lub thawv ntim kom txog thaum nws mus txog kab ntawd.
Kauj Ruam 7. Rub lub npov rau sab xis
Tom qab rub nws, rub lub npov sau rau sab xis kom txog thaum nws sib phim cov ntaub ntawv ntawm thawj kab ntawv. Piv txwv li, yog thawj kab ntawv muaj cov ntaub ntawv kom txog thaum nws mus txog kab ntawv Q, rub lub thawv rau ntawm daim ntawv tshiab kom txog thaum nws mus txog tib kab.
Kauj Ruam 8. Nrhiav cov ntaub ntawv sib txawv hauv cov xov tooj sib piv
Tom qab koj rub lub thawv ntim rau ntawm daim ntawv tshiab, cov cell uas muaj qhov sib txawv ntawm cov ntaub ntawv ntawm ob nplooj ntawv raug muab sib piv yuav raug sau nrog cov txiaj ntsig ntawm kev sib piv. Cov xovtooj ntawm tes uas muaj qhov sib txawv yuav tso saib qhov tseem ceeb lossis cov ntaub ntawv los ntawm thawj kab ntawv thiab cov ntaub ntawv los ntawm tib lub xovtooj ntawm kab ntawv thib ob.
