Ngokuvamile, ungathola isidingo sokumboza amanani angu-zero olwazini lwakho futhi wethule amaseli ngamanani angu-zero njengamaseli ahlanzekile. Ngezansi ungabona amasu ahlukene okufihla ama-zero ku-Excel.
Fihla amaziro ku-Excel
Ngaphambi kokulandela izinyathelo zokufihla oziro ku-Excel, udinga ukuqonda umehluko phakathi kokufihla oziro nokuqeda oziro ku-Excel.
Uma ufihla o-zero ku-Excel, ufihla kuphela ulwazi lwamaseli aqukethe amanani ayiziro, amaseli asagcina ulwazi lwamanani ayiziro.
Lokhu kusho ukuthi ulwazi (ivelu enguziro) yeseli kufanele lucatshangelwe kuzo zonke izibalo nokwakheka.
Uma kuqhathaniswa, lapho ukhipha ama-zero esihlokweni sokubika ku-Excel, iseli lishiywa lihlanzekile futhi izinzuzo zalo azinakwa ekwakhiweni nasekubalweni.
Uma lokhu sekuqondisiwe, ake sihlole amasu ahlukene okufihla oziro ku-Excel.
1. Fihla oziro ngokwerobhothi ku-Excel
Landela lezi zinyathelo ezingezansi ukuze ufihle ama-zero ku-Excel.
1. Vula ifayela lespredishithi le-Excel lapho kufanele umboze khona o-zero bese uchofoza ithebhu ethi Ifayela.
2. Kumenyu ethi Ifayela, skrola uye phansi bese uchofoza okuthi Khetha.
3. Esikrinini se-Excel Options, chofoza Ikhaya kufasitelana lesobunxele. Kufasitelana lesokudla, skrola uye esigabeni esithi "Bonisa izinketho zaleli phepha lokusebenzela" > khetha isithonjana sephepha lokusebenzela lapho udinga ukumboza khona amanani angu-zero bese ususa ukumaka " Bonisa u-zero kumaseli anenani elingu-zero ."
5. Chofoza u-Kulungile ukuze ulondoloze eziningi zalezi zilungiselelo kuspredishithi.
Uma uchofoza okuthi KULUNGILE, wonke amaseli e-Knowledge Topic anoziro azovela esuliwe.
2. Fihla oziro ku-Excel usebenzisa ukufometha okunemibandela
Indlela yokusebenza engenhla ifihla amanani aziro kuso sonke isipredishithi futhi ayikwazi ukusetshenziselwa ukufihla oziro ekuhlukeni okukhethiwe kolwazi.
Uma ufuna ukufihla amaziro olwazini oluthile, kufanele usebenzise ukufometha okunemibandela.
1. Khetha ingxenye yolwazi lapho kufanele ufihle khona amanani angenalutho.
2. Cindezela ithebhu ethi Ikhaya > Ukufometha Okunemibandela > Gqamisa Iziqondiso Zeseli bese uchofoza ku- Equal to chance.
3. Ebhokisini lengxoxo elithi "Equal to", faka u-0 ensimini yesobunxele. Ensimini yesokudla, khetha inketho ethi Custom Format bese uchofoza u- OK.
4. Esikrinini esithi Amaseli Okufometha, khetha ithebhu ethi Ifonti > sebenzisa i- Coloring Process bese ukhetha umbala omhlophe.
5. Chofoza u-Kulungile ukuze ulondoloze ingxenye enkulu yale pharamitha.
Indlela yokusebenza engenhla ifihla oziro ku-Excel ngokushintsha umthunzi wefonti wamaseli anamaqanda abe mhlophe, inikeze lawa maseli ukubukeka okuhlanzekile.
3. Fihla oziro ku-Excel ngomthunzi ongemuva
Indlela engenhla yokufihla oziro ku-Excel ngokushintsha umbala wefonti ube mhlophe ayisebenzi uma amaseli espredishithi enombala wangemuva.
Uma unespredishithi esinengemuva elinomthunzi, ungaqhubeka nokumboza amanani ayiziro ngokulandela izinyathelo ezingezansi.
1. Khetha ingxenye yolwazi lapho kufanele ufihle khona amanani angenalutho.
2. Cindezela ithebhu ethi Ikhaya > Ukufometha Okunemibandela > Gqamisa Iziqondiso Zeseli bese uchofoza ku- Equal to chance.
3. Ebhokisini lengxoxo elithi "Equal to", faka u-0 ensimini yesobunxele. Ensimini yesokudla, khetha inketho ethi Custom Format bese uchofoza u- OK.
4. Ku-"Fometha Amaseli", chofoza inkinobho ethi " Fometha Inani Lamaseli" bese ukhetha i-Custom kuphaneli yesobunxele. Kuphaneli yesokudla, faka ;; ; (ama-semicolon angu-3) ku-"Type" field bese uchofoza u- OK.
Njalo uma usebenzisa i- ;; ; (ama-semicolon angu-3) ku-Excel, ifihla wonke amanani ezinombolo nombhalo kumaseli lapho kusetshenziswa khona le fomethi.
Kulesi simo, sisebenzisa ukufometha okunemibandela ukuze sisebenzise ukufometha kwekholomu engu-3 kuphela kumaseli aqukethe amanani angu-0.
- Izindlela Ezilula Zokufihla Amaseli, Imigqa, namakholomu ku-Excel
- Izindlela Ezilula Zokufihla Ifomula ku-Excel
Igama lami ngingu-Javier Chirinos futhi ngizifela ngobuchwepheshe. Kusukela kudala, ngangithanda ama-computer nemidlalo ye-video futhi leyo nto yokuzilibazisa yagcina isiwumsebenzi.
Bengilokhu ngishicilela mayelana nobuchwepheshe namagajethi ku-inthanethi iminyaka engaphezu kwe-15, ikakhulukazi ku- mundobytesPlay
Ngiphinde ngibe uchwepheshe kwezokuxhumana kanye nokumaketha ku-inthanethi futhi nginolwazi lokuthuthukiswa kwe-WordPress.