Nzira Yokubatanidza Sei Masekeri muExcel neGoogle Spreadsheets

01 ye 01

Gadzira Masekeri muExcel neGoogle Spreadsheets

MuExcel neGoogle Spreadsheets, sero yakabatana isero rimwe chete rakasikwa nekubatanidza kana kubatanidza masero maviri kana akawanda pamwe chete.

Mapurogiramu ose aya ane maitiro okuti:

• iyananidza masero mairi
• iyananisa masero vertically
• iyananidza masero ose maviri nechepamusoro.

Mukuwedzera, Excel ine sarudzo yekubatanidza data neCentral iyo inowanzoshandiswa pakugadzirisa mafungiro paunenge uine mazita kana musoro.

Kubatana uye nzvimbo inoita kuti zvive nyore kuisa misoro mukati memamwe mahwendefa ebasa.

Unganidza Rimwe Cell Red Data chete

Itai kuti masero ose muExcel neGoogle Spreadsheets ave nemiganhu imwechete - haagoni kuunganidza data kubva kune masero akawanda.

Kana makero akawanda e data ari akabatanidzwa, chete data iri kumusoro yakasara pane imwe sero inochengeterwa - zvimwe zvose deta zvicharasika apo kuungana kunowanikwa.

Tsanangudzo yesero yeganda rakabatanidzwa ndiro sero iri kumucheto wepamusoro wekweseri wegadziriro yakasarudzwa yakasarudzwa kana boka remasero.

Kwatingawana Merge

MuExcel, kusarudza kusanganiswa kunowanikwa paImba yebhu yebhoni. Chiratidzo chechikamu chacho chinonzi Merge & Centre, asi nekudhonza pasi petsoropodzo kusvika kurudyi rwezita sezvinoratidzwa mumufananidzo uri pamusoro, kudonha pasi menyu yezvinhu zvose zvinosanganiswa zvinosvinudzwa.

MuGoogle Spreadsheets, kusanganiswa kwemasero masero kunowanikwa pasi peMutauro wemenu. Chiitiko chacho chinongogadziriswa kana vazhinji vari pedyo masero vakasarudzwa.

MuExcel, kana Merge & Center inoshandiswa apo chete sero rimwe chete rakasarudzwa, chete chinogadzirisa ndechokuchinja kushandiswa kwesero iyo.

Nzira Yokubatanidza Maseji

In Excel,

1. Sarudza masero akawanda kuti awirirane;
2. Dzvanya pane Merge & Center icon paImba yebhu yebhoni kuitira kuti ibatanidze masero uye ipe nhepfenyuro kune imwe nzvimbo yakasarudzwa;
3. Kuti ushandise chimwe chezvimwe zvekubatanidza, sarudza pasi petsva pasi pedo re Merge & Center icon uye sarudza kubva pane zvaunogona kuita:
   • Merge & Center;
   • Kubatana Nese (inobatanidza masero anonamatira - kumativi ose);
   • Unganidza Masekeri (anounganidza masero ari kure, vertically, kana maviri);
   • Shandisa maSells.

MuGoogle Spreadsheets:

1. Sarudza masero akawanda kuti awirirane;
2. Dzvanya ku Format> Unganidza masero mumamenu kuti uzarure mamiriro ekutenderera ekusanganiswa kwesarudzo;
3. Sarudza kubva pane zvakasarudzwa:
   • Itai zvose (sanisai masero marefu, vertically, kana maviri);
   • Gadzirai horizontally;
   • Gadzira vertically;
   • Simbisa.

Excel Merge uye Centre Alternative

Imwe nzira yekuisa deta kudarika mienzaniso yakawanda ndeyokushandisa Centre Across Selection iri muFomendi Cells dialog box .

Kubudirira kwekushandisa chinhu ichi pane Merge & Centre ndeyokuti haibatanisi masero akasarudzwa.

Mukuwedzera, kana kupfuura rimwe kero rimwe rine dhesi kana sarudzo iri kushandiswa, data iri mumasero inotarisa zvakasiyana-siyana zvakadai sekushandura kuenzaniswa kwesero.

Sezvo ne Merge & Centre, kuisa misoro pamisoro yakawanda inowanzoita kuti zvive nyore kuona kuti musoro wacho unoshanda kumativi ose.

Kuti uise musoro wehurukuro kana musoro wetsamba pamakoroni akawanda, ita zvinotevera:

1. Sarudza masero ekura ane zvinyorwa kuti zvive zvakanyanya;
2. Dzvanya paImba yebhu yebhoni;
3. Muchibatanidzwa cheboka , chengetedza dialog box launcher kuti uzarure maDenesi eDaily dialog box;
4. Mubhokisi rebhokisi, tora paItungamire tab;
5. Pasi Pemagariro , sarudza bhokisi riri pasi peHoirontal kuona urongwa hwezvinhu zviripo;
6. Dzvanya kuCentral Across Selection kuti uise pakati pezvinyorwa zvakasarudzwa kumativi ose emasero;
7. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.

Pre-Excel 2007 Kusanganiswa Nekukanganiswa Kwechikwata

Pamberi paEcelcel 2007, kushandiswa kweMerige & Centre kunogona kukonzera matambudziko kana kuchinja kwekupedzisira kune nzvimbo yakabatana yepepaiti .

Semuenzaniso, zvakanga zvisingakwanisi kuwedzera misoro mitsva kunzvimbo yakabatanidzwa yebasa rekushanda.

Usati wawedzera mahwendefa matsva, matanho ekutevera angave:

1. un-merge ikozvino masero akabatanidzwa ane chinyorwa kana kutungamirira;
2. Wedzera mapuranga matsva kumushandi webasa;
3. re-shandisa kubatana uye nzvimbo yekusarudza.

Sezvo Excel 2007 zvisinei, zvave zvichikwanisika kuwedzera mamwe mahwende kune nzvimbo yakabatana nenzira imwecheteyo nedzimwe nzvimbo dzebasa racho pasina kutevera matanho ari pamusoro apa.