Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3

Ngenkathi usebenza ku-Excel, akuvamile ukuthi udinge izinombolo zomugqa kukholamu ehlukile. Lokhu kungenziwa ngokufaka izinombolo ze-serial mathupha, ngamanye amazwi, ngokuzibhala kukhibhodi. Kodwa-ke, lapho usebenza ngenani elikhulu lolwazi, ukufaka izinombolo ngesandla akuyona inqubo emnandi kakhulu futhi esheshayo, lapho, ngaphezu kwalokho, amaphutha nama-typos angenziwa. Ngenhlanhla, i-Excel ikuvumela ukuthi wenze le nqubo ngokuzenzakalelayo, futhi ngezansi sizobheka ukuthi lokhu kungenziwa kanjani ngezindlela ezahlukahlukene.

Okuqukethwe

Indlela 1: Ukubala Ngemva Kokugcwalisa Imigqa Yokuqala

Le ndlela mhlawumbe ilula kakhulu. Lapho uyisebenzisa, udinga kuphela ukugcwalisa imigqa emibili yokuqala yekholomu, ngemva kwalokho ungakwazi ukwelula izinombolo emigqeni esele. Nokho, kuwusizo kuphela lapho usebenza namatafula amancane.

  1. Okokuqala, dala ikholomu entsha yezinombolo zomugqa. Esitokisini sokuqala (singabali unhlokweni) sibhala inombolo 1, bese siya kweyesibili, lapho sifaka khona inombolo yesi-2.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  2. Manje udinga ukukhetha lawa maseli amabili, emva kwalokho sihambisa ikhesa yegundane ekhoneni elingezansi kwesokudla lendawo ekhethiwe. Lapho nje isikhombisi sishintsha ukubukeka kwaso sibe isiphambano, cindezela inkinobho yegundane kwesokunxele bese usihudulela emugqeni wokugcina wekholomu.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  3. Sikhulula inkinobho yegundane engakwesokunxele, futhi izinombolo ze-serial zemigqa zizovela ngokushesha emigqeni esiyimbozile lapho sinwetshwa.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3

Indlela 2: STRING opharetha

Le ndlela yokufaka izinombolo zomugqa othomathikhi ihlanganisa ukusetshenziswa komsebenzi "ULayini".

  1. Sikhuphukela kuseli lokuqala lekholomu, esifuna ukuyinikeza inombolo ye-serial 1. Bese sibhala ifomula elandelayo kuyo: =СТРОКА(A1).Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  2. Ngokushesha nje lapho sichofoza Faka, inombolo yomkhiqizo izovela kuseli ekhethiwe. Kuhlala, ngokufanayo nendlela yokuqala, ukwelula ifomula emigqeni engezansi. Kodwa manje udinga ukuhambisa ikhesa yegundane uye ekhoneni elingezansi kwesokudla seseli ngefomula.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  3. Konke sekumi ngomumo, siye sabala ngokuzenzakalelayo yonke imigqa yetafula, okwakudingeka.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3

Esikhundleni sokufaka ifomula mathupha, ungasebenzisa Iwizadi Yomsebenzi.

  1. Siphinde sikhethe iseli yokuqala yekholomu lapho sifuna ukufaka khona inombolo. Bese sichofoza inkinobho "Faka umsebenzi" (ngakwesokunxele kwebha yefomula).Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  2. Iwindi le-Function Wizard liyavuleka. Chofoza esigabeni samanje semisebenzi bese ukhetha ohlwini oluvulayo "Amareferensi kanye ne-Arrays".Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  3. Manje, ohlwini lwama-opharetha ahlongozwayo, khetha umsebenzi "ULayini", bese ucindezela OK.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  4. Iwindi lizovela esikrinini elinezimpikiswano zomsebenzi okufanele zigcwaliswe. Chofoza indawo yokufaka ukuze uthole ipharamitha "Umugqa" futhi ucacise ikheli leseli yokuqala kukholomu esifuna ukwabela yona inombolo. Ikheli lingafakwa ngesandla noma umane uchofoze kuseli oyifunayo. Chofoza okulandelayo OK.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  5. Inombolo yomugqa ifakwa kuseli ekhethiwe. Indlela yokwelula izinombolo kuyo yonke imigqa, sixoxile ngenhla.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3

Indlela yesi-3: ukusebenzisa inqubekelaphambili

Ububi bezindlela zokuqala nezesibili ukuthi kufanele welule izinombolo kweminye imigqa, engafaneleki kakhulu kumasayizi amakhulu wetafula aqondile. Ngakho-ke, ake sibheke enye indlela eqeda isidingo sokwenza isenzo esinjalo.

  1. Sibonisa kuseli lokuqala lekholomu inombolo yayo yochungechunge, elingana nenombolo 1.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  2. Shintshela kuthebhu "Ikhaya", cindezela inkinobho "Gcwalisa" (isigaba “Ukuhlela”) futhi ohlwini oluvulayo, chofoza inketho “Inqubekelaphambili…”.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  3. Iwindi lizovela phambi kwethu elinamapharamitha wokuqhubeka adinga ukulungiswa, ngemva kwalokho sicindezela OK.
    • khetha ukuhlelwa “ngamakholomu”;
    • cacisa uhlobo "i-arithmetic";
    • kwinani lesinyathelo sibhala inombolo "1";
    • kunkambu ethi “Inani elilinganiselwe”, bonisa inombolo yemigqa yethebula okudingeka ibalwe.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  4. Ukufakwa kwezinombolo komugqa okuzenzakalelayo kwenziwa, futhi sithole umphumela esiwufunayo.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3

Le ndlela ingenziwa ngendlela ehlukile.

  1. Siphinda isinyathelo sokuqala, okungukuthi Bhala inombolo 1 kuseli lokuqala lekholomu.
  2. Sikhetha ububanzi obuhlanganisa wonke amaseli esifuna ukufaka kuwo izinombolo.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  3. Ukuvula iwindi futhi "Intuthuko". Amapharamitha ahlelwa ngokuzenzakalelayo ngokuya ngebanga esilikhethile, ngakho kufanele sichofoze OK.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3
  4. Futhi futhi, ngenxa yalezi zenzo ezilula, sithola izinombolo zemigqa ebangeni elikhethiwe.Izinombolo zerowu ezizenzakalelayo ku-Excel: izindlela ezi-3

Ukufaneleka kwale ndlela ukuthi awudingi ukubala nokubhala inombolo yemigqa ofuna ukufaka kuyo izinombolo. Futhi okubi ukuthi, njengasezindleleni zokuqala nezesibili, kuzodingeka ukhethe uhla lwamaseli kusengaphambili, olungelula kangako lapho usebenza namatafula amakhulu.

Isiphetho

Izinombolo zomugqa zingenza kube lula kakhulu ukusebenza ku-Excel lapho usebenza nenani elikhulu ledatha. Kungenziwa ngezindlela eziningi, kusukela ekugcwaliseni okwenziwa ngesandla kuya ohlelweni oluzenzakalelayo oluzoqeda noma yimaphi amaphutha angenzeka kanye nama-typos.

shiya impendulo