Okufanele ukwenze uma ibha yefomula ku-Excel inyamalele

Ku-interface yohlelo lwe-Excel, enye yezindawo ezibalulekile ithathwa yibha yefomula, ekuvumela ukuthi ubuke futhi uguqule okuqukethwe kwamaseli. Futhi, uma iseli liqukethe ifomula, izobonisa umphumela wokugcina, futhi ifomula ingabonakala kumugqa ongenhla. Ngakho, ukuba usizo kwaleli thuluzi kusobala.

Kwezinye izimo, abasebenzisi bangathola ukuthi ibha yefomula inyamalele. Kulesi sihloko, sizobheka ukuthi singayibuyisela kanjani endaweni yayo, kanye nokuthi kungani lokhu kungenzeka.

Okuqukethwe

Isixazululo 1: Nika amandla Isiboniso kuRibhoni

Ngokuvamile, ukungabikho kwebha yefomula kuwumphumela weqiniso lokuthi uphawu lokuhlola olukhethekile lususiwe kuzilungiselelo zeribhoni yohlelo. Nakhu esikwenzayo kuleli cala:

  1. Shintshela kuthebhu "Buka". Lapha eqenjini lamathuluzi Bonisa maka ibhokisi eduze kwenketho "Ibha Yefomula" (uma kungafaneleki).Okufanele ukwenze uma ibha yefomula ku-Excel inyamalele
  2. Ngenxa yalokho, ibha yefomula izophinda ivele efasiteleni lohlelo.Okufanele ukwenze uma ibha yefomula ku-Excel inyamalele

Isixazululo 2: Ukwenza izinguquko kuzilungiselelo

Ibha yefomula nayo ingavalwa ezinhlelweni zohlelo. Ungayivula futhi usebenzisa indlela echazwe ngenhla, noma usebenzise uhlelo lokusebenza olungezansi:

  1. Vula imenyu "Fayela".Okufanele ukwenze uma ibha yefomula ku-Excel inyamalele
  2. Efasiteleni elivulekayo, ohlwini olungakwesokunxele, chofoza ingxenye "Amapharamitha".Okufanele ukwenze uma ibha yefomula ku-Excel inyamalele
  3. Kumapharamitha, shintshela esigatshaneni “Okwengeziwe”. Engxenyeni eyinhloko yewindi elingakwesokudla, skrola kokuqukethwe size sithole ibhulokhi yamathuluzi Bonisa (ezinguqulweni zangaphambili zohlelo, iqembu lingase libe negama "Isikrini"). Ukuthola inketho "Bonisa ibha yefomula", beka uphawu phambi kwayo bese uqinisekisa ushintsho ngokucindezela inkinobho OK.Okufanele ukwenze uma ibha yefomula ku-Excel inyamalele
  4. Njengendlela okuxoxwe ngayo ngaphambili yokuxazulula inkinga, ulayini uzobuyela endaweni yawo.

Isixazululo 3: Buyisela uhlelo

Kwezinye izimo, ibha yefomula iyeka ukubonakala ngenxa yamaphutha noma ukuphahlazeka kohlelo. Ukubuyiselwa kwe-Excel kungasiza kulesi simo. Sicela wazi ukuthi lezi zinyathelo ezingezansi ezeWindows 10, noma kunjalo, ezinguqulweni zangaphambili zesistimu yokusebenza, zicishe zifane:

  1. Vula Iphaneli yokulawula nganoma iyiphi indlela elula, isibonelo, ngokusebenzisa Ibha yokusesha.Okufanele ukwenze uma ibha yefomula ku-Excel inyamalele
  2. Ngemva kokuhlela ukubuka ngendlela yezithonjana ezinkulu noma ezincane, hamba esigabeni "Izinhlelo Nezici".Okufanele ukwenze uma ibha yefomula ku-Excel inyamalele
  3. Ewindini lokukhipha nokuguqula izinhlelo, thola futhi umake umugqa "I-Microsoft Office" (noma "Microsoft Excel"), bese uchofoza inkinobho "Shintsha" enhlokweni yohlu.Okufanele ukwenze uma ibha yefomula ku-Excel inyamalele
  4. Ngemva kokuqinisekisa izinguquko, iwindi lokubuyisela uhlelo lizoqala. Ezimweni eziningi, izinkinga zingaxazululwa nge “Ukululama Ngokushesha” (ngaphandle kokuxhuma kunethiwekhi), ngakho-ke, ukuyishiya, cindezela inkinobho “Yenza kabusha”.Okufanele ukwenze uma ibha yefomula ku-Excel inyamaleleQaphela: Inketho yesibili "Ukutholwa Kwenethiwekhi" kudinga isikhathi esengeziwe, futhi kufanele kukhethwe uma indlela yokuqala ingazange isize.
  5. Ukubuyiselwa kwezinhlelo ezifakwe kumkhiqizo okhethiwe kuzoqala "I-Microsoft Office". Ngemuva kokuthi inqubo isiqede ngempumelelo, udaba lwebha yefomula kufanele luxazululwe.

Isiphetho

Ngakho-ke, akufanele ukhathazeke uma ngokuzumayo ibha yefomula inyamalala ku-Excel. Kungenzeka ukuthi imane ivaliwe kuzilungiselelo ezikuribhoni noma kuzinketho zohlelo. Ungayivula ngokuchofoza okumbalwa nje. Ezimweni ezingavamile, kufanele usebenzise inqubo yokubuyisela uhlelo.

shiya impendulo