Rhoqo, imixholo yeseli etafileni ayihambelani nemida efakwe ngokungagqibekanga. Kule meko, umbuzo wokwanda kwabo ufanelekile ukuze lonke ulwazi lulunge kwaye lubonakale kumsebenzisi. Masifumanise ukuba zeziphi iindlela ezinokwenziwa le nkqubo kwi-Excele.
Inkqubo yokwandiswa
Kukho iindlela ezininzi zokwenza iiseli. Ezinye zazo zibandakanya ukungcolisa ngesandla imida, kwaye nabanye onokuthi uqwalasele ukusenziwa ngokuzenzekelayo kwale nkqubo kuxhomekeke kubude bomxholo.Indlela yoku-1: Ukutsala ngokulula kwemida
Eyona ndlela ilula kwaye inomdla wokwandisa ubungakanani beseli kukutsala imida ngesandla. Oku kunokwenziwa kumgangatho othe nkqo kwaye othe tyaba kwimiqolo kunye neekholamu ezilungelelanisayo.
- Simanzisa isikhombisi kumda ofanelekileyo wecandelo kumgangatho othe tyaba othe tyaba kwikholamu sifuna ukwanda. Kwangelo xesha, umnqamlezo ubonakala neekhomba ezimbini ezijolise kumacala ahlukileyo. Cofa iqhosha lemouse lasekhohlo kunye nemida efanelekileyo ngasekunene, oko kukuthi, ukusuka embindini weseli eyandisiweyo.
- Ukuba kukho imfuneko, le nkqubo inokwenziwa ngemigca. Ukwenza oku, kuya kufuneka ubeke isikhombisi kumda ongezantsi womgca uya kwandiswa. Ngokufanayo, ukuqhwaba iqhosha lemouse lasekhohlo kwaye utsala umda.
QAPHELA! Ukuba kumgangatho othe tyaba othe tyaba usete isikhombisi kumda osekhohlo wekholamu eyandisiweyo, kwaye nkqo ukuya kumda ophezulu womgca, ukwenza inkqubo yokumbamba, ubungakanani beeseli ekujoliswe kuzo akuyi kunyuka. Bafudusela nje ngenxa yotshintsho kubungakanani beminye imisebenzi yezinto.
Indlela 2: Ukwandiswa kweekholamu ezininzi kunye nemigca
Kukho ukhetho lokwandisa iikholamu ezininzi okanye imiqolo ngexesha elinye.
- Sibonisa amacandelo aliqela kumgangatho othe tyaba kwaye nkqo.
- Sisongela isikhombisi kumda ofanelekileyo ngasekunene kwelungelo ukusuka kwiiseli (okwethutyana elithe tyaba) okanye kumda ophantsi weseli esezantsi (kumgangatho othe nkqo). Cofa iqhosha lemouse lasekhohlo kwaye utsala i-kutoll ivele ngokulandelelana okanye ezantsi.
- Oku kwandisa kuphela uluhlu olugqithisileyo, kodwa neeseli kulo lonke indawo ekhethiweyo.
Indlela yesi-3: Ubungakanani be-AMAFAYENSI Igalelo kwimenyu yokujonga
Unokwenza kwakhona igalelo le-sumal yesayizi yeseli, ilinganiswe kwixabiso lamanani. Ngokungagqibekanga, ukuphakama kunobungakanani beeyunithi ze-12,75, kwaye ububanzi buyiiyunithi eziyi-8.43. Ungandinyusa ukuya kuthi ga kumanqaku angama-409, ububanzi ukuya kwi-255.
- Ukwenzela ukutshintsha iiparamitha zobubanzi beseli, khetha uluhlu olufunayo kwinqanaba elithe tyaba. Cofa kuyo kwiqhosha le mouse lasekunene. Kwimenyu yemeko evelayo, khetha "ububanzi bekholamu.
- Ifestile encinci ivula, apho kufuneka ufaka ububanzi bekholamu efunekayo kwiiyunithi. Ngenisa ubungakanani obufunekayo kwikhibhodi kwaye ucofe iqhosha u "Kulungile".
Indlela efanayo yenziwe utshintsho kwimigca.
- Khetha icandelo okanye uluhlu lwamanqaku alungelelanisiweyo. Cofa kule ndawo ngeqhosha le mouse lasekunene. Kwimenyu yokujonga, khetha "ubude bomtya ..." into.
- Ifestile ivulwa, apho kufuneka uqhube ubude obufunekayo beeseli zodidi olukhethiweyo kwiiyunithi. Siyayenza kwaye nqakraza kwiqhosha "Kulungile".
Oku kushigulukwano ngentla kukuvumela ukuba unyuse ububanzi nokuphakama kweeseli kwiiyunithi zemilinganiselo.
Indlela 4: Faka ubungakanani beeseli ngeqhosha kwi-ribbon
Ukongeza, kunokwenzeka ukuba ubeke ubungakanani beseli ekhankanyiweyo ngeqhosha leteyiphu.
- Sabela iseli ephepheni, ubungakanani ofuna ukuyifaka.
- Yiya "ekhaya", ukuba sikwinye. Cofa kwiqhosha "Ifomathi", efumaneka kwi-teyipikisi kwi-Toolbar yesixhobo "seseli". Uluhlu lwezenzo luvula. Ikhethe ngokungafaniyo kuyo amanqaku "ukuphakama komgca ..." kunye "nobubanzi bekholamu ...". Emva kokucinezela nganye kwezi zinto, kuya kuvulwa iifestile ezincinci, malunga neliphi ibali elilandelayo xa sichaza indlela yangaphambili. Kuya kufuneka bazise ububanzi obufunyeneyo kunye nokuphakama koluhlu olukhethiweyo lweeseli. Ukuze iiseli ezonde, ixabiso elitsha lale parameter kufuneka libe likhulu kuneso sifakiweyo ngaphambili.
Indlela yesi-5: Yandisa ubungakanani bamaphepha onke ephepha okanye incwadi
Kukho iimeko xa kufuneka unyuke ngokupheleleyo zonke iiseli zephepha okanye kwiincwadi. Xelela indlela yokwenza.
- Ukuze enze lo msebenzi, okokuqala, khetha izinto ezinqwenelekayo. Ukuze ukhethe zonke izinto, unokusicinezela isitshixo sekhibhodi kwi-CTRL + ikhibhodi. Kukho ukhetho lwesibini. Kuthetha ukucinezela iqhosha ngohlobo loxande, olufumaneka phakathi kwenqanaba elithe nkqo kunye nethe tyaba.
- Emva kokuba le phepha likhethelwe ngayo nayiphi na kwezi ndlela, cofa kwiqhosha elisele lifudumele i-tepi kwaye livelise iintshukumo ezifanayo ngendlela echazwe kwiNdlela yeKholamu "kububanzi bekholamu .. . "kunye" nokuphakama komgca ... ".
Izenzo ezifanayo zivelisa ukonyusa ubungakanani beeseli zeNcwadi yonke. Kuphela kukuqaqambisa onke amaphepha esisebenzisa olunye ulwamkelo.
- Ngokucofa iqhosha lemouse lasekunene kwilebhile yalo naliphi na iphepha leshiti, elikwezantsi kwefestile kwangoko ngaphezulu kwenqanaba. Kwimenyu ebonakalayo, khetha "Yabela onke amaphepha".
- Emva kokuba amashiti aqaqanjiswe, enze utyando lwe-ribbon usebenzisa iqhosha elithi "ifomathi", eyachazwa kwiNdlela yeSine.
Isifundo: Indlela yokwenza iiseli ezilinganayo kwi-Excel
Indlela yesi-6: Ububanzi
Le ndlela ayinakubizwa ngokuba yinyuko epheleleyo kwisayizi yeseli, kodwa, nangona kunjalo, ikwanceda ekulinganiseni ngokupheleleyo isicatshulwa kwimida ekhoyo. Xa incediswa, ukuncipha ngokuzenzekelayo kwiisimboli zomxholo kukuthi kufanelekile kwiseli. Ke, kunokutshiwo ukuba ubungakanani bayo besalamane itekisi iyanda.
- Saba uluhlu apho sinqwenela ukusebenzisa iipropathi zobubanzi bobubanzi. Cofa kwindawo ebalaseleyo kwiqhosha leqhosha lasekunene. Imenyu yemeko ivula. Khetha kuyo "Ifomati yeseli ...".
- Ifestile yokufomatha ivuliwe. Yiya kwi "thungelwano" ithebhu. Kwi-"boober" ibhloko ye "bonisa", sibeke i-tick kufutshane neparameter "yobubanzi. Cofa kwiqhosha "Kulungile" emazantsi efestile.
Emva kwezi zenzo, nokuba irekhodi le, kodwa iya kulunga kwiseli. Kuyinyani, kuya kufuneka uqaphele ukuba ukuba kukho abalinganiswa baninzi kakhulu ephepheni, kwaye umsebenzisi akasayi kuyindisa enye yeendlela zangaphambili, emva koko oku kungafunwa kungafundeki. Ke ngoko, banoneliseke ngohlobo olunikiweyo ukuqinisekisa ukuba idatha ibe yimida, hayi kuzo zonke iimeko yamkelekile. Ukongeza, kufuneka kuthiwe ukuba le ndlela isebenza kuphela ngesicatshulwa, kodwa ayinamaxabiso amanani.
Njengoko sibona, zininzi iindlela zokukhulisa ubungakanani beeseli ezizodwa kunye namaqela onke, ukuya kulwanda kuzo zonke izinto okanye iincwadi. Umsebenzisi ngamnye unokukhetha eyona ndlela ilula yokwenza le nkqubo kwiimeko ezithile. Ukongeza, kukho indlela eyongezelelekileyo yokuhlalisa umxholo kwimida yeseli esebenzisa ububanzi bobubanzi. Kuyinyani, eyona ndlela yokugqibela inezithintelo ezininzi.