Makhe sithethe lokubhengeza indlela imiqolo e Excel

Xa izicelo Microsoft Office, kukho umhleli itafile okhethekileyo, ebizwa Excel. A iluncedo kakhulu. Phakathi kwezinye izinto, kukho umsebenzi okhethekileyo - manani umgca Excel. Ukuxhaphaza eli thuba kwimowudi oluzenzekelayo, uyakwazi ukubona amanani eya kufakwa nje ekhohlo itafile ngokwayo. Nangona kunjalo, la manani ijoliswe kuphela ukubonisa imvelaphi iiseli, yaye ngenxa yoko, xa uqala ukushicilela itafile, koko babe nako ukuqaphela ukuba ezi zinto ziya nje akazukuboniswa.

Ukongeza, kukho into enye: Xa umsebenzisi kudala itafile entsha, koko banikwa isiqalo aziyi kubekwa kwikholam yokuqala, enqamleza inani oluzenzekelayo. Ukuze athintele ingxaki enjalo, abantu abaninzi ukongeza nje ikholam entsha okanye emgceni ukuba amanani. Kwelinye icala, lo mqolo inani e-Excel ngendlela efanayo kunokwenzeka, kodwa cinga nje iyafuneka ngayo ixesha elininzi ukuhlawula inyathelo wokulungiselela. Enyanisweni ilawulwe ngesandla ingafuneki. Ngaphandle kokuba, kakade, uyakwazi lokubhengeza indlela imiqolo e Excel usebenzisa imisebenzi yenkqubo. Ukuba namhlanje sathetha ngalo waza wagqiba ukuba angaxeli.

Ukuzityela okanye ngokuzenzekelayo

amanani Line e Excel unokuthabatha indawo ngeendlela ezininzi, hayi kanye mandithi, ezi zenzo ungakwazi noba ngesandla - ngumsebenzi yesiqhelo, okanye ngokuzenzekelayo, apho le nkqubo iya kuba ukuqhuba inani olandelayo kule theyibhile. Ukuba sele kumisa nokubala apho, kwaye ufuna ukongeza inombolo, ngoko ke kanye isakhiwo eziyimfuneko ukwenza umhlathi omtsha. Oku kunjalo ukuba amasimi efunekayo khona. Ukongeza umhlathi omtsha, kufuneka kuqala ukhethe umhlathi phambi apho uceba ukufaka amanani ukwenza oku, nqakraza kwi kwisihloko yayo.

Yonke kwenziwa kuwe

Ukuba awuyazi ukuba lokubhengeza indlela imiqolo e Excel kwindlela oluzenzekelayo, ngoko ziqhubela phambili ukuya yesikhokelo, leyo ngoku uchaze. Xa unqakraza kwisihloko, kufuneka nqakraza kwi kwindawo echongiweyo, nqakraza-ekunene kwaye ukhethe i drop-down menu umyalelo "Cola 'ukuba iinguqulelo abadala, oku kuba" Yongeza ". Ukuba ufuna ukubeka inani kwindawo tyaba, ngelixa umgca yokhetho kufuneka kwenziwe ugqitha kwi menu yentsingiselo, ungadibanisa umgca omtsha engenanto kuzo.

izenzo

Kule kokuqala iiseli ezimbini, kufuneka ufake yokuqala inani lesibini, oko kwenziwa kumhlathi eye yangaphambili namanani. Kwakhona le meko umtya efanelekileyo uzilungiselele. Emva kokungena kufuneka uqiniseke ukuba ukhanyise iiseli ezimbini. Ukuze ukusombulula ingxaki lokubhengeza kubungakanani bemiqolo zibe Excel, kuya kufuneka ukuba enze ezi zazo. Ngoku ke kufuneka ukuba isalathisi se mouse ukuya kwikona esezantsi ekunene kwaye khetha yonke indawo (ukuba kuya kubakho ababini kuphela), kuza emva kokuba esi senzo kufuneka ukuba ukutshintsha ukusuka isiqabu yesiqhelo plus abamnyama flat. Xa kwenzeka utshintsho olunjalo, kufuneka nqakraza i ekhohlo iqhosha le mouse kwaye tsala umda ukhetho ukuya iseli yokugqibela kunye elinamanani yakho - gxebe, ukuya ezantsi itafile.

ukugqitywa

Wakuba khupha iqhosha le mouse, inkqubo kufuneka ngokuzenzekelayo ukuzalisa amanani cell. Isisombululo zingentla umbuzo lokubhengeza kubungakanani bemiqolo e Excel, Kuyinto elula kakhulu, umzekelo, xa kufuneka baphathwe itafile encinane. Nangona kunjalo, indlela efanayo zingasetyenziswa ukwenza iiprojekthi ezininzi omkhulu. Enkosi ingqalelo yakho.