Xa usebenza kwiMicrosoft Excel kwiitafile zedatha ephindaphindayo, kulula kakhulu ukusebenzisa uluhlu olusezantsi. Ngayo, unokukhetha nje iiparamitha ezinqwenelekayo kwimenyu eyenziwe. Masifumanise ukuba senze njani uluhlu lwehlayo ngeendlela ezahlukeneyo.
Ukwenza uluhlu olongezelelweyo
Elona xesha lilungileyo, kwaye kwangaxeshanye eyona ndlela isebenzayo yokwenza uluhlu lwezinto ezihlayo yindlela esekwe kwisakhiwo uluhlu lwedatha eyahlukileyo.
Okokuqala, senza itafile engenanto apho siza kuyisebenzisa imenyu eyehlayo, kwaye yenza uluhlu oluthe kratya lwedatha kwiMenyu. Le datha inokuthi ibekwe zombini kwiphepha elinye loxwebhu kwaye kwelinye, ukuba awufuni ukuba zombini itafile ihlale ihambelana.
Sabela idatha esiceba ukufaka isicelo kuluhlu olusezantsi. Sicofa kwiqhosha leqhosha lasekunene, kwaye ukhethe igama elithi "ukwabela ..." kwimenyu yemeko.
Uhlobo lokwenza igama livule. Kwintsimi "yegama", ukonwabela igama elifanelekileyo esiya kuzifumana kulo uluhlu. Kodwa, eli gama kufuneka liqale ngeleta. Ungafaka inqaku, kodwa akunyanzelekanga. Cofa kwiqhosha "Kulungile".
Yiya kwithebhu "Idatha" yeenkqubo zeMicrosoft Excel. Sibonisa indawo yetafile apho siza kusebenzisa uluhlu lwe-dyd-tid. Cofa kwiqhosha le "DEAT" elibekwe kwi-tepi.
Iwindows yokuqinisekisa ivula igalelo lamaxabiso. Kwi "Parameter" ithebhu, kwicandelo lohlobo lwedatha, khetha i-parameter yoluhlu. Entsimini "umthombo" Beka uphawu olulinganayo, kwaye ngoko nangoko sibhala igama loluhlu, elihlala lihlala lilibeka ngaphezulu. Cofa kwiqhosha "Kulungile".
Uluhlu olusezantsi lulungile. Ngoku, xa ucofa kwiqhosha, iseli nganye yoluhlu oluchaziweyo iya kuvela luluhlu lweeparamitha, phakathi kwendlela onokuthi ukhethe kuzo ukongeza kwiseli.
Ukudala uluhlu lwehlayo usebenzisa izixhobo zophuhliso
Indlela yesibini ibandakanya ukudala uluhlu olusezantsi usebenzisa izixhobo zomphunga, ezizezi ukusebenzisa i-ActiveX. Ngokungagqibekanga, akukho sixhobo siphumlisi, ke kuya kufuneka kuqala sibandakanye. Ukwenza oku, yiya kwi "Ifayile" ye-PRECL Inkqubo ye-Excel, kwaye emva koko ucofe umbhalo "weparamitha".
Kwifestile evula, yiya kwicandelwana elithi "IRibbon", uze usete ibhokisi yokujonga ngokujonga " Cofa kwiqhosha "Kulungile".
Emva koko, ithebhu ivele kwitheyiphu enegama "umphuhli", apho siyahamba khona. Abantsundu kwiMicrosoft Excel, ekufuneka kuba yimenyu eyehlayo. Emva koko, cofa kwi-tepi kwi-icon "Faka" i-icon, kwaye phakathi kwezinto ezabonakala kwiqela le-ActiveX, khetha "intsimi enoluhlu".
Cofa kwindawo apho iseli kuluhlu kufuneka ibe khona. Njengoko ubona, ifomu yoluhlu ivele.
Emva koko sifudukela kwi "Modetory Mode". Cofa kwi "Proberges yeqhosha le-".
Iwindow yolawulo ivulwa. Kwigrafu "igrafu" i-Guardfillran "ngesandla, sikhuthaza uluhlu lweeseli zetafile ngekholoni, eziya kuthi zenze amanqaku oluluhlu olusezantsi.
Okulandelayo, cofa kwiseli, kunye nemenyu yemeko, ngokulandelelana hamba ngento "combobox" kwaye "hlela".
Uluhlu lwehla kwiMicrosoft Excel sele ilungile.
Ukwenza ezinye iiseli ezinoluhlu olusezantsi, kuba kanye ibe ngumda osezantsi weseli egqityiweyo, cinezela iqhosha lemouse, kwaye ulula.
Uluhlu olunxulumene noko
Kwakhona, kwiNkqubo ye-Excel unokwenza uluhlu oluhlelayo ezantsi. Olu luhlu olunjalo xa ukhetha ixabiso elinye kuluhlu, kwenye ikholamu icetywa ukuba ikhethe iiparamitha ezihambelanayo. Umzekelo, xa ukhetha uluhlu lweemveliso zeetapile, kucetywa ukuba ukhetha njengekhilogram kunye neegram zikulinganisa amanyathelo omlinganiso, kwaye xa ioyile yemifuno ikhethiwe - ilitha kunye neemililimitha.
Okokuqala, silungiselela itafile apho uluhlu lwehla, kwaye siya kwenza uluhlu ngegama leemveliso kunye nemilinganiselo yokulinganisa.
Sinikezela ngasinye kuluhlu ngalunye luluhlu olubilini, njengoko sele senze ngaphambili ngoluhlu oluqhelekileyo.
Kwiseli yokuqala, senza uluhlu ngendlela eya kwenziwa ngaphambili, ngokungqinisisa idatha.
Kwiseli yesibini, ukuqalisa iwindows yokuqinisekiswa kwedatha, kodwa kwikholam "Umthombo" Sifaka umsebenzi "= Dwari" kunye nedilesi yeseli yokuqala. Umzekelo, = i-DVSSL ($ B3).
Njengoko ubona, uluhlu lwenziwe.
Ngoku, ukuze iiseli ezisezantsi zizuza iipropathi ezifanayo, njengakwixesha elidlulileyo, khetha iiseli ezingaphezulu, kunye nesitshixo semouse "phantsi" phantsi.
Yonke into, itafile yenziwa.
Sivile ukuba ungazenzela uLuhlu oluZekileyo kwi-Excel. Inkqubo inokwenza uluhlu olusezantsi lwehla kwaye luxhomekeke. Kwangelo xesha, unokusebenzisa iindlela ezahlukeneyo zokudalwa. Ukukhetha kuxhomekeke kwinjongo ethile yoluhlu, iinjongo zendalo, indawo yesicelo, njl.