Ungayenza kanjani isigaba se-Cell

Kwesinye isikhathi abasebenzisi be-Microsoft Office Excel badinga ukubhalisa esitokisini esisodwa sohlu lwethebula ngasikhathi sinye imigqa eminingana yombhalo, okwenza isigaba. Ithuba elinjalo kwi-Excel lingaqalwa ngezindlela eziningi zisebenzisa amathuluzi wohlelo ajwayelekile. Mayelana nokuthi ungangeza kanjani isigaba esigabeni se-MS Excel Table Cell kuzotshelwa kule ndaba.

Izindlela zokudlulisa umbhalo ezitokisini zamatafula

Ku-Excel, akunakwenzeka ukwenza isigaba ngokucindezela ukhiye we- "Enter" kwikhibhodi yekhompyutha, njengasezigabeni. Lapha kuyadingeka ukusebenzisa ezinye izindlela. Kuzoxoxwa ngakho.

Indlela 1. Ukudlulisa umbhalo usebenzisa amathuluzi wokuqondanisa

Umbhalo wonke wombhalo wonke we-tafula afakwa ngokulinganayo kuwo wonke amaseli, ngakho-ke kuzofanele kudluliselwe kolunye umugqa wento efanayo. Indlela elula yokwenza umsebenzi ihlukaniswe ngezinyathelo ezilandelayo:

1. Ukhiye wesobunxele we-manipulator ukugqamisa iseli lapho isigaba kufanele senziwe khona.

Ukukhetha iseli oyifunayo ukudala isigaba kuso

1. Hambisa kuthebhu "Yasekhaya", etholakala kubha yamathuluzi ephezulu yemenyu yohlelo main.
2. Esigabeni se- "Alignment", chofoza inkinobho "yokudluliselwa kombhalo".

Indlela eya kwinkinobho "yokudluliselwa kombhalo" ku-Excel. Isebenza kuzo zonke izinhlobo zohlelo

1. Bheka umphumela. Ngemuva kwesenzo esedlule, usayizi weseli elikhethiwe uzokwanda, futhi umbhalo kuwo uzokwakhiwa kabusha esigabeni, engeza emigqeni eminingana entweni ethile.

Umphumela wokugcina. Umbhalo esitokisini uthuthele emgqeni omusha. Indlela 2. Ungazenza kanjani izigaba eziningana esitokisini esisodwa

Uma umbhalo ochazwe kwinto ye-array ye-Excel uqukethe okunikezwayo okuningana, angahlukaniswa omunye komunye, eqala ukunikezwa ngakunye okuvela kulayini omusha. Lokhu kuzokhulisa ama-aesthetics okuklanywa, ukubukeka kwepuleti kuzothuthuka. Ukufeza ukwahlukanisa okunjalo, kuyadingeka ukwenza okulandelayo:

1. Khetha iseli efiselekayo yetafula.
2. Bheka intambo ukufaka amafomula ngaphezulu kwemenyu enkulu ye-Excel ngaphansi kwendawo yamathuluzi ajwayelekile. Kuyo, umbhalo wento ekhethiwe uboniswa ngokuphelele.
3. Beka isikhombisi segundane phakathi kwamahhovisi ethekli amabili emugqeni wokufaka.
4. Shintsha ikhibhodi ye-PC uye ekwakhekeni kwesiNgisi futhi ngasikhathi sinye ukubopha izinkinobho ze- "Alt + Enter".
5. Qiniseka ukuthi iziphakamiso zincishiswa, futhi omunye wabo wathuthela emugqeni olandelayo. Ngakho-ke, kwakhiwa isigaba sesibili esitokisini.

Ukwakha izigaba eziningi esitokisini esisodwa se-Excel Table Array

1. Yenza isenzo esifanayo neminye imisho yombhalo obekiwe.

Indlela 3. Usebenzisa amathuluzi wokufomatha

Le ndlela yokwakha isigaba ku-Microsoft Office Excel ifaka ukushintsha ifomethi yamaseli. Ukuyisebenzisa, kuyadingeka ukwenza izinyathelo ezilula nge-algorithm:

1. I-LKM igqamise iseli lapho umbhalo oshayiwe ungabekwa khona ngenxa yobukhulu obukhulu.
2. Nganoma iyiphi indawo yento, uqhafaza kwesokudla i-manipulator.
3. Efasiteleni lokuqala lohlobo lokuqukethwe, chofoza ku- "Ifomethi Yeselula ..." Into.

Indlela eya efasiteleni lefomethi yeselula ku-Microsoft Office Excel

1. Emenyu yokufometha kwezinto ezizokhonjiswa ngemuva kokwenza ukukhohlisa okwedlule, udinga ukuya esigabeni se- "Alignment".
2. Esigabeni esisha semenyu, thola i-block "Display" bese ubeka umkhaza eduze "kokudlulisela ngokuya nge-" Parameter.
3. Chofoza ku- "Kulungile" ezansi kwewindows ukuze usebenzise izinguquko.

I-Action Algorithm kumenyu ethi "Ifomethi Yefomethi" ekwakhiweni kwesigaba

1. Bheka umphumela. Iseli lizokhetha ngokuzenzakalelayo ubukhulu obudingekayo ukuze umbhalo ungadluleli ngalapho umkhawulo wawo, bese kuthi kwakhiwe isigaba.

Indlela 4. Ukusetshenziswa kwefomula

I-Microsoft Office Excel inefomula ekhethekile yokwakha izigaba, ukudluliselwa kombhalo emigqeni eminingana kumaseli we-Table Array. Ukufeza umsebenzi, ungasebenzisa i-algorithm elandelayo yezenzo:

1. Khetha iseli ethile yetafula le-LKM. Kubalulekile ukuthi ekuqaleni bekungekho umbhalo kanye nezinye izinhlamvu endaweni.
2. Ngesandla kusuka kukhibhodi yekhompyutha Faka ifomula "= bamba (" umbhalo1 "; uphawu (10);" umbhalo2 ")". Esikhundleni samagama athi "umbhalo1" no "umbhalo2", udinga ukushayela amanani ukhonkolo, i.e. Bhala izinhlamvu ezidingekayo.
3. Ngemuva kokubhala ukuze uchofoze ku- "ENTER" ukuqedela ifomula.

Ukusetshenziswa kwefomula ekhethekile yokudlulisa imigqa ku-Excel

1. Bheka umphumela. Umbhalo obekiwe uzotholakala emigqeni eminingana yeseli, kuya ngevolumu yayo.

Unganwebisa kanjani ifomula yokwakha izigaba kwinombolo oyifunayo yamaseli

Uma umsebenzisi edinga ukudlulisa imigqa ngasikhathi sinye ezintweni eziningana zohlu lwethebula esebenzisa ifomula okuxoxwe ngenhla, kwanele ukunweba umsebenzi ohlelweni olubekiwe lwamaseli. Ngokuvamile, inqubo yokuvuselela ifomula ku-Excel ibukeka kanjena:

1. Khetha iseli lapho umphumela wefomula ubhaliswe khona.
2. Beka isikhombisi segundane engela elingaphansi kwesokudla sento ekhethiwe bese ugqekeza i-LKM.
3. Yelula iseli kunombolo oyifunayo yemigqa yohlu lwethebula, ngaphandle kokukhipha i-LKM.
4. Khipha ukhiye wesobunxele we-manipulator bese uhlola umphumela.

Ukugcina

Ngakho-ke, ukudalwa kwezigaba kumaseli we-Microsoft Office Excel akubangeli izinkinga ngisho nakubasebenzisi abangenalwazi. Ukudlulisa kahle imigqa, kubalulekile ukuqondiswa yimiyalo engenhla.

Umlayezo njengasesitokisini se-Excel ukwenza isigaba sivele kuqala kubuchwepheshe bolwazi.