Ukongeza igama legama lomzobo kwi-Excel

Indlela yoku-1: Ukuhlela ukongezwa ngokuzenzekelayo

Indlela yokuqala yeyona ilula, kuba isekwe kuhlelo lwegama lomzobo ongezelelweyo. Ibonakala kwangoko emva kokudala iigrafu ezithile okanye ezinye iintlobo zezakhiwo, kwaye kuya kuba yimfuneko ukwenza i-pats ezininzi ukuba zitshintshe.

1. Emva kokudala umzobo, cofa kwi "Floaric Point" umgca.



Ukuba emva kokudala umzobo, igama layo alongezwa ngokuzenzekelayo okanye ususwe ngengozi, sebenzisa iindlela ezilandelayo apho ezinye iindlela zichaziwe ngokweenkcukacha.

Indlela yesi-2: Isixhobo "Yongeza into etshathi"

Abasebenzisi abaninzi xa besebenza nge-Excel bajongene nesixhobo esijongene ne "Umyili", ezenzelwe ukuhlengahlengisa imizobo kunye nezinye izinto zokufakwa. Ingasetyenziselwa ukongeza igama elingaphantsi komzuzu.

1. Okokuqala, chaza uyilo ngokwayo ukuze iithebhu ezinoxanduva lokulawula ivele phezulu phezulu.



2. Yiya kwithebhu yomyili.



3. Ekhohlo 'kwi-Floul Walls "ibhloko, apho kufuneka ubhekise kwimenyu eyehlayo" yongeza into ".



4. Hambisa isikhombisi kwinqaku elithi "umzobo wesihloko" kwaye ukhethe enye yeendlela zokukhetha ukukhululeka.



5. Ngoku ubona igama lokubonisa eliqhelekileyo kwaye unokuyihlela ngokutshintsha hayi umbhalo, kodwa ikwayindlela yomboniso wayo.



Le ndlela inye ihambelana negama lezesi, kuphela kwimenyu eyehlayo ye-eyehlayo kufuneka ikhethe enye into, ukuhlela ngakumbi kwenziwa ngendlela efanayo.

Indlela 3: Igama elizenzekelayo

Olu khetho luluncedo ngokukhethekileyo kubasebenzisi abasebenza neetafile apho igama lomzobo libotshelelwe kwigama lekholamu okanye intambo ethile ngamanye amaxesha iyatshintsha. Kule meko, usebenzisa ukusebenza okwakhelwe-ngaphakathi, unokwenza igama lomzobo ozenzekelayo elinikwe isisele kunye nokutshintsha ngokohlela kwalo.

1. Ukuba igama lomzobo alikho kwaphela, sebenzisa ukhetho lwangaphambili ukuze uyilo.



2. Emva koko, qinisekisa ukuhlela, kodwa ungabinayo intsingiselo.



3. Kumgca wokungenisa ifomula, bhala uphawu =, oluya kuthetha ukuqala kwegama elizenzekelayo.



4. Ihlala kuphela ukuze ucofe iselfowuni, igama elifuna ukulunika umzobo ngokwakho. Kumnxeba wokufaka ifomula, utshintsho luya kuvela ngokukhawuleza - cofa iqhosha le-ENTER ukuze ulisebenzise.



5. Jonga ukuba igama legama lomzobo litshintsha njani ngokunyaniseka, lihlela leseli.



Kubalulekile ukuba ubhalisele uphawu = kumtya wokuhlela iifomula, kwaye ungayithintela igama letshathi, kuba i-syntax yeNkqubo ayisebenzi kwaye ibophe i-automation ayisebenzi.