Zvinogoneka kuti pane imwe nguva wakavhura gwaro reExcel uye waona kuti rondedzero yekudonha inovhura mune mamwe maseru ayo. Ichi chinhu chinobatsira kwazvo cheMicrosoft spreadsheets chaunogona kushandisa zvakare. Muchinyorwa chino tinotsanangura maitiro ekugadzira donhodzo pasi muExcel
Iri ibasa rinobatsira zvikuru, kunyanya patinenge tichishanda nemashizha uye ma templates umo sarudzo dzakafanana dzinodzokororwa. Asi pamusoro pekuita basa, iri zvakare chiratidziro chinotaridzika chinopa kutarisisa kwehunyanzvi kune chero gwaro.
Mazita ekudonhedza pasi (muChirungu, pasi drop list) bvumidza vashandisi ve Excel sarudza chinhu kubva pane zvakafanotaurwa. Icho chinhu chakanyanya kufanira kugadzira mafomu, nekuti kuvonga kwairi kupinza data kunokurumidza uye zvakare kwakanyanya.
Mazita aya anoshanda sei? Patinosarudza sero rine runyoro, tinoona padivi payo chiratidzo chemuseve mudiki. Kana uchidzvanya pairi, rondedzero iyi inoratidzwa nenhevedzano yesarudzo pakati patinofanira kusarudza imwe.
Pfungwa yekutanga yekugadzira zvinyorwa zvekudonhedza muExcel ndeyekupa mushandisi nhamba shoma yezvisarudzo. Pamusoro pezvo, kuunzwa kwedata rine zvikanganiso kana kutadza kuperetera kunodzivirirwa.
Gadzira runyoro-pasi muExcel nhanho nhanho
Aya ndiwo matanho ekutevera kugadzira zvinyorwa zvekudonha muExcel:
Danho rechipiri: Sarudza sero
Kana isu tatova neExcel sheet iyo yakawedzera kana kushoma kurongeka uye kurongeka uye isu tinofunga nezvemubvunzo wekuisa imwe kana akawanda ekudonhedza rondedzero mairi, chinhu chekutanga chatinofanira kuita. sarudza nechinongedzo chembeva sero kana maseru yatinoda kuti rondedzero ivhurwe kana tadzvanya pairi.
Danho 2: Kusimbiswa kwedata
Zvadaro, tinya pane "Data" tab. Kana tavhura, tinoenda kuboka re "Data Tools" kwatinofanira kuwana uye tinya sarudzo "Data kusimbiswa". Zvichienderana neshanduro yeExcel yatakaisa, iyo icon inogona kusiyana, kunyangwe kazhinji kazhinji inotaridzika semasero maviri, imwe yakasimbiswa uye imwe isina.
Danho rechitatu: Sarudza uye gadzirisa rondedzero
Mushure mekusimbiswa, rondedzero yekudonha inovhura, umo isu tinosarudza sarudzo "Ready". Ikoko isu tinewo dzimwe sarudzo dzatichakwanisa kudzikisira zviri musero kune mamwe mafomati (nhamba, misi, maawa, nezvimwewo). Zvadaro, tinogona kuenderera nenzira mbiri dzakasiyana:
- nyora zvinhu izvo zvatinoda kupa sezvisarudzo mukati merondedzero (inofanirwa kupatsanurwa necomma, pasina nzvimbo).
- Sarudza huwandu hwemasero ine idzo sarudzo uye wozvisimbisa nekudzvanya pane museve icon padyo nesero panovhurwa rondedzero yekudonhedza.
Kana maitirwo apera, tichaona kuti kudzvanya pane yakasarudzwa sero kucharatidza rondedzero yatakagadzira. Kana isu tichida kudzokorora kuvhiyiwa mune imwe sero yegwaro, zvinokwana kuikopa kuclipboard uye nekuiisa musero idzva.
Gadzira chinyorwa chinodonhedza pasi muExcel
Kana isu tikaronga kugara tichichinja zvinhu zviri mune yedu yekudonha runyoro muExcel, zvingave zvakanyanya kukodzera kusarudza kugadzira a dynamic dropdown list. Uku ndiko mutsauko wezvatakaona muchikamu chakapfuura, nehunyanzvi hwekuti, mune ino kesi, pese patinoita shanduko mumaseru kana mune rondedzero yezvinyorwa, rondedzero yekudonha inovandudzwa otomatiki.
Pane nzira mbiri dzekugadzira rudzi urwu rwerunyorwa: neiyo nzira yatakatsanangura kare kana kushandisa yakajairwa zita renji nekuinongedzera ne OFFSET formula. Isu tinotsanangura kuti zvinoitwa sei pasi apa:
- Kutanga isu tinofanirwa kunyora iyo yekudonha menyu zvinhu mumaseru akasiyana.
- Zvadaro tinogadzira fomu yakadanwa (kuita izvi, shandisa Kudzora + F3 kiyi musanganiswa kuvhura iyo dialog).
- Kana zita idzva ranyorwa mubhokisi re "Zita", tinosuma fomura rinotevera:
=OFFSET(Sheet!$A$2, 0, 0, COUNTA(Sheet3!$A:$A), 1) *
Sheet: zita repepa.
A : Koramu iyo zvinhu zvekudonhedza zviripo.
$A $2: Sero rine chinhu chekutanga.
Kana isu tatova neformula yakatsanangurwa, isu tinongofanirwa kugadzira yekudonhedza-pasi menyu zvichienderana nehuwandu hwemasero, sezvatakaona muchikamu chapfuura. Maitiro ekuseta akanyanya kunetsa, asi zvichave zvakakosha kana isu tichifanira kushanda neanogara achichinja runyorwa rwemasource masero.
(*) Sezvinoonekwa, iyi fomula ine mabasa maviri: OFFSET uye COUNTA. Chechipiri ndechekuverenga ese asina blank maseru ari mureferensi column. Kuverenga uku kunoshandiswawo neiyo OFFSET basa.