Ngokuvelisa ukubalwa okwahlukeneyo kwi-Excel, abasebenzisi abasoloko becinga ukuba amaxabiso aboniswe kwiiseli ngamanye amaxesha akayilungisi naleyo isetyenziswa yile nkqubo ibale ukubala. Oku kuyinyani ngakumbi ngamaxabiso aqhekekileyo. Umzekelo, ukuba unemiqondiso yenani, ebonisa inani elinemiqondiso emibini ye-decimal, oko akuthethi ukuba i-Excel iyona nedatha kwaye ikholelwa. Hayi, ngokungagqibekanga, le nkqubo ibalwa ukubala iindawo ezili-14, nokuba ngabalinganiswa ababini kuphela ababoniswa kwiseli. Le nyaniso ngamanye amaxesha inokukhokelela kwimiphumo engathandekiyo. Ukusombulula le ngxaki, setha ukungqinisisa ukujikeleziswa ngokujikelezayo kwisikrini.
Ukuseta ngokujikeleza njengesikrini
Kodwa ngaphambi kokutshintsha useto, kufuneka ufumanise ukuba ufuna ngokwenene ukubandakanya ukuchaneka njengakwisikrini. Ewe, kwezinye iimeko, xa inani elikhulu lamanani lisetyenziswa ngeempawu zomfanekiso, isiphumo esikhawulezayo xa kubalwa, esiya kunciphisa ukuchaneka okubanzi kwezibalo. Ke ngoko, ngaphandle kwesidingo esingeyomfuneko kwesi sicwangciso kungcono hayi ukuphoxwa gadalala.
Faka ukuchaneka okwesikrinini, kufuneka kwiimeko zesicwangciso esilandelayo. Umzekelo, unomsebenzi wokusonga amanani amabini 4.41 no-4.34, kodwa iimeko eziyimfuneko kukuba umqondiso wokugqibela we-decimal uboniswe kwiphepha. Emva kokuba senze ukufotwa okufanelekileyo kweeseli, amaxabiso akwi-4.4 no-4.3 aboniswe kwiphepha, kodwa ngokongezwa, le nkqubo ibonakalisa inani 4.7 Ngenxa ye-4.8.
Oku kungenxa yenyani yokuba kuyinyani ukubala i-Excel iyaqhubeka nokuthatha iNumeri 4.41 no-4.34. Emva kokubalwa, isiphumo ngu-4.75. Kodwa, kuba sicelwe ekufomethani umboniso wamanani kunye nomqondiso omnye wokugqibela, emva koko inani le-4.8 liyaboniswa kwiseli. Ke ngoko, kudala imbonakalo yokuba le nkqubo yenze impazamo (nangona ingabikho njalo). Kodwa kwitikiti eprintiweyo, intetho enjalo ngu-4.4 + 4.3 = 8.8 iya kuba yimpazamo. Ke, kule meko, iziphumo ezisisiseko ngokupheleleyo ziya kubandakanya ukuseta ngokuchanekileyo nakwisikrini. Emva koko i-Excel iya kubalwa ngaphandle kokuthathela ingqalelo la manani ukuba inkqubo ibambene nememori, kwaye ngokwexabiso eliboniswe kwiseli.
Ukuze ufumane ixabiso lokwenyani lenombolo ethatha ukubala i-Excel, kufuneka ubalule iseli apho iqulathe khona. Emva koko, kwi-formular yomtya, ixabiso laso liyaboniswa, eligcinwe kwimemori ye-Excel.
Isifundo: Ukujikeleza amanani e-Excel
Ukwenza ukuba senze useto oluyimfuneko njengesikrini kwiinguqulelo zanamhlanje ze-Excel
Ngoku masifumanise indlela yokwenza ukuchaneka okwethutyana kwiscreen. Okokuqala, cinga ngendlela yokwenza oku kumzekelo weMicrosoft Excel ka-2010 kunye neenguqulelo zayo kamva. Banento efanayo ngendlela efanayo. Kwaye emva koko funda indlela yokuqhuba ukuchaneka njengakwisikrini e-Excel 2007 kunye ne-Excel 2003.
- Yiya kwi "Ifayile" yethebhu.
- Kwifestile evula, cofa iqhosha elithi "Parameter".
- Ifestile yeparamitha yokhetho iqalile. Siyafudukela kwicandelo "elikhawulezayo", igama laso kuluhlu kwicala lasekhohlo lefestile.
- Emva kokufudukela kwicandelo "Advanced", siye kwinxalenye yasekunene yefestile apho izicwangciso zenkqubo zikhona. Fumana ibhloko yeesetingi "xa kuphinda ucinge le ncwadi". Faka ibhokisi yokukhangela kufutshane ne "Ukuchaneka kwi-screen" parameter.
- Emva koko, ibhokisi yencoko yababini iyavela, ethi ichaze ukuba ukubala kwezibalo kuya kuncitshiswa. Cofa kwiqhosha "Kulungile".
Emva koko, kwinkqubo ye-Excel ka-2010 kwaye ngaphezulu kuya kubandakanywa "ukuchaneka kwimowudi" yescreen.
Ukukhubaza le ndlela, kufuneka ususe ibhokisi yokukhangela kwifestile yeparamitha kufutshane neseto "Beka ukuchaneka kwesikrini", emva koko ucofe iqhosha u "Kulungile" emazantsi efestile.
Ukwenza ilungiselelo lokuchaneka okwesikrini kwi-Excel 2007 kunye ne-Excel 2003
Ngoku makhe siqwalasele ngokufutshane indlela imowudi yokuchazela ijika ngayo kwisikrini e-Excel 2007 kwaye e-Excel 2003. Ezi ziinguqulelo zithathwa njengeziphelelwe lixesha.
Okokuqala, cinga ngendlela yokwenza imo ye-Excel 2007.
- Cofa kwi-Ofisi yeOfisi ye-Microsoft kwikona ephezulu yefestile. Kuluhlu oluvelayo, khetha useto lwe-Excel.
- Kwifestile evula, khetha "ukhetho". Kwicala lasekunene lefestile kwiqela leseto "Xa uphinda-phinda le ncwadi", sibeka i-tick kufutshane ne "isethiwe njenge parameter" yeparameter.
Imowudi yokuchaneka njengoko kwiscreen siya kufakwa.
Kwinguqulelo ye-Excel 2003, inkqubo yokufakwa kolawulo olifunayo yahlukile nangaphezulu.
- Kwimenyu ethe tyaba, cofa kwinkonzo yenkonzo. Kuluhlu oluvula, khetha indawo "yeParameter".
- Ifestile yeparamitha iqala. Kuyo, yiya "ngokubala" ithebhu. Okulandelayo, faka i-tick kufutshane nenqaku "ukuchaneka kwiscreen" kwaye ucofe iqhosha u "Kulungile" emazantsi efestile.
Njengoko ubona, setha imowudi yokuchazela njengoko kwiscreen se-Excel silula kakhulu ngaphandle kwenguqulo yenkqubo. Eyona nto iphambili ekuqinisekiseni ukuba kufanelekile ukuba uqhubekele le ndlela okanye ungabi.