I-Excel Fill Handle

Kopisha idatha, ifomu, ukufometha nokuningi

Isibambo sokugcwalisa siyi-multipurpose, encane encane yamachashazi noma isikwele ekhoneni elingezansi elingakwesokudla leseli elisebenzayo elingakusindisa isikhathi nemizamo uma lisetshenziselwa ukukopisha okuqukethwe komunye oyedwa noma amanye amangqamuzana kumaseli aseduze ekhasini lokusebenzela .

Ukusetshenziswa kwalo kuhlanganisa:

• Ukukopisha idatha nokufometha
• Ukukopisha amafomula
• Ukugcwalisa amaseli anenombolo yezinombolo, njengezinqayizivele noma izinombolo
• Ukwengeza izinsuku zeviki noma inyanga emakhasini okusebenza
• Ukwengeza uhlu lwendabuko lwedatha evame ukusetshenziswa, njengamagama omnyango noma izihloko zokubika, ekhasini lokusebenzela

Ukusebenza Isandla Sokugcwalisa

Isibambo sokugcwalisa sisebenza ngokuhlanganyela negundane. Ukuyisebenzisa:

1. Qinisekisa iseli (ama) aqukethe idatha ezokopishwa noma, uma kwenzeka uchungechunge, lwandisiwe.
2. Beka isikhombisi segundane phezu kwesibambo sokugcwalisa-isicathulo sishintsha kusignali encane yomnyama ( + ).
3. Cindezela bese ubamba inkinobho yesinxele segundane.
4. Hudula isibambo sokugcwalisa esitokisini (s) sokuphela.

Ukukopisha Idatha Ngaphandle kokufometha

Uma idatha ikopishwa ngesibambo sokugcwalisa, ngokuzenzakalelayo noma yikuphi ukufometha okusetshenziselwa idatha, njengokungathi imali, isibindi noma imicikilisho, noma izinguquko zesigcawu noma umbala wefonti, zikopishwa kanye.

Ukuze ukopishe idatha ngaphandle kokukopisha ukufometha, ngemuva kokukopisha idatha ngesibambo sokugcwalisa, i-Excel ibonisa inkinobho ye- Auto Fill Options ngezansi futhi ngakwesokudla kwamaseli asanda kugcwaliswa.

Ukuchofoza kule nkinobho kuvula uhlu lwezinketho ezifaka:

• Kopisha amaseli
• Gcwalisa ukufometha kuphela
• Gcwalisa ngaphandle kokufometha

Ukuchofoza Kugcwalisa ngaphandle kokufometha kuzokopisha idatha ngesibambo sokugcwalisa kodwa hhayi ukufometha komthombo.

Isibonelo

1. Faka inombolo efomethiwe-efana ne- $ 45.98 -yi- cell A1 yephepha lokusebenzela.
2. Chofoza ku-cell A1 futhi ukuze wenze iseli esebenzayo.
3. Beka isikhombisi segundane phezu kwesibambo sokugcwalisa (encane encane yamachashazi ekhoneni elingezansi elingakwesokudla leseli A1).
4. I-pointer yegundane izoguqula esigneni encane yomnyama plus ( + ) uma unayo phezu kwesibambo sokugcwalisa.
5. Uma i-pointer yegundane ishintshela uphawu olulodwa, chofoza bese ubamba inkinobho yegundane.
6. Hudula isibambo sokugcwalisa esitokisini se-A4 ukukopisha inombolo engu-$ 45.98 nokufometha kwamaseli A2, A3, ne-A4.
7. Amaseli A1 kuya ku-A4 kufanele manje aqukethe inombolo efomethiwe $ 45.98.

Ukukopisha amafomula

Amafomu okukopishwayo usebenzisa isibambo sokugcwalisa uzovuselela ukusebenzisa idatha endaweni yawo entsha uma edalwe besebenzisa izinkomba zocingo.

Izinkomba zezigcawu ziyikholomu yekholomu nenombolo yomugqa weseli lapho idatha esetshenziselwa ifomula itholakala, njenge-A1 noma i-D23.

Emfanekisweni ngenhla, iseli H1 liqukethe ifomula enezela ndawonye izinombolo kumaseli amabili ngakwesobunxele.

Esikhundleni sokungena izinombolo zangempela kufomula ku-H1 ukwenza le fomula,

= 11 + 21

izingqikithi zeseli zisetshenziselwa esikhundleni futhi ifomula iba:

= F1 + G1

Kuzo zombili amafomula, impendulo ku-cell H1 yilezi: 32, kodwa ifomula yesibili, ngoba idalwe ngokusebenzisa izikhombisi zeselula ingakopishwa ngokusebenzisa isibambo sokugcwalisa kwamaseli H2 no-H3 futhi iyonikeza umphumela ofanele wedatha kulabo imigqa.

Isibonelo

Lesi sibonelo sisebenzisa izingqikithi zeseli emafomulini, ngakho-ke zonke izikhombisi zeseli kwifomula ezikopishiwe zizobuyekezwa ukuze zibonise indawo yazo entsha.

1. Engeza idatha ebonwe esithombeni ngenhla kumaseli F1 kuya ku-G3 kushidi lokusebenzela.
2. Chofoza kuseli H1.
3. Thayipha ifomu: = F1 + G1 esitokisini G1 bese ucindezela ukhiye we-Enter ekhibhodi.
4. Impendulo engu-32 kufanele ivele kuseli H1 (11 + 21).
5. Chofoza kuseli H1 futhi ukuze wenze iseli esebenzayo.
6. Beka isikhombisi segundane phezu kwesibambo sokugcwalisa (encane encane yamachashazi ekhoneni elingezansi elingakwesokudla seli cell H1).
7. I-pointer yegundane izoshintshela kusignali encane yomnyama ( + ) uma unayo phezu kwesibambo sokugcwalisa ..
8. Uma i-pointer yegundane ishintshela uphawu olulodwa, chofoza bese ubamba inkinobho yegundane lesokunxele.
9. Hudula isibambo sokugcwalisa esitokisini H3 ukukopisha ifomu kumaseli H2 no-H3.
10. Amaseli H2 noH3 kufanele abe nezinombolo 72 no-121 ngokulandelana - imiphumela yamafomula akopishwe kulawo maseli.
11. Uma uchofoza ku-cell H2 ifomula = F2 + G2 ingabonakala kubha yefomula ngaphezulu kwephepha lokusebenzela.
12. Uma uchofoza kumakhalekhukhwini H3 ifomula = F3 + G3 ingabonakala kubha yefomula.

Ukwengeza uchungechunge lwezinombolo kumaseli

Uma i-Excel iqaphela okuqukethwe kweseli njengengxenye yochungechunge, izothumela ngokuzenzakalela amanye amaseli akhethiwe ngezinto ezilandelayo kulolu chungechunge.

Ukuze wenze kanjalo, udinga ukungena idatha eyanele ukukhombisa i-Excel iphethini, njengokubala ngamabili, ofuna ukuyisebenzisa.

Uma usuwenzile lokhu, isibambo sokugcwalisa singasetshenziswa ukuphinda uchungechunge njalo uma kudingeka.

Isibonelo

1. Thayipha inombolo 2 kuseli D1 bese ucindezela ukhiye wokungena kwikhibhodi.
2. Thayipha inombolo 4 kuseli D2 bese ucindezela u-Enter.
3. Khetha amaseli D1 no-D2 ukuwagqamisa.
4. Chofoza bese ubamba isikhombisi segundane kumbambo wokugcwalisa ekhoneni elingezansi elingakwesokudla se-cell D2.
5. Hudula isibambo sokugcwalisa phansi kuseli D6.
6. Amaseli D1 kuya ku-D6 kufanele abe nezinombolo: 2, 4, 6, 8, 10, 12.

Ukungeza Izinsuku Zeviki

I-Excel inezinhlu zangaphambi kokuhlelwa kwamagama, izinsuku zeviki nezinyanga zonyaka, ezingangeniswa ephepheni lokusebenzela usebenzisa isibambo sokugcwalisa.

Ukuze ungeze amagama kushidi lokusebenzela, udinga nje ukutshela i-Excel ukuthi uluphi uhlu ofuna ukulifakelwa futhi lokhu kwenziwa ngokuthayipha igama lokuqala ohlwini.

Ukwengeza izinsuku zesonto ngokwesibonelo,

1. Thayipha ngeSonto int o cell A1.
2. Cindezela ukhiye wokungena kwikhibhodi.
3. Chofoza kuselili-A1 futhi ukuze lenze iseli elisebenzayo.
4. Beka isikhombisi segundane phezu kwesibambo sokugcwalisa ekhoneni elingezansi elingakwesokudla seligcini elisebenzayo.
5. I-pointer yegundane izoguqula esigneni encane yomnyama plus ( + ) uma unayo phezu kwesibambo sokugcwalisa.
6. Uma i-pointer yegundane ishintshela uphawu olulodwa, chofoza bese ubamba inkinobho yegundane.
7. Hudula isibambo sokugcwalisa esitokisini G1 ukuze ugcwalise ngokuzenzakalela izinsuku zeviki kusukela ngoMsombuluko kuya kuMgqibelo.

I-Excel iqukethe uhlu lwangaphambi kokusetha kwamafomu amafomu ngezinsuku zeviki ezifana ne- Sun , Mon , njll kanye namagama amabili aphelele nezinyanga ezincane -Januwari , Febhuwari, Mashi noJan, Feb, Mar, okungenzeka kube wengeze ekhasini lokusebenzela usebenzisa izinyathelo ezibalwe ngenhla.

Ukwengeza Uhlu Lwezifiso Ku-Handle Yokugcwalisa

I-Excel ibuye ikuvumele ukuthi ungeze uhlu lwakho lwamagama njengamagama omnyango noma izihloko zephepha lokusebenzela ukuze usebenzise nesibambo sokugcwalisa. Uhlu lungafakwa esibambisini sokugcwalisa noma ngokuthayipha ngamagama ngesandla noma ngokuwakopisha ohlwini olukhona ekhasini lokusebenzela.

Ukuthayipha Ukugcwalisa Okuzenzakalelayo Kokuzenzekelayo

1. Chofoza kuthebhu yefayela ye-ribbon (chofoza i-Excel 2007 ku-Inkinobho ye-Office).
2. Chofoza Izinketho zokukhipha ibhokisi lengxoxo ye- Excel Izinketho.
3. Chofoza ithebhu Okuthuthukisiwe (i- Excel 2007 - ithebhu ethandwayo) ngakwesokunxele kwesokunxele.
4. Skrolela esigabeni esiphezulu sohlu lokukhethwa kukho ngakwesokudla kwesokudla (Isigaba se- Excel 2007 - Top ongakhetha phezulu phezulu kwepaneli ).
5. Chofoza u- Hlela inkinobho Yohlu Lokwenza Okungokwezifiso ngakwesokudla ngakwesokudla ukuze uvule ibhokisi lengxoxo yezintandokazi.
6. Thayipha uhlu olusha efasiteleni lokufaka kuhlu .
7. Chofoza u-Engeza ukuze ungeze uhlu olusha kuWindows Lists iwindi ngakwesokunxele kwesokunxele.
8. Chofoza OK ngokuphindwe kabili ukuvala zonke amabhokisi ebhokisi bese ubuyela ekhasini lokusebenzela.
9. Hlola uhlu olusha ngokuthayipha igama lokuqala ohlwini bese usebenzisa isibambo sokugcwalisa ukwengeza amanye amagama ekhasini lokusebenzela.

Ukungenisa Uhlu Lokugcwalisa Okuzenzakalelayo Okuzenzakalelayo Kusuka Esikhatsini Sakho Samaspredishithi

1. Qinisekisa ububanzi bamaseli ekhasini lokusebenzela eliqukethe izakhi zohlu, njenge-A1 kuya ku-A5.
2. Landela izinyathelo 1 kuya ku-5 ngenhla ukuze uvule ibhokisi lengxoxo yezintandokazi.
3. Ububanzi bamaseli akhethiwe ngaphambilini kumele bube khona ngesimo sezingqikithi zeseli eziphelele , njenge $ A $ 1: $ A $ 5, ohlwini lokungenisa kusuka kwamabhokisi wamaseli phansi kwebhokisi lebhokisi.
4. Chofoza inkinobho yokungenisa .
5. Uhlu olusha lokugcwalisa okuzenzakalelayo luvela efasiteleni lezintandokazi ezijwayelekile.
6. Chofoza OK ngokuphindwe kabili ukuvala zonke amabhokisi ebhokisi bese ubuyela ekhasini lokusebenzela.
7. Hlola uhlu olusha ngokuthayipha igama lokuqala ohlwini bese usebenzisa isibambo sokugcwalisa ukwengeza amanye amagama ekhasini lokusebenzela.