Excel Fill Handle

Kopota Data, Fomu, Kufambisa uye Zvimwe

Chigadziro chokuzadza ndechekuti pane zvakawanda, zviduku zvakasvibirira kana ruvara rwepamusoro kwekona rezasi kwekamuri rinoshandiswa rinogona kukuchengetedza nguva nekuedza apo rinoshandiswa kukopa zviri mukati rimwechete kana kuti mamwe masero kumasero ari pedyo mune pepa .

Zvinoshandiswa zvinosanganisira:

• Kushandisa deta uye kukanganisa
• Kupikira mafomu
• Kuzadza masero ane nhamba dzakatevedzana, dzakadai sedzakanaka kana kunyange nhamba
• Kuwedzera mazuva evhiki kana mwedzi mazita kumushandi webasa
• Kuwedzera tsika yemhando yedhiyabhorosi inowanzoshandiswa, yakadai semazita emapazi kana zvinyorwa zvehupoti, kune pepa pepaji

Kushanda Nzvimbo Yokuzadza

Chibato chinogadzirisa chinoshanda pamwe chete nemushonga. Kuti uishandise:

1. Simbisai sero (s) ine data inogona kunyorwa kana, pane imwe nyaya, yakawedzerwa.
2. Isai pointer mouse pamusoro pekuzadza-iyo pointer inoshanduka kune duku duku pamwe chete nechiratidzo ( + ).
3. Dhinda uye ubatisise ibhokisi reboshwe.
4. Dragza gadziriro yekuzadza kunzvimbo yekuenda (s).

Kukopa Dhausi Pasina Kuchinja

Apo dheta inonyorwa nehuwandu hwekugadzirisa, nekutadza chero upi hwekugadzirisa hunoshandiswa kune data, zvakadai semari, bold kana kuti itariki, kana sero kana faira ruvara ruvara, zvinonyorwawo zvakare.

Kukopa deta pasina kukopa kuumbwa kwemashoko, mushure mekunyora deta nemubati wetaza, Excel inoratidza Bhuku reAngja Fill Options riri pasi uye kune kodzero dzemasero matsva akazara.

Kushandura pakona iyi kunotanga urongwa hwezvasarudzo zvinosanganisira:

• Kopira masero
• Zadza mafomatiro chete
• Dzadza pasina maitiro

Kushandura Kuzadza kunze kwekugadzira mafaira kuchakopa deta nehuwandu hwekugadzirisa asi kwete fomu yekusika.

Muenzaniso

1. Pinda nhamba yakagadziridzwa-yakadai se $ 45.98-iri sero A1 yemushandi webasa.
2. Dzvanya pachitokisi A1 zvakare kuti uite sero rinoshanda.
3. Isai pointer yeganda pamusoro pemubati wadzaza (maduku mutsvuku muzasi kwekona yekona yekamuri A1).
4. Purojekiti yeganda ichachinja kune imwe duku duku pamwe chete nechiratidzo ( + ) paunenge uine chikwata chokuzadza.
5. Apo iyo pointer yegunha inoshanduka kune chiratidzo chinopfuura, diya uye ubatisise bhodhi.
6. Dragza gadziriro yekuzadza kusero cheA4 kuti ukope nhamba ye $ 45.98 uye kuumbwa kumasero A2, A3, neA4.
7. Masero A1 kusvika kuA4 anofanira kunge iye zvino ane nhamba yakarongwa $ 45.98.

Copying Formulas

Zvinyorwa zviriko zvichishandisa kushandiswa kugadzirisa kuchagadzirisa kushandiswa kwedhesi munzvimbo yavo itsva kana zvichishandiswa uchishandisa masero ezvinyorwa.

Maferensi emapoka ndiyo tsamba yekorodhe uye mutsara nhamba yesero iyo data inoshandiswa mumutsara iripo, yakadai seA1 kana D23.

Mumufananidzo wepamusoro, sero H1 rine chirevo chinowedzera pamwe nhamba mumasero maviri kuruboshwe.

Panzvimbo pokupinda nhamba chaiyo muyamuro muH1 kuti uite iyi fomu,

= 11 + 21

sero rinoshandiswa rinoshandiswa pane nzvimbo uye chirevo chinova:

= F1 + G1

Mune mibvunzo miviri, mhinduro muchitokisi H1 ndeyekuti: 32, asi yechipiri chimiro, nokuti yakashandiswa kushandiswa kwekeroti inogona kukopirwa kushandiswa kugadzirisa masero H2 neH3 uye ichapa mhinduro yakarurama ye data kune iyo rows.

Muenzaniso

Uyu muenzaniso unoshandisa zvikamu zvinyorwa mune zvigadziro, saka zvose zvinyorwa zvemasero mufomu iri kukodhwa ichavandudza kuratidza nzvimbo yavo itsva.

1. Wedzera deta inowanikwa mumufananidzo uri kumusoro pamusoro pemasero F1 kusvika kuG3 mune pepa rekushanda.
2. Dzvanya pane cell H1.
3. Tora fomu: = F1 + G1 muchitsime G1 uye shandisai Enter key pane keyboard.
4. Mhinduro 32 inofanira kuonekwa muchitokisi H1 (11 + 21).
5. Dzvanya pane cell H1 zvakare kuti uite iyo inoshanda masero.
6. Isai pointer yeganda pamusoro pemubati wadzaza (maduku mutsvuku mumuganhu wezasi wekona H1).
7. Mushonga weganda uchashandura kune imwe duku duku pamwe chete nechiratidzo ( + ) paunenge uine chikwata chokuzadza.
8. Apo iyo pointer yegunha inoshanduka kune imwe chiratidzo, dika uye ubatisise ibumini rekona yemakona.
9. Dragza gadziriro yekuzadza kune cell H3 kunyorera fomu kumasero H2 neH3.
10. Mitsara H2 neH3 inofanira kunge ine nhamba 72 uye 121 zvichienderana-mhinduro yezvinyorwa zvakakonzerwa kune masero.
11. Kana iwe ukatora pane cell H2 iyo formula = F2 + G2 inogona kuonekwa mubhadha yepamusoro pane pepa pepaji.
12. Kana iwe ukatora pane cell H3 iyo fomu = F3 + G3 inogona kuonekwa mubhairi yebasa.

Kuwedzera Nyaya yeNhamba kumatare

Kana Excel ichiona seni iri mukati sechikamu chezvitevedzana, ichaita motokari izere mamwe masero akasarudzwa nezvimwe zvinhu zvinotevera mumutsara.

Kuti uite kudaro, unofanirwa kuisa data yakakwana yekuratidza Excel purogiramu, yakadai sekuverenga nemaviri, waunoda kushandisa.

Kana uchinge waita izvi, chigadziro chinogona kushandiswa chinogona kushandiswa kudzokorora nhepfenyuro kakawanda sezvinodiwa.

Muenzaniso

1. Tora iyo nhamba 2 muchitoro D1 uye tumira kuIkiyi pane keyboard.
2. Tora iyo nhamba 4 mu cell D2 uye dikai Enter.
3. Sarudza masero D1 uye D2 kuti uonekwe .
4. Dzvanya uye ubatisise pointer yeganda pane gadziriro yekuzadza muzasi kwekona rekona rejeri D2.
5. Dragza chigadziro chozadza pasi pane cell D6.
6. Masero D1 kusvika D6 anofanira kunge ane nhamba: 2, 4, 6, 8, 10, 12.

Kuwedzera Mazuva evhiki

Excel ine mazita ekutanga mazita, mazuva evhiki uye mwedzi yegore, iyo inogona kuwedzerwa pane pepa rekushandisa uchishanda.

Kuti uwedzere mazita pane pepa rekushanda, iwe unongoda kuudza Excel iyo urongwa waunoda kuwedzerwa uye izvi zvinoitwa nokunyora zita rokutanga pane urongwa.

Kuwedzera mazuva evhiki kwemuenzaniso,

1. Tora Sunday int o cell A1.
2. Dhinda pikicha inopinda mubhokisi.
3. Dzvanya pachitokisi A1 zvakare kuti uite sero rinoshanda.
4. Isa iyo pointer yeguru pamusoro pemubati wadzaza muzasi kwekona yekona yebasa rinoshanda.
5. Purojekiti yeganda ichachinja kune imwe duku duku pamwe chete nechiratidzo ( + ) paunenge uine chikwata chokuzadza.
6. Apo iyo pointer yegunha inoshanduka kune chiratidzo chinopfuura, diya uye ubatisise bhodhi.
7. Dragza gadziriro yekuzadza kumusasa G1 kuti uwane kuzadza mazuva evhiki kubva Muvhuro kusvika Mugovera.

Excel iinewo chinyorwa chekutanga chinyorwa chemafomu mafupi kwemazuva evhiki seSain , Mon , nezvimwewo pamwe chete nemazita maviri azere uye maduku -January, February, March uye Jan, Feb, Mar izvo zvinogona kuva akawedzera pane pepa rekushandisa achishandisa matanho ari pamusoro apa.

Kuti Uwedzere Chirongwa Chetsika Kuzadza Chigadziro

Excel inokubvumirawo kuti uwedzere mazita ako emazita akadai semazita emapazi kana zvinyorwa zvebasa rekushandisa kushandiswa nemubati wakakwana. Runyora runogona kuwedzerwa pane kugadzirisa kana kunyora mumazita nemaoko kana kuainyora kubva kune yakarongwa urongwa mune pepa rekushanda.

Kunyora New Auto Kuzadza Nyora Zvawe

1. Dzvanya paDhiyabhorosi tabu rebhoni (Excel 2007 pfuurira pabhodhi yeHofisi).
2. Dzvanya Sarudzo yekuunza yeExcel Options dialog box .
3. Dzvanya Advanced Advanced tab ( Excel 2007 - Popular tab) muruboshwe-pane pane.
4. Tsvaga kuChechi Chikamu chesarudzo dzekutsvaga muhotera-pane pane ( Excel 2007 - Top options chikamu kumusoro kwepamusoro ).
5. Dzvanya pakatarisa Bhokisi Rokunyora Rakanaka muboshwe-kuruoko rworudyi kuti uzarure Bhuku Rokutumira Dhauriro.
6. Tora iyo itsva mutsamba muIndaneti yeIndaneti .
7. Dzvanya Add kuti uwedzere rutsva rutsva kuList Lists window mune kuruboshwe-pane pane.
8. Dzvanya OK pane kaviri kuti uvhare mabhokisi ose ebhokisi uye udzoke kubasa.
9. Edza rutsva rutsva nokunyora zita rokutanga mune urongwa uye shandisa chigadziro chokuzadza kuwedzera mamwe mazita kumushandi webasa.

Kuisa Tsamba Yokudzidzira Auto Auto Kubva MuSpreadsheet Yako

1. Simbisa mararamiro emasero mune pepa rekushanda rine zvinyorwa zvinyorwa, zvakadai seA1 kusvika kuA5.
2. Tevera matanho 1 kusvika ku-5 kumusoro kuti uzarure Custom List dialog box.
3. Mhando yemasero akarehwa kare inofanira kunge iripo nenzira yemhedziso yakakwana , zvakadai se $ A $ 1: $ A $ 5, muIndaneti Inotumira kubva kumasero ebhokisi pasi pebhokisi rebhokisi.
4. Dzvanya Bhokisi reIndaneti.
5. Iko Tsva Yekuzadza Kuzadza inowanikwa muDare reList Lists.
6. Dzvanya OK pane kaviri kuti uvhare mabhokisi ose ebhokisi uye udzoke kubasa.
7. Edza rutsva rutsva nokunyora zita rokutanga mune urongwa uye shandisa chigadziro chokuzadza kuwedzera mamwe mazita kumushandi webasa.