Ukufihla okuqukethwe kweseli

Ake sithi sinamaseli amaningana, okuqukethwe kwakho esifuna ukukufihla ekubukeni kwesikhashana komuntu esingamazi, ngaphandle kokufihla imigqa noma amakholomu anedatha ngokwawo futhi ngaphandle kokusetha iphasiwedi engakhohlwa. Yebo, ungawafometha ngesitayela "sefonti emhlophe kungemuva elimhlophe", kodwa lokhu akuyona imidlalo, futhi umbala wokugcwalisa wamaseli awuhlali umhlophe. Ngakho-ke, sizohamba ngenye indlela.

Okokuqala, masidale isitayela seseli ngokwezifiso esifihla okuqukethwe kwaso sisebenzisa ifomethi yangokwezifiso. Kuthebhu Ikhaya ohlwini lwezitayela thola isitayela Normal, chofoza kwesokudla kuyo bese ukhetha umyalo okubili:

Ewindini elivela ngemuva kwalokhu, faka noma yiliphi igama lesitayela (ngokwesibonelo secret), susa ukumaka wonke amabhokisi okuhlola ngaphandle kwelokuqala (ukuze isitayela singawashintshi amanye amapharamitha weseli) bese uchofoza Ifomethi:

Kuthebhu ethuthukisiwe Inombolo khetha inketho Wonke amafomethi (ngokwezifiso) bese ungena ensimini Uhlobo amasemikholoni amathathu ngokulandelana ngaphandle kwezikhala:

Vala wonke amawindi ngokuchofoza OK… Sisanda kwenza ifomethi yangokwezifiso ezofihla okuqukethwe kwamaseli akhethiwe futhi izobonakala kuphela kubha yefomula lapho iseli ngalinye likhethiwe:

Isebenza kanjani ngempela

Eqinisweni, yonke into ilula. Noma iyiphi ifomethi yangokwezifiso ingaba nezingcezu zemaski ezi-4 ezihlukaniswa ngama-semicolon, lapho isiqeshana ngasinye sisetshenziswa esimweni esithile:

  1. Eyokuqala iwukuthi uma inombolo kuseli inkulu kunoziro
  2. Okwesibili - uma kuncane
  3. Okwesithathu - uma kunoziro esitokisini
  4. Okwesine – uma kunombhalo kuseli

I-Excel iphatha amasemikholoni amathathu ngokulandelana njengamamaski amane angenalutho kuzo zonke izimo ezine ezingaba khona, okusho ukungabi nalutho kwanoma yiliphi inani leseli. 

  • Ungawakha kanjani amafomethi akho ngokwezifiso (abantu, kg, ama-ruble ayizinkulungwane, njll.)
  • Ungasibeka kanjani isivikelo sephasiwedi kumaseli e-Excel, amashidi nezincwadi zokusebenza

shiya impendulo