Ungayifihla kanjani ifomula ku-Excel

Kwesinye isikhathi, lapho kudala idokhumenti ngezibalo, umsebenzisi udinga ukufihla amafomula avela kwamehlo angaphandle. Okokuqala, isidingo esinjalo sibangelwa ukungabaza komsebenzisi, ukuze umuntu ongamaziyo aqonde ukwakheka kwedokhumenti. Uhlelo lwe-Excel lunethuba lokufihla amafomula. Sizoqonda ukuthi lokhu kungenziwa kanjani ngezindlela ezahlukahlukene.

Izindlela zokufihla ifomula

Akuyona imfihlo ukuthi uma kukhona ifomula etafuleni le-Excel, ingabonakala efomula emugqeni ngokugqamisa leli cell. Kwezinye izimo, lokhu kuyinto engathandeki. Isibonelo, uma umsebenzisi efuna ukufihla imininingwane ngesakhiwo sekhompyutha noma umane angafuni lezi zibalo zishintshe. Kulokhu, isenzo esinengqondo sizofihla umsebenzi.

Kunezindlela ezimbili eziphambili zokwenza. Owokuqala kubo yisikhuphu sokuqukethwe kweseli, indlela yesibili inamandla amakhulu. Lapho uyisebenzisa, ukuvinjelwa kokukhethwa kwamaseli kuyabekwa.

Indlela 1: Ukucasha okuqukethwe

Le ndlela ihambelana kahle nemisebenzi elethwa kulesi sihloko. Lapho uyisebenzisa, okuqukethwe kuphela kwamangqamuzana afihliwe, kepha akukho mikhawulo eyengeziwe ebekiwe.

1. Sigqamisa ibanga, okuqukethwe okudingeka ukukufihle. Qhafaza kwesokudla endaweni ekhethiwe. Imenyu yomongo iyavula. Khetha into "yefomethi yefomethi". Ungenza ngendlela ehlukile. Ngemuva kokukhetha uhla, mane ushayele izinkinobho ze-CTRL + 1 kwikhibhodi. Umphumela uzofana.



2. Iwindi le- "Cell format" livula. Iya kuthebhu ethi "Vikela". Faka umkhaza eduze kwento "Fihla amafomula". Thikha i-parameter "yeseli evikelwe" ingasuswa uma ungahleleli ukuvimba ibanga kusuka kuzinguquko. Kepha, ikakhulukazi, ukuvikelwa ezinguquko kuwumsebenzi ophambili kuphela, futhi ukucasha kwamafomula kuyakhethwa. Ngakho-ke, ezimweni eziningi, zombili izinkomithi zishiywe zisebenza. Chofoza inkinobho ethi "KULUNGILE".



3. Ngemuva kokuthi iwindi livaliwe, iya kuthebhu ethi "Ukubuyekezwa". Sichofoza inkinobho ethi "Vikela ishidi" etholakala "Tool Tool" block ethepheni.
4. Kuvulwa iwindi, emkhakheni wawo ofuna ukungena kuwo iphasiwedi yokuphikisana. Kuzothatha uma ufuna ukususa ukuvikela ngokuzayo. Zonke ezinye izilungiselelo zinconyelwa ukushiya okuzenzakalelayo. Ngemuva kwalokho kufanele uchofoze inkinobho ethi "Kulungile".



5. Elinye iwindi livuleka, lapho iphasiwedi efakwe ngaphambili kufanele iphinde idale kabusha. Lokhu kwenziwa ukuqinisekisa ukuthi umsebenzisi, ngenxa yokwethulwa kwephasiwedi engalungile (ngokwesibonelo, ekwakhekeni okulungisiwe), akazange alahlekelwe ukufinyelela kushintsho lwephepha. Futhi, ngemuva kokufaka inkulumo esemqoka, cindezela inkinobho ethi "Kulungile".

Ngemuva kwalezenzo, amafomula azofihlwa. Emigqeni yamafomula webanga elivikelwe, ngesikhathi sabelo sawo, akukho okuzokhonjiswa.

Indlela 2: Ukuvinjwa kokukhethwa kwamaseli

Le yindlela emnandi kakhulu. Uhlelo lwayo lubeka ukuvalwa okungekho kuphela ukubuka amafomula noma ukuhlela amaseli, kepha ngisho nasekwabiweni kwawo.

1. Okokuqala, udinga ukuhlola ukuthi bhokisi efakwe eduze "Cell Okuvikelwe" ipharamitha ku "Ukuvikelwa" ithebhu senhlobo ngaphambilini siwazi ka esikhethiwe. Ngokuzenzakalelayo, le ngxenye kwakufanele ivulwe, kepha ayivimbi isimo sayo. Uma kusesindimeni lesi sigaba asikho uphawu lokuhlola, khona-ke kufanele kubekwe. Uma konke kuhamba kahle, futhi kufakiwe, bese ucindezela inkinobho ethi "Kulungile" etholakala ezansi kwewindi.



2. Ngaphezu kwalokho, njengasesimweni esedlule, sichofoza inkinobho ethi "Vikela Ishidi" etholakala kuthebhu yokubuyekezwa.
3. Ngokufanayo, iwindi lesingeniso se-password livula ngendlela edlule. Kepha kulokhu sidinga ukususa ibhokisi lokuhlola kusuka ku- "Ukwabiwa kwamaseli avinjelwe" ipharamitha. Ngakho-ke, sizokwenqabela ukwenziwa kwale nqubo ebangeni elizinikezele. Ngemuva kwalokho, faka iphasiwedi bese uqhafaza inkinobho ethi "Kulungile".



4. Ewindi elilandelayo, njengoba okokugcina, phinda iphasiwedi bese uqhafaza inkinobho ethi "Kulungile".

Manje, engxenyeni ekhethwe ngaphambilini yeshidi, ngeke nje sikwazi ukubuka okuqukethwe yimisebenzi kumaseli, kodwa ngisho nokumane kubenzele. Lapho uzama ukwenza ukukhetha, umlayezo uzovela ukuthi uhla luvikelekile ezinguquko.

Ngakho-ke, sathola ukuthi kucisha ukubonisa imisebenzi emugqeni wefomula futhi ngqo esitokisini ngezindlela ezimbili. Ngokuqukethwe okujwayelekile kokufihla, amafomula kuphela afihliwe, njengesici esingeziwe, ungabeka ukunqatshelwa kokuhlelwa kwazo. Indlela yesibili isho khona ubukhona bokwenqatshelwa okuqinile. Lapho isetshenziswa, ivinjiwe nje ikhono ukuze ubuke okuqukethwe noma ukuhlela yayo, kodwa ngisho Ukukhetha esitokisini. Yikuphi ezimbili lezi ongakhetha kuncike, okokuqala kunakho konke, kusukela imisebenzi isethi. Kodwa-ke, ezimweni eziningi, inketho yokuqala iqinisekisa izinga lokuvikelwa okwethembekile okwethembekile, futhi ukuvimba kokukhipha kuvame ukuba yisilinganiso sokuqapha ngokweqile.