Ungawakha kanjani ngokushesha uhlu olunezinombolo ku-Excel

Lapho sihlanganisa amatafula futhi sisebenza njalo ku-Excel, ngokushesha noma kamuva sibhekana nenkinga yokudala uhlu olunezinombolo. Kunezindlela eziningana zokudala, ngayinye ezoxoxwa ngayo ngokuningiliziwe kulesi sihloko.

Indlela yoku-1: Uhlu olunezinombolo ku-Excel kuseli eyodwa

Ngokuvamile kuba nezimo lapho kudingekile ukufaka umaka nokubalwa kohlu kuseli eyodwa. Isidingo esinjalo singase siphakame ngenxa yesikhala esincane sokugcwalisa lonke ulwazi. Inqubo yokubeka ichashazi noma uhlu olunezinombolo kuseli efanayo ngomugqa wokwazisa:

1. Yenza uhlu oluzofakwa izinombolo. Uma ihlanganiswe ngaphambili, khona-ke siqhubeka kwezinye izenzo.

Inothi elivela kuchwepheshe! Ububi bale ndlela ukuthi izinombolo noma omaka bashuthekwa kuseli ngalinye ngokwehlukana.

2. Yenza kusebenze umugqa odinga ukuhlelwa bese usetha i-delimiter phambi kwegama.
3. Iya kuthebhu ethi "Faka" etholakala kunhlokweni yohlelo.

4. Thola iqembu lamathuluzi "Izimpawu" futhi ngokuchofoza umcibisholo, uye efasiteleni elivulekayo. Kuyo, chofoza ithuluzi elithi "Symbol".

5. Okulandelayo, ohlwini olwethuliwe, udinga ukukhetha izinombolo noma umaka owuthandayo, wenze uphawu lusebenze, bese uchofoza inkinobho ethi "Faka".

Indlela #2: Uhlu Olunezinombolo Lwamakholomu Amaningi

Uhlu olunjalo luzobukeka lungokwemvelo, kodwa lufanelekile uma isikhala etafuleni sikuvumela ukuthi ubeke amakholomu amaningana.

1. Kukholomu yokuqala neseli yokuqala, bhala inombolo “1”.
2. Hambisa phezulu kwesibambo sokugcwalisa bese usihudulela ekupheleni kohlu.
3. Ukwenza lula umsebenzi wokugcwalisa, ungachofoza kabili kumaka. Izogcwalisa ngokuzenzakalelayo.

4. Ohlwini olunezinombolo, ungabona ukuthi umaka uphindaphinde inani ledijithali elithi “1” kuyo yonke imigqa. Yini okufanele uyenze kuleli cala? Ukwenza lokhu, ekhoneni elingezansi kwesokudla, ungathola Izinketho Zokugcwalisa Okuzenzakalelayo. Ngokuchofoza isithonjana ekhoneni le-block, uhlu lokudonsela phansi luzovuleka, lapho udinga khona ukukhetha "Gcwalisa".

5. Ngenxa yalokho, uhlu olunezinombolo luzogcwaliswa ngokuzenzekelayo ngesethi yezinombolo ezifanele.

Ukwenza kube lula ukugcwalisa uhlu olunezinombolo, ungasebenzisa enye indlela:

1. Faka izinombolo 1 no-2 kumaseli amabili okuqala ekholomu, ngokulandelana.
2. Khetha wonke amaseli anomaka wokugcwalisa futhi imigqa esele izogcwaliswa ngokuzenzakalelayo.

Inothi lochwepheshe! Ungakhohlwa ukuthi uma ufaka izinombolo, udinga ukusebenzisa ibhulokhi yenombolo ngakwesokudla sekhibhodi. Izinombolo ezingenhla azikufanele ukufaka.

Ungenza futhi umsebenzi ofanayo usebenzisa umsebenzi wokuqedela ngokuzenzakalela: =STRING(). Cabanga ngesibonelo sokugcwalisa imigqa ngohlu olu-odelwe usebenzisa umsebenzi:

1. Yenza kusebenze iseli ephezulu lapho uhlu olunezinombolo luzoqala khona.
2. Kubha yefomula, faka uphawu olulinganayo "=" bese ubhala umsebenzi othi "ROW" ngokwakho noma uwuthole ethuluzini elithi "Faka Umsebenzi".
3. Ekupheleni kwefomula, setha amabakaki okuvula nawokuvala ukuze unqume ngokuzenzakalelayo iyunithi yezinhlamvu.

4. Beka ikhesa kusibambo sokugcwalisa iseli bese usihudulela phansi. Noma gcwalisa amaseli ngokuzenzakalelayo ngokuchofoza kabili. Kungakhathalekile ukuthi iyiphi indlela yokufaka, umphumela uzofana futhi uzogcwalisa uhlu lonke nge-enum yezinombolo ebekwe kahle.

Indlela 3: sebenzisa inqubekelaphambili

Inketho engcono kakhulu yokugcwalisa amatafula amakhulu ngenani elimangalisayo lemigqa:

1. Ukuze uthole izinombolo, sebenzisa ibhulokhi yezinombolo etholakala kwesokudla sekhibhodi. Faka inani “1” kuseli lokuqala.

2. Kuthebhu "Ekhaya" sithola ibhulokhi ethi "Ukuhlela". Ukuchofoza unxantathu kuzovula uhlu lokudonsela phansi. Lapho simisa ukukhetha kwethu kulayini “Ukuqhubeka”.
3. Iwindi lizovuleka lapho, kupharamitha ethi "Indawo", usethe umaka endaweni ethi "Ngokholomu".
4. Kuwindi elifanayo, kupharamitha ethi "Uhlobo", shiya umaka endaweni "ye-Arithmetic". Ngokuvamile, lesi sikhundla sisethwa ngokuzenzakalelayo.
5. Esigabeni samahhala "Isinyathelo" sichaza inani "1".
6. Ukuze unqume inani lomkhawulo, udinga ukubeka endaweni ehambisanayo inombolo yemigqa edinga ukugcwaliswa ngohlu olunezinombolo.

Inothi elivela kuchwepheshe! Uma ungasiqedi isinyathelo sokugcina, bese ushiya inkambu ethi “Limit value” ingenalutho, khona-ke izinombolo ezizenzakalelayo ngeke zenzeke, ngoba uhlelo ngeke lwazi ukuthi mingaki imigqa okufanele igxile kuyo.

Isiphetho

I-athikili yethule izindlela ezintathu eziyinhloko zokwenza uhlu olunezinombolo. Izindlela 1 kanye no-2 zibhekwa njengezithandwa kakhulu. Ngesikhathi esifanayo, ngayinye yazo ilungele ukuxazulula uhlobo oluthile lwemisebenzi.