Ukuhlukana komugqa kuseli le-Excel

Ku-Excel, ulwazi kuseli, ngokwezilungiselelo ezijwayelekile, lubekwe emugqeni owodwa. Ngokusobala, ukuboniswa okunjalo kwedatha akulula ngaso sonke isikhathi, futhi ukuguqulwa kwesakhiwo setafula kungase kudingeke. Ake sibone ukuthi ungakwenza kanjani ukuhlukana komugqa ngaphakathi kweseli ye-Excel efanayo.

Izinketho Zokudlulisa

Ngokuvamile, ukuhambisa umbhalo emugqeni omusha, udinga ukucindezela inkinobho Faka. Kodwa ku-Excel, isenzo esinjalo sizosiyisa kuseli etholakala kumugqa ongezansi, okungeyona ngempela esikudingayo. Kodwa kusengenzeka ukubhekana nomsebenzi, futhi ngezindlela eziningana.

Indlela 1: sebenzisa ama-hotkeys

Lolu khetho mhlawumbe luthandwa kakhulu futhi lulula. Okufanele sikwenze ukuthi, kumodi yokuhlela okuqukethwe kweseli, ukuhambisa ikhesa endaweni lapho sidinga ukudlulisa, bese ucindezela inhlanganisela. Alt (kwesokunxele) + Faka.

Lonke ulwazi olwalutholakala ngemva kwekhesa luzothuthelwa emugqeni omusha ngaphakathi kweseli efanayo.

Njengoba manje ingxenye yombhalo itholakala ngezansi, isikhala ngaphambi kokuthi asidingeki (kithi, ngaphambi kwegama elithi "oki") futhi singasuswa. Bese uhlala kuphela ukucindezela ukhiye Fakaukuqedela ukuhlela.

Indlela yesi-2: Enza Ngokwezifiso Ukufometha Kweseli

Indlela engenhla yinhle ngoba thina ngokwethu sikhetha mathupha ukuthi yimaphi amagama esizowadlulisela emgqeni omusha. Kodwa uma lokhu kungabalulekile, khona-ke le nqubo ingaphathiswa uhlelo oluzokwenza yonke into ngokuzenzakalelayo uma okuqukethwe kudlula iseli. Kwalokhu:

1. Chofoza kwesokudla kuseli ofuna ukudlulisa kulo, kumenyu yokuqukethwe evelayo, chofoza umugqa "Ifomethi Yeseli".Futhi, esikhundleni salokho, ungama kuseli oyifunayo bese ucindezela inhlanganisela yezinkinobho Ctrl + 1.
2. Iwindi lefomethi lizovela esikrinini. Lapha sishintshela kuthebhu “Ukuqondanisa”, lapho sivula khona inketho "goqa umbhalo"ngokubheka ibhokisi eliseduze kwalo. Cindezela uma usulungile OK.
3. Ngenxa yalokho, siyabona ukuthi umbhalo kuseli elikhethiwe ushintshiwe.

Qaphela: lapho usebenzisa le ndlela, idatha eboniswayo kuphela iyashintsha. Ngakho-ke, uma ufuna ukugcina ukugoqa kungakhathaliseki ukuthi ububanzi beseli, udinga ukusebenzisa indlela yokuqala.

Futhi, ukufometha kungasetshenziswa kuseli eyodwa noma amaningi ngesikhathi esisodwa. Ukuze wenze lokhu, khetha uhla olufunayo nganoma iyiphi indlela elula, bese uya efasiteleni lokufometha, lapho senza kusebenze ipharamitha oyifunayo.

Indlela yesi-3: sebenzisa umsebenzi othi “CONCATENATE”

Ukugoqa umugqa kungenziwa futhi ngomsebenzi okhethekile.

1. Faka ifomula kuseli elikhethiwe, ngokuvamile elibukeka kanje:

   =CONCATENATE(“Umbhalo1″, CHAR(10),”Umbhalo2”)Nokho, esikhundleni izingxabano "Umbhalo1" и "Umbhalo2" sibhala izinhlamvu ezidingekayo, sigcina izingcaphuno. Cindezela uma usulungile Faka.

2. Njengendlela engenhla, sivula ukudlulisa ngefasitela lokufometha.
3. Sithola umphumela onjalo.

Qaphela: esikhundleni samanani athile kufomula, ungacacisa izinkomba zeseli. Lokhu kuzokuvumela ukuthi uhlanganise umbhalo njengomakhi ovela kuzakhi eziningana, futhi kuyizimo ezinjalo ukuthi le ndlela ivame ukusetshenziswa.

Isiphetho

Ngakho, kuthebula le-Excel, kunezindlela ezimbalwa ongazisebenzisa ongasonga umbhalo emugqeni omusha ngaphakathi kweseli efanayo. Inketho elula ukusebenzisa okhiye abakhethekile ukwenza isenzo esidingekayo mathupha. Ngaphezu kwalokho, kukhona nesilungiselelo esikuvumela ukuthi udlulise idatha ngokuzenzakalelayo kuye ngobubanzi beseli, kanye nomsebenzi okhethekile ongavamile ukusetshenziswa, kodwa kwezinye izimo kungase kudingeke.