Indlela yokwenza ipharagrafu kuseli ye-excel

Kwesinye isikhathi abasebenzisi be-Microsoft Office Excel badinga ukubhala imigqa eminingana yombhalo kuseli eyodwa yohlu lwethebula ngesikhathi esisodwa, ngaleyo ndlela benze isigaba. Lokhu kungenzeka ku-Excel kungenziwa ngezindlela eziningi kusetshenziswa amathuluzi ohlelo ajwayelekile. Indlela yokwengeza isigaba esitokisini etafuleni le-MS Excel kuzoxoxwa ngakho kulesi sihloko.

Izindlela zokusonga umbhalo kumaseli wethebula

Ku-Excel, awukwazi ukwenza isigaba ngokucindezela inkinobho ethi “Enter” ekwikhibhodi yekhompyutha, njengaku-Word. Lapha kudingeka sisebenzise ezinye izindlela. Kusazoxoxwa ngakho.

Indlela 1: Goqa umbhalo usebenzisa amathuluzi okuqondanisa

Umbhalo omkhulu kakhulu ngeke ulingane ngokuphelele kuseli elilodwa lohlu lwethebula, ngakho-ke kuzodingeka uhanjiswe komunye umugqa wento efanayo. Indlela elula yokufeza umsebenzi ihlukaniswe ngezinyathelo ezilandelayo:

1. Sebenzisa inkinobho yegundane kwesokunxele ukuze ukhethe iseli ofuna ukwenza indima kuyo.

2. Hambisa kuthebhu "Ekhaya", etholakala kubha yamathuluzi ephezulu kumenyu yohlelo oluyinhloko.
3. Esigabeni esithi "Ukuqondanisa", chofoza inkinobho "Ukugoqa Umbhalo".

4. Hlola umphumela. Ngemva kokwenza izinyathelo zangaphambilini, usayizi weseli elikhethiwe uzokwanda, futhi umbhalo kuyo uzokwakhiwa kabusha ube yipharagrafu, etholakala emigqeni eminingana kusici.

Nakani! Ukufometha kahle indima edalwe kuseli, umbhalo ungafomethwa ngokusetha ubukhulu obufiswayo bawo, kanye nokwandisa ububanzi bekholomu.

Indlela 2. Uzenza kanjani izigaba eziningi kuseli eyodwa

Uma umbhalo obhalwe ohlwini lwe-Excel uqukethe imisho embalwa, khona-ke ingahlukaniswa komunye nomunye ngokuqala umusho ngamunye emugqeni omusha. Lokhu kuzokwandisa ubuhle bomklamo, kuthuthukise ukubukeka kwepuleti. Ukuze wenze ukwahlukanisa okunjalo, kufanele uqhubeke ngokulandelayo:

1. Khetha iseli yethebula oyifunayo.
2. Buka umugqa wefomula phezulu kumenyu enkulu ye-Excel, ngezansi kwendawo yamathuluzi ajwayelekile. Ibonisa wonke umbhalo wesici esikhethiwe.
3. Beka ikhesa yegundane phakathi kwemisho emibili yombhalo emugqeni wokufaka.
4. Shintshela ikhibhodi ye-PC kusakhiwo sesiNgisi bese ucindezela izinkinobho kanyekanye "Alt + Enter".
5. Qiniseka ukuthi imisho ihlukanisiwe, futhi owodwa wayo udlulela emgqeni olandelayo. Ngakho, isigaba sesibili sakhiwe esitokisini.

6. Yenza okufanayo nangeminye imisho esetheksthini ebhaliwe.

Kubalulekile! Usebenzisa inhlanganisela yokhiye we-Alt + Enter, awukwazi ukugoqa hhayi izigaba kuphela, kodwa nanoma yimaphi amagama, ngaleyo ndlela wenze izigaba. Ukuze wenze lokhu, vele ubeke ikhesa noma yikuphi embhalweni bese ucindezela izinkinobho ezikhonjiwe.

Indlela yesi-3: Sebenzisa amathuluzi okufometha

Le ndlela yokudala ipharagrafu ku-Microsoft Office Excel ibandakanya ukushintsha ifomethi yeseli. Ukuze uyisebenzise, ​​​​kufanele ulandele izinyathelo ezilula ngokuya nge-algorithm:

1. I-LMB yokukhetha iseli lapho umbhalo othayiphiwe ungangeni khona ngenxa yosayizi wawo omkhulu.
2. Chofoza kunoma iyiphi indawo ye-elementi ngenkinobho yegundane engakwesokudla.
3. Ewindini lohlobo lomongo elivulekayo, chofoza into ethi “Fometha amaseli ...”.

4. Kumenyu yokufometha ye-elementi, ezoboniswa ngemva kokwenza ukukhohlisa kwangaphambilini, udinga ukuya engxenyeni ethi "Ukuqondanisa".
5. Esigabeni esisha semenyu, thola ibhulokhi ethi “Bonisa” bese uqoka ibhokisi eliseduze kwenketho ethi “Goqa ngamagama”.
6. Chofoza okuthi KULUNGILE ezansi kwewindi ukuze usebenzise izinguquko.

7. Hlola umphumela. Iseli lizozilungisa ngokuzenzakalelayo ubukhulu ukuze umbhalo ungadluli umkhawulo wawo, futhi kuzokwakhiwa isigaba.

Indlela 4. Ukusebenzisa ifomula

I-Microsoft Office Excel inefomula ekhethekile yokudala izigaba, ukugoqa umbhalo phezu kwemigqa eminingana kumaseli wohlu lwethebula. Ukuze wenze lo msebenzi, ungasebenzisa i-algorithm elandelayo yezenzo:

1. Khetha iseli elithile lethebula le-LMB. Kubalulekile ukuthi i-elementi ekuqaleni ingabi nawo umbhalo noma ezinye izinhlamvu.
2. Faka ifomula mathupha kusuka kukhibhodi yekhompyutha=CONCATENATE(“TEXT1″,CHAR(10),”TEXT2”)“. Esikhundleni samagama “TEXT1” kanye “TEXT2” udinga ukushayela ngamavelu athile, okungukuthi bhala izinhlamvu ezidingekayo.
3. Ngemva kokubhala, cindezela okuthi “Enter” ukuze uqedele ifomula.

4. Hlola umphumela. Umbhalo oshiwo uzobekwa emigqeni embalwa yeseli, kuye ngevolumu yawo.

Ulwazi Olwengeziwe! Uma ifomula okukhulunywe ngayo ngenhla ingasebenzi, umsebenzisi kufanele ahlole isipelingi sayo noma asebenzise enye indlela ukuze akhe izigaba ku-Excel.

Unganweba kanjani ifomula yokudala izigaba ngenani elidingekayo lamaseli ku-Excel

Uma umsebenzisi edinga ukugoqa imigqa ngezici ezimbalwa zohlu lwethebula ngesikhathi esisodwa esebenzisa ifomula okukhulunywe ngayo ngenhla, lapho-ke ngesivinini senqubo kwanele ukunweba umsebenzi ebangeni elinikeziwe lamaseli. Ngokuvamile, inqubo yokwelula ifomula ku-Excel imi kanje:

1. Khetha iseli eliqukethe umphumela wefomula.
2. Beka ikhesa yegundane ekhoneni elingezansi kwesokudla lesici esikhethiwe bese ubamba i-LMB.
3. Yelula iseli ngenani elidingekayo lemigqa yamalungu afanayo ethebula ngaphandle kokukhulula i-LMB.
4. Khipha ukhiye wesokunxele we-manipulator bese uhlola umphumela.

Isiphetho

Ngakho-ke, ukudala izigaba kumaseli e-Microsoft Office Excel akubangeli izinkinga nakubasebenzisi abangenalwazi. Ukuze ugoqe umugqa ofanele, kubalulekile ukulandela imiyalelo engenhla.