Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese maitiro

Kazhinji vanhu vanoshanda muExcel spreadsheet chirongwa vanotarisana nemamiriro ezvinhu apo ivo vanofanirwa kuputira mutsara. Iwe unogona kushandisa iyi nzira iri nyore nenzira dzakasiyana-siyana. Muchinyorwa chacho, tichaongorora zvakadzama nzira dzose dzinokubvumira kuendesa mutsara panzvimbo yekushanda yegwaro respredishiti.

Nzira yekubvisa sei mitsara kubva mumasero muExcel 2013, 2010 uye 2007

Pane nzira 3 dzekushandisa kubviswa kwekutakura kudzoka kubva kuminda. Vamwe vavo vanoshandisa kutsiva mutsara wekutyora mavara. Sarudzo dzakurukurwa pazasi dzinoshanda zvakafanana mune dzakawanda shanduro dzespredishiti mupepeti.

Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
1

Kupeta mutsara mumashoko ezvinyorwa kunoitika nekuda kwezvikonzero zvakasiyana. Zvikonzero zvakajairika zvinosanganisira zvinhu zvakaita sekushandisa iyo Alt + Enter keyboard shortcut, pamwe nekuendesa mameseji data kubva pawebhu peji kuenda kunzvimbo yebasa respredishiti. Tinofanira kubvisa kudzoka kwengoro, sezvo pasina maitiro aya hazvibviri kuita tsvakiridzo yakajairika yemitsara chaiyo.

Zvinokosha! Pakutanga, mashoko okuti “Kudyisa mutsara” uye “Kudzoka kweMotokari” aishandiswa pakushanda pamichina yokudhinda uye airatidza zviito zviviri zvakasiyana. Makomputa ega ega akagadzirwa achifunga nezvemabasa emuchina wekudhinda.

Kubvisa ngoro inodzosa nemaoko

Ngationgororei nzira yekutanga zvakadzama.

  • Advantage: kukurumidza kuuraya.
  • Cons: Kushaikwa kwemamwe maficha.

Detailed mirairo inoita seizvi:

  1. Isu tinoita sarudzo yemasero ese ayo anofanirwa kuita oparesheni iyi kana kutsiva mavara.
Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
2
  1. Uchishandisa keyboard, tinya kiyi musanganiswa "Ctrl + H". Hwindo rakanzi "Tsvaga uye Tsiva" rakaonekwa pachiratidziri.
  2. Isu tinoisa pointer kumutsetse we "Tsvaga". Uchishandisa keyboard, tinya kiyi musanganiswa "Ctrl + J". Pane kadonhwe kadiki mumutsetse.
  3. Mumutsara wekuti "Tsvanura ne" tinoisa humwe kukosha huchaiswa panzvimbo yekudzoka kwengoro. Kazhinji kazhinji, nzvimbo inoshandiswa, sezvo ichikubvumira kuti usabvisa gluing yemashoko maviri ari pedyo. Kuita kubviswa kwekuputira mutsara, mutsara we "Replace with" haufanirwe kuzadzwa nechero ruzivo.
Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
3
  1. Uchishandisa LMB, tinya pakanzi "Dzorera Zvese". Ready! Isu takaita kubviswa kwengoro yekudzosera.
Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
4

Bvisa mitsetse yemitsara uchishandisa Excel mafomula

  • Advantage: kugona kushandisa akasiyana mafomati anoita iyo yakanyanya kuomarara verification yezvinyorwa zvemashoko mundima yakasarudzwa. Semuenzaniso, iwe unogona kuita kubviswa kwekudzoka kwengoro, uye wozowana nzvimbo dzisina basa.
  • Kukanganisa: iwe unofanirwa kugadzira imwe koramu, pamwe nekuita huwandu hukuru hwemamanipulations.

Detailed mirairo inoita seizvi:

  1. Ngatishandise kuwedzera kwekoramu yekuwedzera pamagumo eruzivo rwekutanga. Mumuenzaniso uyu, ichanzi "1 mutsara"
  2. Mundima yekutanga yekoramu yekuwedzera (C1), tinotyaira mune fomula inoshandisa kubviswa kana kutsiviwa kwemitsara yekutyora. Maformula akati wandei anoshandiswa kuita oparesheni iyi. Formula inokodzera kushandiswa nemisanganiswa yengoro yekudzoka uye mutsara wekudya unotaridzika seizvi: =CHINZVINISA(CHINZVIMBO(B2,CHAR(13),””);CHAR(10),””).
  3. Formula yakakodzera kutsiva mutsara wekutyora neimwe hunhu inoita seizvi: =TRIMSPACES(SUBSTITUTE(SUBSTITUTE(B2,CHAR(13)),””);CHAR(10);”, “). Zvakakosha kuziva kuti munyaya iyi hapazovi nekubatanidzwa kwemitsara.
  4. Iyo fomula yekubvisa ese asingadhindike mavara kubva kune zvinyorwa data inotaridzika seizvi: =KUCHENA(B2).
Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
5
  1. Isu tinoteedzera fomula, tobva taisa musero rega rega rekoramu yekuwedzera.
  2. Uyezve, iwe unogona kutsiva iyo yekutanga mbiru neitsva, umo mitsara inotyora ichabviswa.
  3. Isu tinoita sarudzo yemasero ose ari mumutsara C. Tinobata pasi "Ctrl + C" musanganiswa pane keyboard kuti tishandise kukopa kwemashoko.
  4. Isu tinosarudza munda B2. Dzvanya kiyi musanganiswa "Shift + F10". Mune rondedzero diki inooneka, tinya LMB pane chinhu chine zita rekuti "Isa".
  5. Ngatishandise kubviswa kwechikamu chekubatsira.

Bvisa mitsara inotyora neVBA macro

  • Kubatsira: kusikwa kunoitika kamwechete. Mune ramangwana, iyi macro inogona kushandiswa mune mamwe mapepa espredishiti.
  • Kukanganisa: Iwe unofanirwa kunzwisisa kuti VBA programming mutauro unoshanda sei.

Kuti uite iyi nzira, unofanirwa kupinda muhwindo rekupinda macros uye woisa inotevera kodhi ipapo:

Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
6

Putira mavara muchitokisi

Iyo spreadsheet mupepeti Excel inobvumidza iwe kuendesa ruzivo rwemavara kumunda. Izvi zvinoitwa kuitira kuti zvinyorwa zvinyorwa zviratidzwe pamitsetse yakawanda. Iwe unogona kuita maitiro ekuseta kumunda wega wega kuitira kuti kutumira kwe data data kuitwe otomatiki. Uyezve, iwe unogona kushandisa mutsara wekuputsa nemaoko.

Kuputirwa kwemavara otomatiki

Ngationgororei zvakadzama maitiro ekushandisa iyo otomatiki kuendesa kwemavara kukosha. Nhanho nhanho algorithm inoita seizvi:

  1. Isu tinosarudza sero inodiwa.
  2. Muchikamu che "Kumba" tinowana block yemirairo inonzi "Alignment".
  3. Uchishandisa LMB, sarudza chinhu che "Fambisa Chinyorwa".

Zvinokosha! Ruzivo rwuri mumaseru rwunozofambiswa uchifunga nezvehupamhi hwekoramu. Kugadzirisa iyo column hupamhi inozogadzirisa mameseji ekuputira data. 

Gadzirisa kureba kwemutsara kuratidza mavara ese

Ngationgororei zvakadzama maitiro ekuita maitiro ekugadzirisa urefu hwemutsara kuratidza ruzivo rwese rwemavara. Detailed mirairo inoita seizvi:

  1. Isu tinosarudza masero anodiwa.
  2. Muchikamu che "Kumba" tinowana block yemirairo inonzi "Masero".
  3. Uchishandisa LMB, sarudza chinhu che "Format".
  4. Mubhokisi re "Kukura Kwesero", unofanirwa kuita imwe yesarudzo dzinotsanangurwa pazasi. Sarudzo yekutanga - kurongedza urefu hwemutsara, tinya LMB pane "Auto-fit line urefu" chinhu. Yechipiri sarudzo ndeyekuseta nemaoko urefu hwemutsara nekudzvanya pane "Mutsetse urefu" chinhu, wobva waisa chiratidzo chaunoda mumutsara usina chinhu.

Kupinza mutsara wekutyora

Ngationgororei zvakadzama maitiro ekuita maitiro ekupinda mutsetse wekutyora. Detailed mirairo inoita seizvi:

  1. Nekudzvanya-kaviri LMB, tinosarudza munda watinoda kutyaira mutsetse wekutyora. Zvinokosha kucherechedza kuti unogona kusarudza inodiwa munda, uye ipapo tinya "F2".
  2. Nekudzvanya-kaviri LMB, tinosarudza nzvimbo ichawedzerwa mutsara wekupwanya. Dzvanya iyo Alt + Enter musanganiswa. Ready!

Maitiro ekuita mutsara kutyora muExcel cell ine formula

Kazhinji, vashandisi vepaspredishiti vanowedzera akasiyana machati uye magirafu kunzvimbo yebasa. Kazhinji, maitiro aya anoda kupetwa kwemutsara mune ruzivo rwemavara emunda. Ngationei zvakadzama nzira yekushandisa nguva ino.

Formula yekuputira mutsara muExcel maseru

Semuenzaniso, isu tine histogram inoshandiswa muchirongwa chespredishiti. Iyo x-axis ine mazita evashandi, pamwe neruzivo nezvekutengesa kwavo. Rudzi urwu rwekusayina rwakanyanya nyore, sezvo runoratidza zvakajeka huwandu hwebasa rinoitwa nevashandi.

Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
7

Zviri nyore kwazvo kushandisa nzira iyi. Izvo zvinodiwa kuti uwedzere SYMBOL opareta panzvimbo yeformula. Inokubvumira kushandisa chizvarwa chezviratidzo muminda yekusaina ruzivo mudhayagiramu.

Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
8

Ehe, mumunda, unogona kuita iyo yekupeta mutsara maitiro chero kupi, nekuda kwekubatanidzwa kweiyo Alt + Enter mabhatani. Nekudaro, iyi nzira haigoneki mumamiriro ezvinhu apo kune data rakawandisa.

Mashandiro anoita CHAR kana achiputira mitsetse musero

Iyo purogiramu inoshandisa macode kubva ku ASCII character table. Iyo ine macode emavara anoratidzwa pachiratidziro muOS. The tablet ine mazana maviri nemakumi mashanu neshanu ane manhamba macode.

Mushandisi wetafura mugadziri anoziva aya macode anogona kuashandisa muCHAR opareta kuita kuisa chero chimiro. Mumuenzaniso wakakurukurwa pamusoro apa, mutsara wemutsara unowedzerwa, uyo wakabatanidzwa kumativi ose e "&" pakati pezviratidzo zveminda C2 neA2. Kana iyo modhi inonzi "Fambisa mameseji" isati yaitwa mumunda, saka mushandisi haazocherechedze kuvepo kwechiratidzo chekutyora mutsara. Izvi zvinogona kuonekwa mumufananidzo uri pasi apa:

Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
9

Izvo zvakakosha kucherechedza kuti pamachati akasiyana-siyana, mitsara yekutyora yakawedzerwa uchishandisa fomula icharatidzwa nenzira yakajairika. Mune mamwe mazwi, mutsara wemavara uchakamurwa kuita 2 kana kupfuura.

Kamurana kuita mbiru nekutyora mutsetse

Kana mushandisi ari muchikamu che "Data" akasarudza chinhu che "Text by columns", ipapo anozokwanisa kuita kuendesa mitsara uye kupatsanurwa kweruzivo rwebvunzo mumasero akati wandei. Maitiro acho anoitwa uchishandisa iyo Alt + Enter musanganiswa. Mu "Wizard yekugovera mavara nemakoramu" bhokisi, unofanirwa kutarisa bhokisi riri padivi pechinyorwa "zvimwe" uye isa musanganiswa "Ctrl + J".

Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
10

Kana iwe ukatarisa bhokisi riri padivi pechinyorwa chinoti "Vanoparadzanisa vanokonzeresa seimwe", ipapo iwe unogona kuita "kudonha" kweakawanda mitsara inotyora mumutsara. Pakupedzisira, tinya "Next". Somugumisiro, tichawana:

Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
11

Gura mumitsara neAlt + Pinda kuburikidza nePower Query

Pane mamiriro ezvinhu apo mushandisi anoda kupatsanura ruzivo rwemavara e-multi-line kwete mumakoramu, asi mumitsara.

Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
12

Kuti uite maitiro aya, iyo Power Query yekuwedzera-mukati, iyo yakaonekwa mupepeti yespredishiti kubva 2016, yakanaka. Detailed mirairo inoita seizvi:

  1. Tichishandisa "Ctrl + T" musanganiswa, tinoshandura iyo data data kuita "smart" ndiro. Imwe sarudzo ndeyekuenda kune "Kumba" chikamu uye tinya LMB pane "Format setafura" chinhu.
  2. Enda kune "Data" chikamu uye tinya pane "Kubva Tafura / Range" chinhu. Kuvhiya uku kuchapinza ndiro muPower Query chishandiso.
Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
13
  1. Isu tinosarudza koramu ine multi-line zvinyorwa zvinyorwa. Isu tinotamira kune "Kumba" chikamu. Wedzera runyorwa rwe "Split column" chiratidzo uye tinya LMB pane "Nekuparadzanisa" chinhu.
Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
14
  1. Dzvanya pakanzi "OK" kuratidza shanduko dzakaitwa. Ready!
Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
15

Macro yekukamura kuita mitsetse neAlt + Enter

Ngationei kuti tingaite sei maitiro aya uchishandisa yakakosha macro. Isu tinovhura VBA tichishandisa iyo Alt + F11 kiyi musanganiswa pane keyboard. Muhwindo rinoonekwa, tinya "Insert", uyezve "Module". Pano tinowedzera kodhi inotevera:

Line break character muExcel. Maitiro ekuita mutsara kutyora muExcel cell - ese nzira
16

Isu tinodzokera kunzvimbo yebasa uye sarudza minda iyo iyo yakawanda ine ruzivo ruzivo. Dzvanya musanganiswa "Alt + F8" pane keyboard kuti uite iyo yakagadzirwa macro.

mhedziso

Kubva pane zvinyorwa zvechinyorwa, unogona kuona kuti kune nhamba huru yenzira dzekushandisa kupeta mutsara mugwaro respredishiti. Iwe unogona kuita maitiro aya uchishandisa mafomula, vashandisi, akakosha maturusi uye macros. Mumwe nemumwe mushandisi achakwanisa kuzvisarudzira nzira iri nyore kwaari.

Leave a Reply