Maitiro ekuita autocouplers muExcel: Dzakadzama mirayiridzo

Vashoma vanofarira kureba uye monotonously pinda zvakafanana kana mhando imwecheteyo patafura. Iri ibasa rinonakidza kwazvo, kutora nguva yakakura. Chirongwa cheEkunyanyisa chine kugona kwekutora iyo yekupinda yedata yakadaro. Izvi zvinopa basa rekushanda kwe autocillry yemasero. Ngatione kuti zvinoshanda sei.

Kushanda kwe autofill mune excel

Autocomplete muMicrosoft Excel inoitwa uchishandisa yakakosha yekuzadza mucherechedzo. Kuti undinamire chishandiso ichi, iwe unofanirwa kuunza iyo yekukathora kune iyo yepazasi kurudyi kwemucheto chero sero. Pachave nediki diki dema. Uku ndiko chiratidzo chinozadza. Iwe unongoda kubata iyo kuruboshwe bhatani bhatani uye dhonza pepa kumusoro kune iyo yepamusoro kwaunoda kuzadza masero.

Iyo nzira masero ichave yakamiswa inotoenderana nemhando yedata iri muchitokisi chekutanga. Semuenzaniso, kana paine rugwaro rwakajairika muchimiro chemashoko, zvino kana paunenge uchishandisa mucherechedzo unozadza, unoteedzerwa kune mamwe masero epepa.

Auto Kuverengera Kwemasero Nhamba

Kazhinji kazhinji dendafill inoshandiswa kuisa gadziriro yakakura yenhamba inotevedzera zvakarongeka. Semuenzaniso, mune imwe sero pane nhamba 1, uye isu tinofanirwa kuverengera masero kubva ku1 kusvika ku100.

1. Ita kuti azere maka yekuzadza uye isa iyo pasi pane iyo inodiwa nhamba yemasero.



2. Asi, sezvatinoona, chikamu chete chakateedzerwa kumasero ese. Dzvanya pane iyo icon, iyo inobva pasi kuruboshwe kwenzvimbo yakapera uye inonzi "auto-kuzadza paramita".



3. Mune rondedzero inovhura, seta switch kune iyo "zadza" chinhu.

Sezvatinoona, mushure meizvozvo, iyo yese inodikanwa renji yakazadzwa nehuwandu kuitira.

Asi zvinogona kuitwa zviri nyore. Iwe hauzofaniri kudaidza autocomplete parameter. Kuti uite izvi, apo makafundisi anodzokorora ari pasi, ipapo kunze kwekuruboshwe bhatani bhatani, iwe unofanirwa kubata bhatani reCTRL pane iyo keyboard. Mushure meizvozvo, kuzadza kwemasero nenzira inoitika pakarepo.

Kune zvakare nzira yekuita autococopers nhamba yekufambira mberi.

1. Isu tinosuma mumasero emuvakidzani nhamba yekutanga mbiri yekufambira mberi.



2. Isu tinovaratidza. Uchishandisa maka anozadza isu tinosuma data kune mamwe masero.



3. Sezvatinoona, nhamba inoenderana yehuwandu yakagadzirwa neyenhanho yakapihwa.

Tool "Zadza"

Chirongwa cheEkupedzisira chine chimbo chakaparadzana chinonzi "zadza". Iyo iri pane ribbon mu "imba" tab mune yekugadzirisa toptbar.

1. Isu tinosuma iyo data kuchero sero, uye tobva tasarudza uye huwandu hwemasero ari kuzadza.



2. Dzvanya pane "zadza bhatani". Mune rondedzero inoonekwa, sarudza kutungamira uko masero anofanirwa kuzadzwa.



3. Sezvatinoona, mushure meizvi zviito, iyo data kubva kune imwe cell yakaiswa mune vamwe vese.

Nechishandiso ichi, iwe unogona zvakare kuzadza masero ekufambira mberi.

1. Isu tinopinda iyo nhamba muchitokisi uye tikagovanisa huwandu hwemasero ayo anozadzwa nedata. Isu tinodzvanya pane "zadza bhatani" uye mune rondedzero inoonekwa, sarudza "kufambira mberi" chinhu.



2. Iyo inofambira mberi setup windows inovhura. Pano iwe unofanirwa kuita huwandu hwenyaya:
   • Sarudza iyo nzvimbo yekufambira mberi (pamakoramu kana nemitsara);
   • Nyora (geometric, arithmetic, mazuva, autofill);
   • Gadzirisa nhanho (neDefault It 1);
   • Gadza iyo Limit kukosha (sarudzo yeparamende).

   Mukuwedzera, mune zvimwe zviitiko, zvikamu zvacho zvakagadzirirwa.

   Kana zvese zvirongwa zvikaitwa, tinya pane "OK" bhatani.



3. Sezvauri kuona, mushure meizvozvo, iyo yese yakazvitsaurira yemasero inozadzwa zvinoenderana nemitemo inofambira mberi yawakaisa.

Autofill Formulas

Imwe yeiyo main toles excel ndeye mafomula. Kana paine nhamba yakakura patafura yeiyo mafomula, iwe unogona zvakare kushandisa iyo auto-yakazara basa. Iyo yakakosha haina kuchinja. Izvo zvinodikanwa kutevedzera formula kune mamwe masero nenzira imwecheteyo. Panguva imwecheteyo, kana iyo formula ine mareferensi kune mamwe masero, saka nekumwe kana kutevedzera nenzira iyi iyo mafambiro anochinja zvichienderana neparamende. Naizvozvo, zvakadaro zvinongedzo zvinonzi hama.

Kana iwe uchida kuiswa otomatiki nekero, saka iwe unofanirwa kuisa chiratidzo chemadhora pamberi peganda remitsara nemakoramu. Zvinongedzo zvakadaro zvinonzi Mhedziso. Zvadaro, iyo yakajairika autofill maitiro anoitwa uchishandisa mucherechedzo unozadza. Mumasero ese akazadzwa nenzira iyi, formula ichave isina kuchinjika.

Chidzidzo: Mhedziso uye hukama hwehukama kuti ubude

Autocomplete nedzimwe kukosha

Mukuwedzera, chirongwa cheExcel chipi chinopa autofill nedzimwe tsika kuitira. Semuenzaniso, kana iwe ukapinda mune imwe zuva, uye wozoshandisa mucherechedzo unozadza, sarudza mamwe masero, ipapo renzande yakasarudzika ichazadzwa nemazuva ari mukuteedzana.

Saizvozvowo, zvinoita kuti motokari-ukaguta pamusoro pamazuva vhiki (Monday, Chipiri, Chitatu ...) kana mwedzi (January, February, March ...).

Uyezve, kana paine chero manhamba murugwaro, leccel anozviziva. Paunenge uchishandisa mucherechedzo unozadza, pachave nekukopana zvinyorwa nekushandurwa muchiitiko ichi. Semuenzaniso, kana ukanyora mazwi ekuti "4 kesi" muchitokisi, ipapo mune mamwe masero akazadzwa nemaka anozadza, zita iri richachinjwa kuva "dzimba dze" 5, "Hull", "7 kesi", nezvimwe.

Kuwedzera yako rondedzero

Iko kugona kweiyo autofill basa mukubuda pachena hakugumiri kune mamwe algorithms kana pre-yakaiswa zvinyorwa, senge, semuenzaniso, mazuva evhiki. Kana zvichidikanwa, mushandisi anogona kuwedzera rondedzero yako pachako kuchirongwa. Zvadaro, pavanenge vachinyora kuchitokisi chesero chero chinhu kubva pane izvo zviri mune rondedzero, mushure mekushandisa iyo yekuzadza mucherechedzo, iyo yese yakasarudzwa mhando yemasero ichazadzwa neiyi rondedzero. Kuti uwedzere runyorwa rwako, iwe unofanirwa kuita kutevedzana kwakadaro kwezviito.

1. Isu tinoita shanduko kune iyo "faira" tab.



2. Enda kune "parameter" chikamu.



3. Tevere, tinoenda kune chikamu 'chepamberi ".



4. Mune "general" marongero ari pakati pepahwindo repahwindo isu tinodzvanya pane "Shanduko Rondedzero ..." bhatani.



5. Rondedzero yeRondedzero inovhura. Muchikamu cheruboshwe pane yatove iripo zvinyorwa. Kuti uwedzere rondedzero nyowani, nyorera mazwi anodikanwa mu "zvinyorwa zvinhu". Chinhu chimwe nechimwe chinofanira kutanga nemutsva mutsva. Mushure memashoko ese akanyorwa, tinya pane "Wedzera" bhatani.



6. Mushure meizvozvo, rondedzero hwindo rinovhara, uye kana richizarura, mushandisi anozogona kuona zvinhu izvo zvakawedzera kare mune iyo inoshanda rondedzero yehwindo.



7. Zvino, mushure mekunge iwe ukaita izwi muchitokisi chero renzvimbo, iyo yaive imwe yezvinhu zvegwaro rakawedzerwa, uye shandisa iyo inozadza mucherechedzo, masero akasarudzwa anozadzwa nemavara kubva kune anoenderana.

Sezvauri kuona, autfill muExle inonyanya kubatsira uye yakakodzera chishandiso chinokubvumira kuti uwedzere kuchengetedza nguva yekuwedzera iyo data rondedzero, nezvimwe Kubatsira kwechishandiso ichi ndechekuti inobatsira. Iwe unogona kugadzira zvinyorwa zvitsva kana kushandura iyo yekare. Mukuwedzera, nerubatsiro rwe dendefill, zvinokwanisika kukurumidza kuzadza masero ane mhando dzakasiyana dzemhando dzemasvomhu kufambira mberi kwemasvomhu.