Maitiro ekugadzira ndima muexcel cell

Dzimwe nguva vashandisi veMicrosoft Office Excel vanofanirwa kunyora mitsara yakati wandei musero rimwe retafura yetafura kamwechete, nekudaro vachigadzira ndima. Uku mukana muExcel unogona kuitwa nenzira dzinoverengeka uchishandisa zvakajairwa chirongwa maturusi. Maitiro ekuwedzera ndima kune sero mune MS Excel tafura ichakurukurwa munyaya ino.

Nzira dzekuputira zvinyorwa mumaseru etafura

MuExcel, haugone kugadzira ndima nekudzvanya kiyi "Enter" kubva pakhibhodi yekombuta, semuIzwi. Pano tinofanira kushandisa dzimwe nzira. Dzichakurukurwa mberi.

Method 1: Peta zvinyorwa uchishandisa maturusi ekugadzirisa

Mavara akakurisa haakwane zvachose musero rimwe chete retafura, saka anotofanira kuendeswa kune mumwe mutsetse wechinhu chimwe chete. Nzira iri nyore yekuita basa iri yakakamurwa kuita zvinotevera:

1. Shandisa bhatani reruboshwe kuti usarudze sero raunoda kugadzira ndima.

2. Enda kune "Kumba" tab, iyo iri mubharu repamusoro remenyu huru yepurogiramu.
3. Muchikamu che "Alignment", tinya bhatani re "Text Wrap".

4. Tarisa mhinduro. Mushure mekuita nhanho dzakapfuura, ukuru hwesero rakasarudzwa huchawedzera, uye zvinyorwa mukati maro zvichavakwazve mundima, iri pamitsetse yakati wandei muchinhu.

Teerera! Kugadzira zvakanaka ndima yakagadzirwa musero, chinyorwa chinogona kuumbwa nekuisa zviyero zvinodiwa pairi, pamwe nekuwedzera hupamhi hwekoramu.

Nzira 2. Magadzirirwo endima dzakawanda muchitokisi chimwe

Kana zvinyorwa zvakanyorwa muExcel array element zvine mitsara yakati wandei, saka inogona kupatsanurwa kubva kune mumwe nekutanga mutsara wega wega pamutsara mutsva. Izvi zvichawedzera aesthetics yekugadzira, kuvandudza kutaridzika kweplate. Kuti uite chikamu chakadaro, unofanirwa kuenderera nenzira inotevera:

1. Sarudza sero yetafura yaunoda.
2. Wona iyo formula mutsara kumusoro kweExcel main menu, pazasi peyakajairwa maturusi nzvimbo. Inoratidza zvinyorwa zvose zvechinhu chakasarudzwa.
3. Isa mutsara wemouse pakati pemitsara miviri yezvinyorwa mumutsetse wekuisa.
4. Chinja kiyibhodhi yePC kune dhizaini yeChirungu uye panguva imwe chete bata mabhatani e "Alt + Enter".
5. Iva nechokwadi chekuti mitsara yakaganhurwa, uye imwe yacho ichienda kumutsetse unotevera. Nokudaro, ndima yechipiri inoumbwa muchitokisi.

6. Ita zvimwe chete nemamwe mimwe mitsara muzvinyorwa zvakanyorwa.

Zvinokosha! Uchishandisa iyo Alt + Enter kiyi musanganiswa, haugone kuputira kwete chete ndima, asiwo chero mazwi, nekudaro uchigadzira ndima. Kuti uite izvi, ingoisa cursor pese pane zvinyorwa uye wobata pasi mabhatani anoratidzwa.

Method 3: Shandisa mafomati maturusi

Iyi nzira yekugadzira ndima muMicrosoft Office Excel inosanganisira kushandura sero fomati. Kuti uzviite, unofanirwa kutevedzera nhanho dziri nyore zvinoenderana nealgorithm:

1. LMB yekusarudza sero umo mavara akataipa asingakwane nekuda kwehukuru hwayo.
2. Dzvanya pane chero nzvimbo yechinhu chine bhatani rekurudyi.
3. Muhwindo remhando yemamiriro anovhurwa, tinya pane "Format masero ...".

4. Mune iyo element formatting menyu, iyo icharatidzwa mushure mekuita iyo yapfuura manipulation, unofanirwa kuenda kune "Alignment" chikamu.
5. Muchikamu chitsva chemenu, tsvaga "Ratidza" block uye tarisa bhokisi riri padyo ne "Putira nemazwi" sarudzo.
6. Dzvanya OK pazasi pehwindo kuti uise shanduko.

7. Tarisa mhinduro. Sero rinozogadzirisa zviyero kuitira kuti zvinyorwa zvirege kupfuura miganhu, uye ndima ichagadzirwa.

Nzira 4. Kushandisa chimiro

Microsoft Office Excel ine fomula yakakosha yekugadzira ndima, kuputira zvinyorwa pamusoro pemitsetse yakati wandei mumaseru etafura array. Kuti uite basa iri, unogona kushandisa inotevera algorithm yezviito:

1. Sarudza imwe sero yetafura yeLMB. Izvo zvakakosha kuti chinhu chekutanga chisina zvinyorwa kana mamwe mavara.
2. Pinda fomula iwe pachako kubva pakombuta keyboard=CONCATENATE(“TEXT1″,CHAR(10),”TEXT2”)“. Panzvimbo pemazwi ekuti “TEXT1” ne” TEXT2” unoda kutyaira nehunhu chaihwo, kureva kunyora mavara anodiwa.
3. Mushure mekunyora, tinya "Enter" kuti upedze fomula.

4. Tarisa mhinduro. Mavara akatarwa achaiswa pamitsetse yakati wandei yesero, zvichienderana nehuwandu hwayo.

Mamwe Mashoko! Kana iyo formula yakurukurwa pamusoro isingashande, saka mushandisi anofanira kutarisa kupereta kwayo kana kushandisa imwe nzira kugadzira ndima muExcel.

Maitiro ekuwedzera iyo ndima yekugadzira fomula nenhamba inodiwa yemasero muExcel

Kana mushandisi achida kupeta mitsara mune akati wandei zvinhu zvetafura array kamwechete achishandisa fomula yakurukurwa pamusoro, saka nekumhanya kwemaitiro zvinokwana kuwedzera basa kune rakapihwa masero. Kazhinji, maitiro ekuwedzera fomula muExcel ndeaya anotevera:

1. Sarudza sero rine mhedzisiro yeformula.
2. Isa iyo mbeva yekona mukona yekurudyi yechinhu chakasarudzwa uye bata pasi LMB.
3. Tambanudza sero yehuwandu hunodiwa hwemitsara yetafura array pasina kuburitsa LMB.
4. Sunungura kiyi yekuruboshwe yemanipulator uye tarisa mhedzisiro.

mhedziso

Saka, kugadzira ndima muMicrosoft Office Excel masero hakukonzeri matambudziko kunyangwe kune vasina ruzivo. Nekuputira mutsara kwakakodzera, zvakakosha kutevera mirairo iri pamusoro.