Kanjani ukwenza ama-autocouplers ku-Excel: Imiyalo enemininingwane

Bambalwa abazothanda isikhathi eside futhi bangena ngohlobo olufanayo noma olufanayo etafuleni. Lokhu kungumsebenzi onzima impela, uthatha isikhathi esikhulu sesikhathi. Uhlelo lwe-Excel lunamandla okusebenzisa ukungena kwemininingwane enjalo. Lokhu kuhlinzekela ukusebenza kwama-autocillry amaseli. Ake sibheke ukuthi isebenza kanjani.

Ukusebenza kwe-autofill ku-Excel

I-autocomplete ku-Microsoft Excel yenziwa kusetshenziswa umaki okhethekile wokugcwalisa. Ukuze kunxephelwe leli thuluzi, udinga ukuletha isikhombisi emaphethelweni aphansi kwesokudla kwanoma yisiphi iseli. Kuzoba nesiphambano esincane esimnyama. Lona umaka wokugcwalisa. Udinga nje ukubamba inkinobho yegundane kwesobunxele bese udonsa ishidi liye kwelinye phezulu lapho ufuna ukugcwalisa khona amaseli.

Indlela amaseli azoxoshwa ngayo vele ancike ohlotsheni lwedatha esengqangeni yangempela. Isibonelo, uma kunombhalo ojwayelekile ngesimo samagama, lapho udweba usebenzisa umaki wokugcwalisa, ukopishelwa kwamanye amaseli eshidi.

Ukuvuselelwa kwe-auto kwezinombolo zamaseli

Imvamisa i-AutoFill isetshenziselwa ukufaka amanani amakhulu amanani alandelayo alandela ngokulandelana. Isibonelo, esitokisini esithile kukhona inombolo 1, futhi sidinga ukubalwa amaseli avela ku-1 kuye ku-100.

1. Yenza kusebenze umaki wokugcwalisa bese uwasebenzisa phansi ngenombolo edingekayo yamaseli.



2. Kepha, njengoba sibona, yiyunithi kuphela elalikopishwa kuwo wonke amaseli. Chofoza isithonjana, esivela ezansi ngakwesobunxele sendawo egcwalisiwe futhi sibizwa ngokuthi "amapharamitha okugcwalisa ngokuzenzakalela".



3. Uhlu oluvula, setha i-switch to the "Gcwalisa".

Njengoba sibona, emva kwalokho, lonke uhla oludingekayo lwalugcwele izinombolo ngokulandelana.

Kepha kungenziwa kube lula kakhulu. Ngeke udinge ukubiza amapharamitha asebenza ngokuzenzakalela. Ukuze wenze lokhu, lapho umdwebo wokuphindaphinda wehla, ngaphandle kwenkinobho yegundane kwesobunxele, udinga ukubamba inkinobho ye-CTRL kwikhibhodi. Ngemuva kwalokho, ukugcwaliswa kwamaseli ngokuhlelekile kwenzeka ngokushesha.

Kukhona nendlela yokwenza ama-autocopter ambalwa ukuthuthuka.

1. Singenisa amaseli angomakhelwane izinombolo ezimbili zokuqala zokuthuthuka.



2. Siyazigqagqana. Kusetshenziswa umaki wokugcwalisa sethula idatha kwamanye amaseli.



3. Njengoba sibona, inani elingaguquki lezinombolo lenziwa ngesinyathelo esinikeziwe.

Ithuluzi "Gcwalisa"

Uhlelo lwe-Excel luphinde lube nethuluzi elihlukile elibizwa nge- "Gcwalisa". Itholakala kwiribhoni kuthebhu "Yasekhaya" kubha yamathuluzi yokuhlela.

1. Sethula imininingwane kunoma yisiphi iseli, bese siyikhetha futhi uhla lwamaseli azogcwalisa.



2. Chofoza inkinobho ethi "Gcwalisa". Uhlu oluvelayo, khetha indlela lapho amaseli kufanele agcwaliswe khona.



3. Njengoba sibona, ngemuva kwalezi zenzo, imininingwane evela kwiseli elilodwa yakopishwa kubo bonke abanye.

Ngaleli thuluzi, ungagcwalisa futhi amaseli athuthukile.

1. Sifaka inombolo esitokisini futhi sabela ububanzi bamaseli azogcwaliswa ngemininingwane. Sichofoza inkinobho ethi "Gcwalisa", bese kuluhlu oluvelayo, khetha into ethi "Progression".



2. Kuvulwa iwindi lokusetha. Lapha udinga ukwenza inani elithile lokukhohlisa:
   • Khetha indawo yokuqhubekela phambili (kumakholomu noma ngemigqa);
   • Uhlobo (i-geometric, izibalo, izinsuku, autofill);
   • Setha isinyathelo (ngokuzenzakalela yi-1);
   • Setha inani lomkhawulo (ipharamitha yokuzikhethela).

   Ngaphezu kwalokho, kwezinye izikhathi, amayunithi asethiwe.

   Lapho zonke izilungiselelo zenziwe, chofoza inkinobho ethi "Kulungile".



3. Njengoba ubona, emva kwalokho, lonke uhla oluzinikezele lwamaseli lugcwele ngokuya ngemithetho yokuqhubekela phambili oyifakile.

Amafomula we-Autofill

Enye yamathuluzi amakhulu ama-Excel amafomula. Uma kunenombolo enkulu etafuleni lamafomula afanayo, ungasebenzisa futhi umsebenzi ophelele we-auto. Umnyombo awushintshi. Kuyadingeka ukukopisha ifomula kwamanye amaseli ngendlela efanayo. Ngasikhathi sinye, uma ifomula iqukethe ama-reference kwamanye amaseli, khona-ke ngokuzenzakalelayo lapho ukukopisha ngale ndlela izixhumanisi ziguquka ngokuya ngomgomo wokubuyisana. Ngakho-ke, izixhumanisi ezinjalo zibizwa ngesihlobo.

Uma ufuna ukulungiswa ngokuzenzakalelayo nekheli, khona-ke udinga ukubeka uphawu lwedola phambi kwezixhumanisi zemigqa namakholomu. Izixhumanisi ezinjalo zibizwa ngokuphelele. Ngemuva kwalokho, inqubo ejwayelekile ye-autofill yenziwa kusetshenziswa umaki wokugcwalisa. Kuwo wonke amaseli agcwaliswe ngale ndlela, ifomula izobe ingashintshi ngokuphelele.

Isifundo: Izixhumanisi eziphelele nezihlobo ze-Excel

Autocomplete ngamanye amanani

Ngaphezu kwalokho, uhlelo lwe-Excel luhlinzeka ngokuzenzakalela namanye amanani ngokulandelana. Isibonelo, uma ufaka usuku oluthile, bese usebenzisa umaki wokugcwalisa, khetha amanye amaseli, khona-ke lonke ibanga elikhethiwe lizogcwaliswa ngezinsuku ngokulandelana okuqinile.

Ngendlela efanayo, kungenzeka ukwenza ukugcwalisa ngokuzenzakalela izinsuku zeviki (ngoMsombuluko, uLwesibili, uLwesithathu ...) noma yizinyanga (ngoJanuwari, ngoFebhuwari, Mashi ...).

Ngaphezu kwalokho, uma kukhona noma iyiphi idijithi embhalweni, khona-ke i-Excel iyakubona. Lapho usebenzisa umaki wokugcwalisa, kuzoba nokopisha umbhalo ngoshintsho kulesi sigameko. Isibonelo, uma uqopha inkulumo ethi "4 Case" esitokisini, bese kwamanye amaseli agcwele umaki wokugcwaliswa, leli gama lizoguqulwa libe "izindlu ezi-5", "6 Hull", "

Ukungeza uhlu lwakho

Amandla wokusebenza kwe-autofill ku-Excel awakhawulelwe kuma-algorithms athile noma uhlu lwangaphambi kokufakwa, njengoku, ngokwesibonelo, izinsuku zeviki. Uma ufisa, umsebenzisi angangeza uhlu lomuntu siqu kulolu hlelo. Ngemuva kwalokho, lapho ubhalela iseli yanoma yiliphi igama kusuka ezintweni ezisezinhlathini, ngemuva kokusebenzisa umaki wokugcwalisa, lonke uhla olukhethiwe lwamaseli luzogcwaliswa ngalolu hlu. Ukuze ungeze uhlu lwakho, udinga ukwenza ukulandelana kwezenzo ezinjalo.

1. Senza ukuguqukela kuthebhu "yefayela".



2. Iya engxenyeni ethi "Parameters".



3. Okulandelayo, sithuthela esigatshaneni esithi "Advanced".



4. In the Izilungiselelo "Jikelele" Engxenyeni ephakathi kwewindi esichofozayo ku- "Shintsha Uhlu ..." Inkinobho.



5. Uhlu lwezinhlu luvuleka. Engxenyeni yesobunxele kukhona uhlu oluvele lukhona. Ukuze ungeze uhlu olusha, bhalela amagama afiselekayo kunkambu ye- "Uhlu Elements". Into ngayinye kufanele iqale ngomugqa omusha. Ngemuva kokuthi wonke amagama aqoshwa, chofoza inkinobho ethi "Faka".



6. Ngemuva kwalokho, iwindi lezinhlu livalelisa, futhi lapho lilivula, umsebenzisi uzokwazi ukubona izinto ezingezelele ewindini lezinhlu ezisebenzayo.



7. Manje, ngemuva kokwenza igama kunoma yisiphi iseli seshidi, elingenye yezinto zohlu olungeziwe, futhi lusebenzise umaki ogcwalisiwe, amaseli akhethiwe azogcwaliswa ngezinhlamvu ezivela ohlwini oluhambisanayo.

Njengoba ubona, i-Autofill in Pevule iyithuluzi eliwusizo kakhulu futhi elilungele elikuvumela ukuthi ugcine isikhathi ngokungeza uhlu oluphindaphindekayo lwedatha, njll. Inzuzo yaleli thuluzi ukuthi iyabonakala. Ungenza uhlu olusha noma ushintshe abadala. Ngaphezu kwalokho, ngosizo lwe-autofill, kungenzeka ukugcwalisa ngokushesha amaseli ngezinhlobo ezahlukahlukene zokuthuthuka kwezibalo.