Nzira Yokuparadzanisa Chechi muExcel

Shandisai Excel pakaparadzanisa mufananidzo wekuona kuti muone ma kopi akawanda epajiro rimwechete. Kusvetura chivharo chinoparadzanisa pepa rekushandura riripo uye / kana kutenderera muzvikamu zviviri kana zvina zvinokubvumira kuti uone zvimwechete kana kuti zvakasiyana-siyana zvepepa rekushanda.

Kusvetura chinyorwa ndicho chinoshandiswa kumhepo inopisa kuti uchengetedze mazita ekushandura mapepa kana zvinyorwa pahwindo sezvaunopukunyuka. Mukuwedzera, kupatsanurwa zvidzidzo kunogona kushandiswa kuenzanisa mitsetse miviri kana mapuranga e data ari munzvimbo dzakasiyana dzebasa rekushanda.

Kutsvaga Kupatsanurwa Kwemavara

1. Dzvanya paZviona tab yebhoni .
2. Dzvanya paIndaneti yeChiparadzano kuti ugovere chinyorwa muzvikamu zvina.

Cherechedza: Bhokisi Rokuparadzanisa Harisisina

Bhokisi rakaparadzaniswa, nzira yechipiri uye yakakurumbira yekuparadzanisa chinyorwa mu Excel, yakabviswa neMicrosoft kutanga neEexcel 2013.

Kune avo vanoshandisa Excel 2010 kana 2007, mirayiridzo yekushandisa bhokisi rakaparadzaniswa inogona kuwanikwa pasi apa.

Patsanura Mukati Mukati Maviri kana mana

Mumuenzaniso uyu, isu tichaparadzanisa mufananidzo weExcel mumakumbo mana uchishandisa Ichanza cheSplit chiri paTarisa tab yebhoni.

Iyi sarudzo inoshanda kuburikidza kuwedzera mabheji akaparadzana uye akajeka kupatsanangurira kumushandi webasa.

Chimwe nechimwe pane pane rine kopi yeshizha rese uye mabheji akaparadzana anogona kushandiswa pane mumwechete kana pamwe pamwe kuti akubvumire kuona mitsara yakasiyana-siyana nemadzamu e data panguva imwe chete.

Muenzaniso: Kuparadzanisa Izvo Zvose Zvakananga uye Zvimwe

Matanho ari pasi apa anokwanisa kuparadzanisa yeExcel skrini mbiri nechepamusoro uye achitaridzika achishandisa chiparadzi cheSplit.

Kuwedzera Data

Kunyange zvazvo deta isingadi kuvepo nokuda kwezvakagadzirwa zvitsva kuti zvibate, zvinoita kuti zvive nyore kunzwisisa kuti zvinyorwa izvi zvinoshanda sei kana pepa remashandi rine data richishandiswa.

1. Vhura pepa remashandi rine rine zvakakwana deta kana kuwedzera mitsara yakawanda ye data - yakadai se data yakaratidzwa mumufananidzo uri pamusoro - kune pepa pepaji.
2. Yeuka iwe unogona kushandisa gadziriro yekuzadza kuti uzadze mazuva evhiki uye sequential column columnings seSample1, Sample2 nezvimwewo.

Kusvetura Chivara muIchina

1. Dzvanya paZviona tab yebhoni.
2. Dzvanya paItaly icon kuti uende pane chidimbu chepikicha.
3. Zvose zviviri zvitsvene uye zvakananga zvakaparadzanisa mabhagwa zvinofanira kuonekwa pakati pebasa.
4. Muchikamu chimwe nechimwe chezvinyorwa zvina zvinokonzerwa nemapapanho akaparadzana anofanira kunge ari kopi yeshizha.
5. Panofanirawo kuva nemipumburu miviri yakaderera kurutivi rworudyi rwekona uye miviri miviri yepamusoro yepumburu iri pasi pekona.
6. Shandisai mipumburu kuti mupoteredze mumagetsi mana.
7. Kugadzirisa mahwendefa akaparadzana nekusvotora pavari nekuvakuvadza ne mouse.

Kusvetura Chivara muZviri

Kuti kuderedze nhamba yezvikwereti kune zviviri, dhonza imwe yemapapiro maviri akaparadzaniswa kusvika kumusoro kana kurudyi kwekona.

Semuenzaniso, kuitira kuti skrini iparadzaniswe nechokuita, dhonzai vertical split bar kusvika kure kurudyi kana kuruboshwe kuruboshwe rwebasa, uchisiya bhora rakananga kuparadzanisa vhizha.

Kubvisa Split Screens

Kubvisa zvese zvakaparadzaniswa:

• Dzvanya paGona> Guritsai kuti mutsauri wechirongwa chepakati zvibve;

kana

• Dragisa mabhiji maviri akaparadzana kumativi echokrini; pamwe nemapuranga maviri mune izvi, chidimbu chinoparadzaniswa pamabhoni chakavharwa.

Ita Zvekare Zvekare Nebhokisi Rokuparadzanisa

Kusvetura Chivharo Nebhokisi Rokuparadzanisa

Sezvambotaurwa pamusoro, bhokisi rakapatsanurwa rakabviswa kubva ku Excel kutanga neEexcel 2013.

Muenzaniso wekushandisa bhokisi rakaparadzaniswa rinowanikwa pasi apa kune avo vanoshandisa Excel 2010 kana 2007 vanoda kushandisa sarudzo.

Muenzaniso: Kupatsanura Zviratidzo Nebhokisi reSplit

Sezvo zvinogona kuonekwa mumufananidzo uri pamusoro, tichaparadzanisa Excel skirindiro nekushandisa bhokisi rinoparadzaniswa riri pamusoro pepaburiro.

Bhokisi rakaderera rakaparadzaniswa riri muzasi kwekona yekodzero yeExcel screen, pakati pezvinyorwa zvitsvene uye zvisinganzwisisiki.

Kushandisa bhokisi rakaparadzaniswa panzvimbo yekupatsanurwa kwekutsvaga iri pasi peBook View kunokubvumira kuparadzanisa skrini mune rumwe rutivi chete - ndizvo zvinoshandiswa nevashandi vakawanda.

Kuwedzera Data

Kunyange zvazvo deta isingadi kuvepo nokuda kwezvakagadzirwa zvitsva kuti zvibate, zvinoita kuti zvive nyore kunzwisisa kuti zvinyorwa izvi zvinoshanda sei kana pepa remashandi rine data richishandiswa.

1. Vhura pepa remashandi rine rine zvakakwana deta kana kuwedzera mitsara yakawanda ye data - yakadai se data inowanikwa mumufananidzo uri pamusoro - kumushandi webasa
2. Yeuka iwe unogona kushandisa gadziriro yekuzadza kuti uzadze mazuva evhiki uye sequential column columnings seSample1, Sample2, nezvimwe.

Kusvetura Chirwere Zvakakwana

1. Isai pointer yeguru pamusoro pebhokisi rinoparadzaniswa pamusoro pebhuku repumburu rinoratidzika sezvinoratidzwa mumufananidzo uri pamusoro.
2. Mushonga weganda uchashandura kune museve wakaita mutsvuku kana iwe uri pamusoro pebhokisi rinoparadzaniswa.
3. Kana iyo pointer yegunha ichichinja, chovha uye ubatisise bhodhi reboshwe yemutsara .
4. Mutsara wakajeka unotaridzika unofanirwa kuoneka pamusoro pemutsara mumwe webasa.
5. Drags pointer mouse pasi.
6. Rima rakasvibirira rwonzi rinofanira kutevera mutsara we mouse.
7. Apo iyo pointer yepiguru iri pasi pemutsara wemakoronga mahedheni mubasa rekushandura kushidzira bhokeri yemakona.
8. A horizontal split bar inofanira kuwanikwa mune pepa rekushandira apo bhodhi rekona rakabudiswa.
9. Pamusoro uye pasi pemubhedha wekupatsanurwa unofanira kuva ma kopi maviri ebheji rekushanda.
10. Panofanirawo kuva nemipumburu miviri yakananga kurutivi rworudyi rwekona.
11. Shandisai mipumburu miviri yekuisa deta kuitira kuti zvinyorwa zvinyorwa zvionekwe pamusoro pebhari yakapatsanurwa pamwe nezvose zviri pasi apa.
12. Nzvimbo yebhedha yepakati inogona kuchinjwa kazhinji sezvainodiwa.

Kubvisa Split Screens

Iwe une zvingasarudzwa zviviri zvekubvisa zvinyorwa zvepakati:

1. Dzvanya pabhokisi rinoparadzaniswa kuruoko rworudyi rwekona uye rudedze kumashure kwebasa rekushanda.
2. Dzvanya paZviona> Kuparadzanisa icon kuti uvhare chikamu chepikicha chepakati.