Yuav ua li cas Split Screen hauv Excel

Siv Excel cais ua qhov muag pom ntau hom ntawv luam ntawm tib daim ntawv . Splitting qhov screen faib cov lus qhia tam sim no vertically thiab / los yog horizontally rau ob los yog plaub seem uas koj pom cov cheeb tsam qub los yog sib txawv ntawm daim ntawv ua haujlwm.

Splitting qhov screen yog ib qho kev qhia rau cov khov nab kuab kom ua daim ntawv lub npe los yog lub npe ntawm kev tshuaj ntsuam thaum koj hloov. Tsis tas li ntawd, cais cov ntxig yuav siv los piv ob kab los yog kab ntawm cov ntaub ntawv nyob hauv ntau seem ntawm daim ntawv ua haujlwm.

Nrhiav Split Screens

1. Nias rau ntawm saib daim ntawv ntawm txoj hlua .
2. Nyem rau ntawm Split icon kom faib qhov screen rau plaub qhov chaw.

Lus Cim: Lub Split Box Yog Tsis Muaj Ntxiv

Lub thawv cais, ib qho thib ob thiab nrov heev ntawm kev cais qhov screen hauv Excel, raug tshem tawm los ntawm Microsoft pib nrog Excel 2013.

Rau cov neeg uas siv Excel 2010 lossis 2007, cov lus qhia siv lub thawv cais tawm tuaj yeem pom hauv qab no.

Faib qhov Screen Rau Hauv Ob los yog Plaub Panes

Hauv qhov ua piv txwv no, peb yuav faib cov lus Excel rau plaub lub tsho uas siv Split icon nyob rau ntawm Daim Ntawv Qhia ntawm txoj cai.

Qhov kev xaiv no ua haujlwm los ntawm kev ntxiv ob txoj kab thiab txoj kab ntsug split tuav rau daim ntawv.

Txhua pane muaj ib daim ntawv ntawm tag nrho daim ntawv khom nqi thiab cov cais phom tuaj yeem tswj tau tus kheej los yog ua ke los pub koj pom ntau kab thiab kab ntawm cov ntaub ntawv tib lub sijhawm.

Piv txwv: Splitting Screen Ob leeg Horizontally thiab Vertically

Cov kauj ruam hauv qab no hais txog yuav ua li cas faib cov Excel screen ob leeg horizontally thiab vertically siv Split feature.

Muab cov ntaub ntawv ntxiv

Txawm hais tias cov ntaub ntawv tsis tas yuav muaj rau cov vijtsam phom mus ua haujlwm, nws ua kom yooj yim rau kev nkag siab txog cov kev ua haujlwm li cas yog tias ib daim ntawv khauj uas muaj cov ntaub ntawv siv.

1. Qhib cov ntawv ua haujlwm uas muaj cov ntaub ntawv tsim nyog lossis ntxiv ob peb kab ntawm cov ntaub ntawv - xws li cov ntaub ntawv pom hauv daim duab saum toj no - rau ib daim ntawv ua haujlwm.
2. Nco ntsoov tias koj tuaj yeem siv tus tuav ua kom tiav-pib lub hnub ntawm lub limtiam thiab cov kabmob tom qab hauv qab xws li Sample1, Sample2 thiab lwm yam.

Splitting Screen hauv plaub

1. Nias rau ntawm saib daim ntawv ntawm txoj hlua.
2. Nyem rau ntawm Split icon tig rau ntawm qhov muab faib qhov screen.
3. Ob txoj kab thiab txoj kab ntsug split yuav tsum tshwm nyob rau hauv nruab nrab ntawm cov ntawv ua haujlwm.
4. Hauv txhua ntawm plaub tus plaub plaub tsim los ntawm cov kab tuav cais yuav tsum yog ib daim qauv ntawm cov ntawv ua haujlwm.
5. Yuav tsum muaj ob feem ntsug kev tuav ntawm sab xis ntawm lub vijtsam thiab ob txoj kab sib qaum ntawm cov vijtsam.
6. Siv cov kwj tho kev txav mus rau hauv txhua lub quadrant.
7. Tso qhov ntxeev tuav los ntawm txhaj rau lawv thiab cab lawv nrog nas.

Splitting Screen nyob rau hauv Ob

Yuav kom txo cov naj npawb ntawm ob, rub ib qho ntawm ob txoj kab cais rau sab saum toj lossis sab xis ntawm lub vijtsam.

Piv txwv, kom muaj qhov screen split horizontally, luag qhov feem ntsug ntawm qhov sib txawv rau sab xis los yog deb sab laug ntawm daim ntawv khom nqi, tawm tsuas yog txoj kab tav toj los phua lub npo.

Tshem tawm Cov Kab Ntxaij

Tshem tag nrho cov ntxig cov ntxaij lim dej:

• Nias rau saib> Split tig lub split screen feature tawm;

los yog

• Luag ob tog phom rau ob sab ntawm lub vijtsam; nrog ob tuav nyob rau hauv txoj hauj lwm no, cais cov cim ntawm qhov ribbon muab tua.

Split lub Excel Screen Nrog Split Box

Splitting Screen Nrog Split Box

Raws li tau hais saum toj no, cais lub thawv tau raug tshem tawm ntawm Excel pib nrog Excel 2013.

Ib qho piv txwv ntawm kev siv lub thawv cais yog tso rau hauv qab no rau cov neeg uas siv Excel 2010 lossis 2007 uas xav siv qhov feature.

Piv txwv: Split Screens Nrog Split Box

Raws li pom hauv daim duab saum toj no, peb yuav faib cov npo Excel ua ntej siv lub thawv cais ntawm qhov saum toj ntawm lub scrollbar ntsug.

Lub voj kab ntsug yog nyob rau hauv qab ntawm kaum sab xis ntawm tus npo Excel, nruab nrab ntawm txoj kev ntsug thiab kab rov tav.

Siv lub thawv split es tsis yog qhov kev xaiv split uas nyob rau hauv Daim Ntawv Txhawb Tsab Ntawv tso cai rau koj muab qhov screen rau hauv ib qho kev taw qhia xwb - uas yog cov neeg siv feem ntau xav tau.

Muab cov ntaub ntawv ntxiv

Txawm hais tias cov ntaub ntawv tsis tas yuav muaj rau cov vijtsam phom mus ua haujlwm, nws ua kom yooj yim rau kev nkag siab txog cov kev ua haujlwm li cas yog tias ib daim ntawv khauj uas muaj cov ntaub ntawv siv.

1. Qhib ib daim ntawv ua haujlwm uas muaj cov ntaub ntawv tsim nyog lossis ntxiv ob peb kab ntawm cov ntaub ntawv - xws li cov ntaub ntawv pom hauv daim duab saum toj no - rau ib daim ntawv ua haujlwm
2. Nco ntsoov tias koj tuaj yeem siv txoj kev tuav kom pib-pib lub hnub ntawm lub limtiam thiab cov kabmob tom qab lub npe xws li Sample1, Sample2, thiab lwm yam.

Splitting Screen Ntsuas Horizontally

1. Muab lub pointer pointer hla lub thawv cais saum toj saud ntsug raws li tau hais hauv daim duab saum toj no.
2. Tus pointer nas yuav hloov mus rau ob lub hau dub dub thaum koj hla lub thawv cais.
3. Thaum tus nas pointer hloov, nias thiab puag hauv pob nyem khawm .
4. Ib kab rov tav tsaus nti yuav tsum tshwm sim saum toj ib kab ntawm cov ntawv ua haujlwm.
5. Tsum tus nas pointer downward.
6. Kab rov tav kab yuav tsum ua raws li tus nas pointer.
7. Thaum tus nas pointer qab hauv qab kab ntawm cov kab ntawv hauv daim ntawv ua haujlwm tso rau sab laug nas khawm.
8. Ib txoj kab ntawm txoj kab rov tav yuav tsum tshwm nyob rau hauv daim ntawv hais tias nas khawm tso tawm.
9. Tshaj siab thiab qis dua hauv lub tsho khawm yuav tsum yog ob daim qauv ntawm daim ntawv ua haujlwm.
10. Yuav tsum muaj ob feem ntsug kev tuav ntawm sab xis ntawm lub vijtsam.
11. Siv ob txoj kab tuav yoov los tso cov ntaub ntawv kom lub sab xaib sab nraud pom ntawm qhov chaw seem thiab tag nrho ntawm cov ntaub ntawv hauv qab no.
12. Txoj hauj lwm ntawm qhov muab faib cais yuav hloov pauv ntau npaum li qhov tsim nyog.

Tshem tawm Cov Kab Ntxaij

Koj muaj ob txoj kev xaiv kom tshem tau cov ntxaij lim dej:

1. Nias rau ntawm lub thawv cais ntawm sab xis ntawm lub vijtsam thiab rub nws rov qab mus rau saum toj ntawm daim ntawv ua haujlwm.
2. Nias rau ntawm saib> Split icon los tua qhov kev tua split feature.