Abakoresha benshi ba Excel mugihe bagerageza gushyira ikibaho kurupapuro, hari ingorane nyinshi. Ikigaragara ni uko gahunda yumva agasyo, nkigipange cyo gukuramo, hanyuma uhite uhindura indangagaciro muri selire muri formula. Kubwibyo, iki kibazo kirinda. Reka tumenye uburyo bwo gushira hejuru.
Gucukura
Akenshi, iyo uzuza inyandiko zinyuranye, raporo, imenyekanisha rigomba gushyirwaho ko selile ihuye nigisobanuro runaka ntabwo irimo indangagaciro. Kuri izo ntego, biramenyerewe gukoresha kwiruka. Kuri gahunda ya Excel, iyi miterere, irahari, ariko kugirango ihindure umukoresha utiteguye ari ikibazo, kuko umuyoboro uhita uhinduka muburyo. Kugira ngo wirinde ihinduka, ugomba gukora ibikorwa bimwe.
Uburyo 1: Imiterere yimiterere
Inzira izwi cyane yo gushyira dummy muri selile nugutanga imiterere yinyandiko. Nibyo, aya mahitamo ntabwo buri gihe afasha.
- Turagaragaza selile ukeneye gushyira ikibaho. Kanda kuri Iburyo bwimbeba. Mubice bikubiyemo ibigaragara, hitamo inzira ya selile. Urashobora gukanda Ctrl + 1 Mwandikisho muri clavier aho kubikorwa.
- Idirishya ryahinduwe. Jya kuri tab "umubare" niba yafunguye muyindi tab. Muri "imiterere ya numero" yumubare ", hitamo ikintu" inyandiko ". Kanda kuri buto ya "OK".
Nyuma yibi, selile yatoranijwe izahabwa umutungo wanditse. Indangagaciro zose zinjiye muriyo ntizamenyekana nkibintu byo kubara, ariko nkinyandiko yoroshye. Noneho muri kariya gace, urashobora kwinjira mu kimenyetso "-" uhereye kuri clavier kandi bizagaragazwa neza ko ari inka, kandi ntizibonwa na gahunda nkikimenyetso cya "ukuyemo".
Hariho ubundi buryo bwo kuvugurura selire muburyo bwinyandiko. Kugirango ukore ibi, mugihe uri murugo, ugomba gukanda kurutonde rwamanutse rwimiterere yamakuru, iherereye kuri kaseti muri "Umubare" wibikoresho. Urutonde rwimiterere ihari irafunguwe. Muri uru rutonde ugomba guhitamo ikintu "inyandiko".
Isomo: Nigute ushobora guhindura imiterere yimodoka muri Excel
Uburyo 2: Kanda buto yinjira
Ariko ubu buryo ntabwo bukora mubihe byose. Akenshi, na nyuma yo gukora ubu buryo, iyo winjiye muri "-" ikimenyetso, amahuza amwe atandukanye andi manza agaragara aho kwifuzwa. Byongeye kandi, ntabwo buri gihe byoroshye, cyane cyane niba uri kumeza ya selile hamwe na dumplers isimburana hamwe na selile zuzuyemo amakuru. Ubwa mbere, muriki gihe ugomba gukora buriwese kugiti cyawe, icya kabiri, selile yiyi mbonerahamwe izagira uburyo butandukanye, nacyo kikaba kigomba guhora cyemewe. Ariko urashobora gukora ukundi.
- Turagaragaza selile ukeneye gushyira ikibaho. Kanda kuri buto "Guhuza hagati", iri kuri kaseti murugo rwa tab mumirongo ihuza. Kandi ukande kandi kuri buto "guhuza hagati", giherereye muri make. Birakenewe kugirango umwobo uherereye neza hagati ya selire, nkuko bikwiye, kandi ntabwo ari ibumoso.
- Twishakira "-" Ikimenyetso kiri muri kasho. Nyuma yibyo, ntugire icyo ukora hamwe nimbeba, ugahita ukande buto yimtonde kugirango ujye kumurongo ukurikira. Niba, ahubwo, umukoresha akanze ku mbeba, hanyuma mu Kagari, aho intambara igomba guhagarara, formula izongera kugaragara.
Ubu buryo nibyiza kubiroroshye byayo nibikorwa muburyo ubwo aribwo bwose. Ariko, icyarimwe, kubikoresha, ni ngombwa kwita ku guhindura ibiri muri kasho, kubera ko kubera ibikorwa bimwe bitari byo, formula irashobora kugaragara aho kuba fibre.
Uburyo 3: Kwinjiza ikimenyetso
Indi verisiyo yo kwandika fibre kuri excel nukwinjiza ikimenyetso.
- Turagaragaza selile aho ukeneye kwinjizamo umuyoboro. Jya kuri tab "shyiramo". Kuri kaseti mubikoresho bya "ibimenyetso" guhagarika buto ya "ikimenyetso".
- Kuba mu tab "ibimenyetso", shiraho ibipimo "ibimenyetso byamaduka" mu idirishya ryumurima "Set". Mu gice cyo hagati yidirishya turimo gushaka ikimenyetso "─" ndabigaragaza. Noneho kanda kuri buto "Paste".
Nyuma yibyo, urugamba ruzagaragaza muri selire yatoranijwe.
Hariho ubundi buryo bwuburyo. Kuba mu idirishya "ikimenyetso", jya kuri "ibimenyetso bidasanzwe". Kurutonde rufungura, rutanga ikintu "Dash Dash". Kanda kuri buto "Paste". Igisubizo kizaba kimwe no muri verisiyo ibanza.
Ubu buryo ni bwiza kuko ntibuzakenerwa ubwoba bwakozwe numurongo utari wo wimbeba. Ikimenyetso ntikizahindura uko byagenda kose kuri formula. Byongeye kandi, mumashusho, bateri yatanzwe nuburyo busa neza kuruta inyuguti ngufi yatsindiyeho. Ibibi nyamukuru byubu buryo ni ngombwa gukora rimwe na rimwe icyarimwe, bikubiyemo gutakaza by'agateganyo.
Uburyo 4: Ongeraho ikimenyetso cyinyongera
Byongeye, hariho ubundi buryo bwo gushyira umwobo. Nukuri, kwerekana ubu buryo ntibyemewe kubakoresha bose, nkuko bifata ahari mu Kagari, usibye ikimenyetso "-", ikindi kimenyetso.
- Turagaragaza selile ukeneye kwishyiriraho ikibaho, hanyuma ushireho "'" imiterere ya clavier. Iherereye kuri buto imwe nkinyuguti "e" muburyo bwa silillic. Noneho ako kanya udafite umwanya ushyirwaho ikimenyetso "-".
- Kanda kuri buto yinjira cyangwa ukemure indanga ukoresheje imbeba izindi selile. Mugihe ukoresheje ubu buryo, ibi ntabwo ari ngombwa. Nkuko mubibona, nyuma yibi bikorwa, dock yashizwe ku rupapuro, n'inyongera y'inyongera "'" iragaragara gusa kumurongo wa formulaire mugihe cyo gutoranya selire.
Hariho uburyo butandukanye bwo kwinjiza muri bateri, guhitamo hagati yumukoresha ushobora gukora akurikije imikoreshereze yinyandiko yihariye. Abantu benshi mugihe cyambere cyatsinzwe kugirango bashyire ikimenyetso cyifuzwa bagerageza guhindura imiterere ya selile. Kubwamahirwe, ibi ntabwo buri gihe biterwa. Kubwamahirwe, hari ubundi buryo bwo gukora iki gikorwa: Inzibacyuho kuwundi mugozi ukoresheje buto yinjira, gukoresha inyuguti binyuze kuri buto ya kaseti, '. Buri buryo bufite ibyiza nibibi byasobanuwe haruguru. Version Yisi yose, ibereye cyane kwishyiriraho dokicki muribihe bidasanzwe mubihe byose bishoboka, ntibibaho.