Maitiro ekubatanidza maseru muexcel spreadsheet. Kuburikidza nemenu yemukati uye pasina kurasikirwa kwedata

Munguva yekunyengedza muExcel spreadsheet editor, zvinowanzova zvakakosha kubatanidza masero. Zviri nyore kuita maitiro aya, kunyanya kana maseru asina kuzadzwa neruzivo. Muzviitiko apo masero ane data, mamiriro acho akasiyana zvishoma. Muchidzidzo ichi, tichaziva nzira dzese dzinotitendera kushandisa kubatanidza masero.

Kubatanidza maseru mupepeti yespredishiti

Iyo nzira iri nyore kwazvo kuita uye inoshandiswa muzviitiko zvakaita se:

• Batanidza masero asina chinhu;
• kubatanidza maseru mumamiriro ezvinhu apo pane imwe munda izere neruzivo.

Detailed mirairo inoita seizvi:

1. Pakutanga, isu tinofanirwa kusarudza maseru atinozobatanidza kune mumwe nemumwe. Sarudzo inogadzirwa nebhatani rekuruboshwe. Pachikamu chinotevera, tinoenda kuchikamu che "Kumba". Muchikamu chino, tinowana chinhu chine zita rekuti "Batanidza uye isa pakati."

2. Iyi sarudzo inokubvumira kuti ubatanidze masero akasarudzwa mune rimwe chete, uye ruzivo rwuri mukati mawo kuti uiswe pakati pemunda.

3. Kana mushandisi achida kuti data iiswe kwete pakati, asi neimwe nzira, saka iwe unofanirwa kudzvanya pane diki museve wakasviba, uri padyo nesero merge icon. Mune inodonhedza pasi, iwe unofanirwa kudzvanya pane chinhu chinonzi "Batanidza Masero".

4. Iyi sarudzo inokubvumira kuti ubatanidze masero akasarudzwa mune rimwe chete, uye kuisa ruzivo mukati mavo kurudyi.

5. Pamusoro pezvo, mupepeti yetafura, pane mukana wekubatanidza tambo dzemasero. Kuti uite nzira iyi, zvakakosha kusarudza nzvimbo yaunoda, iyo inosanganisira mitsara yakawanda. Ipapo iwe unofanirwa kudzvanya pane diki museve wakasviba, uri padyo nesero rekubatanidza icon. Muchinyorwa chinovhura, unofanirwa kudzvanya pane chinhu chinonzi "Sanganisa nemitsara".

6. Iyi sarudzo inokubvumira kuti ubatanidze masero akasarudzwa mune rimwe chete, uyewo kuchengetedza kuparara nemitsara.

Kubatanidza Masero Uchishandisa Context Menu

Kushandisa yakasarudzika menyu ndiyo imwe nzira inobvumidza iwe kuita sero kubatanidza. Detailed mirairo inoita seizvi:

1. Isu tinosarudza nerubatsiro rweruboshwe rworuboshwe bhatani nzvimbo inodiwa, iyo yatinoronga kubatanidza. Tevere, tinya-kurudyi kwese kwese muchikamu chakasarudzwa. Menyu diki yemukati yakaonekwa pachiratidziri, umo iwe unofanirwa kutsvaga chinhu chine zita rekuti "Cell Format ..." uye tinya pairi nebhatani rekuruboshwe.

2. Hwindo idzva rakaonekwa pachiratidziro chinonzi "Format Cells". Isu tinotamira kune "Alignment" chikamu. Isu tinoisa chiratidzo padivi pechinyorwa "Sanganisa masero". Uyezve, iwe unogona kugadzirisa mamwe maparamita ekubatanidza muhwindo rino. Iwe unogona kumisa kutumira kweruzivo rwemavara nemashoko, sarudza yakasarudzika yekutarisa kuratidza, zvichingodaro.. Mushure mekuita ese anodiwa marongero, tinya LMB pane "OK" chinhu.

3. Ready! Nzvimbo yakasarudzwa kare yakashandurwa kuita sero rimwe chete.

Kubatanidza maseru pasina kurasikirwa neruzivo

Kana maseru anowanzo kubatanidzwa, data rese riri mukati mavo rinodzimwa. Ngationgororei zvakadzama maitiro ekuita maitiro ekubatanidza maseru pasina kurasikirwa neruzivo.

Kuti tiite chiitiko ichi, tinoda kushandisa CONCATENATE mushandisi. Detailed mirairo inoita seizvi:

1. Pakutanga, isu tichashandisa kuwedzera sero risina chinhu pakati pemasero atinoronga kubatanidza. Kuti uite maitiro aya, unofanirwa kudzvanya-kurudyi pane nhamba yekoramu kana mutsara. Yakakosha menyu yemukati yakaonekwa pachiratidziri. Dzvanya LMB pane "Insert" chinhu.

2. Maonero ese emushandisi: “=CONCATENATE(X;Y)”. Mafungiro emabasa ndiwo kero dzemasero achabatanidzwa. Tinofanira kuita basa rekubatanidza masero B2 uye D. Nokudaro, tinonyora chirevo chinotevera musero risina chinhu C2 rakawedzerwa: “=CONCATENATE(B2,D2. “

3. Nekuda kweizvozvo, tinowana musanganiswa weruzivo muchitokisi umo matakapinda fomula iri pamusoro. Tinocherechedza kuti pakupedzisira takawana masero matatu: 3 yekutanga uye imwe yekuwedzera, umo ruzivo rwakabatanidzwa runowanikwa.

4. Tinofanira kubvisa masero asingadiwi. Maitiro aya anofanirwa kuitwa nekudzvanya-kurudyi pasero C2, wobva wasarudza chinhu che "Copy" mune yekudonhedza pasi.

5. Iye zvino tinoenda kumunda uri kurudyi rweiyo yakakopwa. Musero rekurudyi iri, ndimo mune ruzivo rwekutanga. Kurudyi tinya pane iyi cell. Yakakosha menyu yemukati yakaonekwa pachiratidziro. Tsvaga chinhu chinonzi "Paste Special" uye tinya pachiri nebhatani rekuruboshwe.

6. Hwindo rakanzi "Paste Special" rakaonekwa pachiratidziro. Tinoisa chiratidzo pedyo nechinyorwa "Values". Mushure mekuita ese anodiwa marongero, tinya LMB pane "OK" chinhu.

7. Pakupedzisira, muchitokisi D2, takawana mhedzisiro yemunda C2.

8. Iye zvino unogona kushandisa kubviswa kwemasero asina kufanira B2 neC2. Sarudza maseru aya, fonera menyu yemukati nekurudyi bhatani rembeva, wobva wasarudza chinhu che "Delete".

9. Nekuda kweizvozvo, sero chete rakaramba riri panzvimbo yebasa, umo ruzivo rwakabatanidzwa runoratidzwa. Masero ese akamuka panguva yebasa akabviswa, sezvo asingachadiwi mugwaro.

Zvakakosha kuziva kuti nzira dzose dziri pamusoro dzinogona kushandiswa nemitsara uye makoramu.

mhedziso

Isu takaona kuti maitiro ekubatanidza maseru ari nyore kuita. Kuti ubatanidze maseru, uchichengeta data rekutanga, unofanirwa kushandisa "CONCATENATE" opareta. Izvo zvinonyanya kukosha usati watanga manipulations kugadzira kopi yekuchengetedza yegwaro rekutanga kuitira kuti kana paine zvikanganiso iwe unogona kudzosera zvese kunzvimbo yayo uye usarase ruzivo rwakakosha.