Maitiro ekukurumidza kugadzira rondedzero ine nhamba muExcel

Kana tichigadzira matafura uye tichigara tichishanda muExcel, isu munguva pfupi kana gare gare tinotarisana nedambudziko rekugadzira rondedzero ine nhamba. Pane nzira dzakawanda dzekugadzira, imwe neimwe ichakurukurwa zvakadzama munyaya ino.

Nzira nhamba 1: Rondedzero yenhamba muExcel yesero rimwe

Kazhinji pane mamiriro ezvinhu apo pazvinenge zvakakodzera kuti akwane mucherechedzo uye kuverengwa kwerondedzero musero rimwe. Kuda kwakadaro kungamuka nekuda kwenzvimbo shoma yekuzadza ruzivo rwese. Maitiro ekuisa bullet kana rondedzero ine nhamba musero rimwe chete nemutsara wekuzivisa:

1. Nyora runyoro ruchaverengwa. Kana iyo yakagadzirwa kare, saka tinoenderera mberi kune zvimwe zviito.

Cherechedza kubva kune nyanzvi! Chakashata chenzira iyi ndechekuti manhamba kana mamakisi anoiswa musero rega rega zvakasiyana.

2. Shandisa mutsara unoda kugadziriswa uye uise delimiter pamberi pezwi.
3. Enda ku "Insert" tab iri mumusoro wechirongwa.

4. Tsvaga boka rezvishandiso "Symbols" uye nekudzvanya pamuseve, enda kuhwindo rinovhura. Mariri, tinya pane "Symbol" chishandiso.

5. Tevere, kubva pane rondedzero yaunzwa, unofanirwa kusarudza manhamba kana mamaka aunoda, shandisa chiratidzo, uye tinya bhatani rekuti "Isa".

Nzira #2: Rondedzero Yenhamba yeMakoramu Akawanda

Rondedzero yakadaro ichaita seyakanyanya organic, asi yakakodzera kana nzvimbo iri patafura inobvumidza iwe kuisa akati wandei makoramu.

1. Muchikamu chekutanga nesero rekutanga, nyora nhamba "1".
2. Hover pamusoro pemubato wekuzadza uye wodhonza kusvika kumagumo erondedzero.
3. Kuti ufambise basa rekuzadza, unogona kudzvanya kaviri pane chiratidzo. Ichaita otomatiki.

4. Muchinyorwa chine nhamba, unogona kuona kuti chicherechedzo chakadzokorora kukosha kwedhijitari "1" mumitsara yese. Chii chekuita munyaya iyi? Kuti uite izvi, mukona yezasi yekurudyi, unogona kuwana Autofill Options chishandiso. Nekudzvanya pachiratidzo mukona yebhuroko, rondedzero yekudonha ichavhura, kwaunoda kusarudza "Zadza".

5. Nekuda kweizvozvo, iyo yakaverengerwa rondedzero inozadzwa otomatiki neiyo chaiyo seti yenhamba.

Kuita kuti zvive nyore kuzadza rondedzero ine nhamba, unogona kushandisa imwe nzira:

1. Isa nhamba 1 uye 2 mumasero maviri ekutanga ekororamu, zvichiteerana.
2. Sarudza maseru ese ane chiratidzo chekuzadza uye mitsara yasara inozadzwa otomatiki.

Nyanzvi note! Usakanganwa kuti kana uchipinda nhamba, iwe unofanirwa kushandisa iyo nhamba block kurudyi rwekhibhodi. Nhamba dziri kumusoro hadzina kukodzera kuiswa.

Iwe unogona zvakare kuita iro basa rimwe chete uchishandisa iyo autocomplete basa: =STRING(). Chimbofunga muenzaniso wekuzadza mitsara nerondedzero yakarairwa uchishandisa basa:

1. Activate the top cell panotangira nhamba ine manhamba.
2. Mune fomula bar, isa chiratidzo chakaenzana "=" uye nyora iyo "ROW" shanda iwe pachako kana kuiwana mu "Insert Function" chishandiso.
3. Pakupera kweformula, isa mabhureki ekuvhura nekuvhara kuti uone otomatiki tambo.

4. Isa cursor pamubato wekuzadza sero uye woikwevera pasi. Kana kuzadza maseru otomatiki nekudzvanya kaviri. Zvisinei nenzira yekupinda nayo, mhedzisiro ichange yakafanana uye ichazadza runyoro rwese nenhamba dzenhamba dzakaiswa nemazvo.

Nzira nhamba 3: shandisa kufambira mberi

Iyo yakanakisa sarudzo yekuzadza matafura mahombe nehuwandu hunoshamisa hwemitsara:

1. Pakuverengera, shandisa bhuroko renhamba riri kurudyi rwekhibhodi. Isa kukosha "1" musero rekutanga.

2. Mune tab "Kumba" tinowana bhuroka "Editing". Kudzvanya pakatatu kunovhura rondedzero yekudonhedza pasi. Ikoko tinomisa sarudzo yedu pamutsara "Kufambira mberi".
3. Hwindo rinovhurika apo, mu "Nzvimbo" parameter, isa chiratidzo kune "By columns" chinzvimbo.
4. Mufafitera rimwe chete, mu "Type" parameter, siya chicherechedzo panzvimbo ye "Arithmetic". Kazhinji, nzvimbo iyi inogadziriswa nekusingaperi.
5. Mumunda wakasununguka "Danho" tinonyora kukosha "1".
6. Kuti uone kukosha kwemuganho, iwe unofanirwa kuisa mundima inowirirana nhamba yemitsara inoda kuzadzwa nenhamba nhamba.

Cherechedza kubva kune nyanzvi! Kana iwe ukasapedzisa danho rekupedzisira, uye wosiya iyo "Limit kukosha" munda usina chinhu, saka otomatiki manhamba haizoitika, nekuti chirongwa hachizoziva kuti mangani mitsara yekutarisisa.

mhedziso

Chinyorwa chakapa nzira nhatu huru dzekugadzira rondedzero ine nhamba. Nzira 1 uye 2 dzinoonekwa sedzinonyanya kufarirwa. Panguva imwecheteyo, chimwe nechimwe chazvo chiri nyore pakugadzirisa mamwe marudzi emabasa.