The donhwe-pasi pasi muna Excel

Nhasi kombiyuta rava chinhu chinokosha muupenyu hwedu. Zvirongwa Various vari saka nyore basa kuti haugoni kuita pasina kunyange ruzivo ruzivo user. Mumwe wavo aiva chirongwa Excel - yakavanakira, nyore uye kunobatsira chaizvo. Nemhaka ayo vakawanda features, rinogona kushandiswa senzira kombiyuta musha, uye hofisi basa. Nokuti vamwe hwava nyore chinokosha.

Chokwadi, kutanga kushanda pamwe Excel rakanyatsojeka kuoma, asi nenguva, kunzwisisa mashandiro ayo, zvinova nyore zvikuru. Asava mutendi mutsva mushandisi zviri dzimwe nguva zvakaoma kunzwisisa ose nuances basa, saka nyaya kuchaita kutaura imwe nyaya, riri inofarirwa nevakawanda: "How kuita kusiyira-pasi mazita ari Excel». Edza kunzwisisa.

Chokutanga, tinofanira kunzwisisa kuti uyu donhwe-pasi mazita ari Excel. Kazhinji, nokuveza Excel-magwaro, vanoshandisa vane kudiwa kupinda chete mashoko muzvitokisi akawanda. Nyaya iri anotambudza uye hakukoshi. Kuti zvimwe nyore muitiro, kuziva izvozvo mashandiro anoita chikumbiro, sezvinoita donhwe-pasi mazita. Iri pedyo zvikuru chinhu, uye nyora pasi dzakasiyana-siyana.

Nokudaro, donhwe-pasi mazita ari Excel dzinogona kurongwa vachishandisa mureza nzira uye kushandisa Software chidhiraivho. nyaya yokutanga zvakakodzera beginners uyewo zviito akenda chete ose mhando uchishandisa hurongwa. Chokutanga, sarudza zvose zvinodiwa masero pamwe data, izvo zvinofanira kuitwa muna donhwe-pasi pasi. Zvino akaita pasuo Muterere, uye zvinotevera kutevedzana kwezviitiko nezviito: "Insert" - "Zita" - "Muzvitsaurire".

Kupinda zita nokuti kuwanda kusarudzwa (inogona upi huru mugariro - rirege ane dzezvimwe). Zviito vari kwechokwadi vachisundira "OK". Zvino zvakafanira kuti kucherechedza sero iyo pamazita achadonha. Unogona tsanangurai vanopfuura mumwe. Zvakare rinovhura Muterere uye wasarudza murayiro "Data" - "Check". Zvadaro "Options" Tab. Zvose yaida date mhando "List" rinofanira kusarudzwa. Mu "Source" Pindai kusaina "vakaenzana" uye akati pakutanga zita pamazita asina dzezvimwe. Kuitwa. Excel achadonha Pamazita kuumba mureza nzira.

In basa mashoko anogona zvavaita dynamically ainzi chikuva Somuenzaniso, chero wekunge. Kana uchida kuwedzera umboo kuti huru gwaro, ivo ndivo vanonzi akawedzera kuti donhwe pasi mazita ari Excel. Panewo Zvaiitwa chokuita mazita. Izvi zvinoreva kuti kana iwe kuchinja imwe, ivo ndivo vanonzi akachinja mumwe.

nyaya yechipiri inosanganisira nokuumba donhwe-pasi pasi kushandisa chidhiraivho. In shanduro Excel 2007-2010 ari Toolbar kuzarura Tab "Developer" (kana akura chirongwa inovhura "Forms" Tab). Pano, mu kumusoro Zviridzwa ari, zvinokosha kuwana icon akadonhedza-pasi pasi, sarudza izvozvo uye tara rectangle. Izvi zvichava chinotevera donhwe-pasi mazita ari Excel.

Shandisa zvakanaka mbeva bhatani, sarudza "Format Vanoramba". In kunoguma nhaurirano bhokisi, vaite hurongwa zvinotevera mirayiro: "kuumba pasi bhendi" (sarudza avo masero kuti zvinofanira kuva pachikwata), "Cell linked" (kutaridzwa sero iyo chichange kunyoreswa chinhu nhamba), uye vokupedzisira - " kuwanda mitsara zvakarongwa "(kupinda neuwandu mitsara yemberi pasi). Kwese asimbise chakaitwa vachisundira "OK". The donhwe-pasi pasi akasikwa, unogona kutanga kushanda.

Nzira nyore chaizvo kuti pave donhwe-pasi mazita, izvo zvakakodzera kunyange vaya vane shoma kunzwisisa makombiyuta riri sezvinotevera. tsika maviri kana matatu akapinda Mbiru (napo). On mumwe wavo kuyengerera kubva cursor achizviendesa kiyi wemishonga kiibhodhi alt + Down Arrow kana kushandisa kodzero negonzo bhatani anosarudza "Sarudza kubva dropdown mazita."