Okuqukethwe
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.
Isixazululo 1: Nika amandla Isiboniso kuRibhoni
Ngokuvamile, ukungabikho kwebha yefomula kuwumphumela weqiniso lokuthi uphawu lokuhlola olukhethekile lususiwe kuzilungiselelo zeribhoni yohlelo. Nakhu esikwenzayo kuleli cala:
- Shintshela kuthebhu "Buka". Lapha eqenjini lamathuluzi Bonisa maka ibhokisi eduze kwenketho "Ibha Yefomula" (uma kungafaneleki).
- Ngenxa yalokho, ibha yefomula izophinda ivele efasiteleni lohlelo.
Isixazululo 2: Ukwenza izinguquko kuzilungiselelo
Ibha yefomula nayo ingavalwa ezinhlelweni zohlelo. Ungayivula futhi usebenzisa indlela echazwe ngenhla, noma usebenzise uhlelo lokusebenza olungezansi:
- Vula imenyu "Fayela".
- Efasiteleni elivulekayo, ohlwini olungakwesokunxele, chofoza ingxenye "Amapharamitha".
- 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.
- 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:
- Vula Iphaneli yokulawula nganoma iyiphi indlela elula, isibonelo, ngokusebenzisa Ibha yokusesha.
- Ngemva kokuhlela ukubuka ngendlela yezithonjana ezinkulu noma ezincane, hamba esigabeni "Izinhlelo Nezici".
- Ewindini lokukhipha nokuguqula izinhlelo, thola futhi umake umugqa "I-Microsoft Office" (noma "Microsoft Excel"), bese uchofoza inkinobho "Shintsha" enhlokweni yohlu.
- Ngemva kokuqinisekisa izinguquko, iwindi lokubuyisela uhlelo lizoqala. Ezimweni eziningi, izinkinga zingaxazululwa nge “Ukululama Ngokushesha” (ngaphandle kokuxhuma kunethiwekhi), ngakho-ke, ukuyishiya, cindezela inkinobho “Yenza kabusha”.Qaphela: Inketho yesibili "Ukutholwa Kwenethiwekhi" kudinga isikhathi esengeziwe, futhi kufanele kukhethwe uma indlela yokuqala ingazange isize.
- 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.