Maitiro ekuwedzera column muExcel. Kuwedzera koramu itsva, makoramu maviri uye koramu kumagumo etafura

Kuwedzera makoramu matsva patafura hunyanzvi hwakakosha hunofanirwa kuve nemushandisi wese weExcel spreadsheet. Pasina hunyanzvi uhu, hazvibviri kushanda nemazvo netabular data. Muchikamu chino, tichatarisa nzira dzakawanda dzinobatsira dzekugadzira mamwe makoramu papepa rekushanda regwaro.

Kuwedzera chikamu chitsva

Pane zvakawanda zvingasarudzwa zvekuwedzera mutsara mutsva kupepa rekushanda. Imwe neimwe yenzira dziri pazasi iri nyore kuita, saka kunyangwe anotanga anogona kuzvibata. Ngatitarisei nzira imwe neimwe zvakadzama.

Method 1. Kuisa mbiru kuburikidza nebhara rekubatanidza

Iyi nzira ndiyo iri nyore uye yakanyanya nyore kushandisa. Inoshandisa kuwedzera kwekororamu itsva kana imwe mutsara kune data retabular. Iyo yekufamba inotaridzika seiyi:

1. Isu tinowana iyo coordination panel yemhando yakachinjika uye tinya pazita rekoramu kubva kwatinoda kuwedzera mbiru itsva. Mushure mekuita maitiro aya, iyo koramu yese ichaiswa pachena papepa rebasa.

2. Isu tinodzvanya RMB pane chero nzvimbo yechidimbu chakasarudzwa. Menyu diki yemukati yakaratidzwa pachiratidziri. Isu tinowana chinhu chinonzi "Insert" uye tinya pachiri nebhatani rekuruboshwe.

3. Ready! Isu takaita yekuwedzera koramu nyowani isina chinhu kuruboshwe kwekoramu iyo yakatanga kusarudzwa.

Method 2: Kuwedzera Column Uchishandisa Sero's Context Menu

Iyi nzira, seyakapfuura, inosanganisira kushandisa menyu yemukati, asi kwete iyo koramu yese inosarudzwa pano, asi sero rimwe chete. Iyo yekufamba inotaridzika seiyi:

1. Sarudza sero kuruboshwe kwatinoronga kugadzira imwe column. Sarudzo inoitwa uchishandisa bhatani rekuruboshwe kana miseve pa keyboard.

2. Kurudyi tinya pane yakasarudzwa sero. Iyo yakajairika menyu yemukati yakaratidzwa pachiratidziri. Isu tinowana chinhu "Isa ..." uye tinya pairi nebhatani rekuruboshwe.

3. Iwindo diki rakaonekwa pachiratidziro, umo iwe unofanirwa kutsanangura kuti ndeipi chinhu chichawedzerwa mundiro. Kune marudzi matatu echinhu: sero, mutsara uye mbiru. Tinoisa chiratidzo pedyo nechinyorwa "Column". Mushure mekuita zvese manipulations, tinya bhatani rekuti "OK", riri pazasi pehwindo.

4. Ready! Isu takaita yekuwedzera koramu nyowani isina chinhu kuruboshwe kwekoramu iyo yakatanga kusarudzwa.

Method 3: Namira uchishandisa maturusi ari paribhoni

Paribhoni, iri pamusoro peExcel spreadsheet interface, pane chinhu chakakosha chinokutendera kuti uise mbiru itsva mutafura. Nhanho-ne-nhanho tutori inoita seizvi:

1. Sarudza sero kuruboshwe kwatinoronga kugadzira imwe column. Sarudzo inoitwa uchishandisa bhatani rekuruboshwe kana miseve pa keyboard.

2. Isu tinotamira kune "Kumba" chikamu, icho chiri pamusoro peiyo spreadsheet interface. Wedzera runyorwa rwe "Insert" element. Muchinyorwa chinovhurwa, tsvaga bhatani "Isa makoramu papepa" uye tinya pairi.

3. Ready! Isu takaita kuwedzera koramu nyowani isina chinhu kuruboshwe kwekoramu iyo yakatanga kusarudzwa

Method 4. Hotkeys yekuisa mbiru itsva

Kushandisa hotkeys ndiyo imwe nzira inonyanya kufarirwa pakati pevashandisi veExcel spreadsheet vane ruzivo. Kune misiyano miviri yeiyi nzira. Maitiro ekutanga nzira ndeokuti:

1. Dzvanya pazita rekoramu mune inoronga mapaneru.

Rangarira! Imwe mbiru yekuwedzera inogara ichiwedzerwa kuruboshwe kwekoramu yakasarudzwa.

2. Dzvanya kiyi musanganiswa pane kiibhodhi "Ctrl" + "+". Mushure mekuita zvese manipulations, koramu itsva ichaonekwa kuruboshwe kwekoramu yakasarudzwa.

Kubudirira kwechipiri nzira ndeyotevera:

1. Dzvanya pasero nebhatani rekuruboshwe.
2. Dzvanya kiyi musanganiswa pane kiibhodhi "Ctrl" + "+".
3. Hwindo rinozivikanwa rakanzi "Wedzera Masero" rairatidzwa pachiratidziri. Tinoisa fadhi pedyo nechinyorwa "Column". Mushure mekuita zvese manipulations, tinya bhatani rekuti "OK", riri pazasi pehwindo.

4. Ready! Mushure mekuita zvese zviito kuruboshwe kwekoramu yakasarudzwa, koramu itsva ichaonekwa.

Kupinza makoramu maviri kana anopfuura

Pane mamiriro ezvinhu apo mushandisi wespredishiti anoda kuisa mamwe makoramu akawanda panguva imwe chete. Kushanda kwechirongwa kunoita kuti zvive nyore kuita izvi. Iyo yekufamba inotaridzika seiyi:

1. Pakutanga, tinosarudza masero akatwasuka. Iwe unofanirwa kusarudza masero akawanda sezvo paine mamwe makoramu aunoronga kuwedzera.

Teerera! Uye hazvina basa kuti kusarudzwa kunoitwa kupi. Iwe unogona kusarudza maseru ese ari patafura pachayo uye pane coordination panel.

2. Tichishandisa mazano anotsanangurwa pamusoro apa, tinoita maitiro ekuwedzera mamwe makoramu. Mumuenzaniso wedu chaiwo, takavhura menyu yemukati nebhatani rekurudyi rembeva uye takasarudza chinhu che "Insert".

3. Ready! Isu takaita yewedzero yemakoramu matsva asina chinhu kuruboshwe kweaya makoramu akasarudzwa pakutanga.

Isa koramu kumagumo kwetafura

Nzira dzose dziri pamusoro dzinongofanirwa nemamiriro ezvinhu iwayo kana zvichidikanwa kuwedzera imwe kana mamwe makoramu ekuwedzera pakati kana kutanga kweplate iri papepa rekushanda regwaro. Ehe, uchishandisa nzira idzi, unogona kuwedzera makoramu matsva kumagumo etafura, asi ipapo iwe uchafanirwa kupedza nguva yakawanda uchiigadzirisa.

Kuita kuisa makoramu matsva mutafura pasina mamwe mafomati, pane imwe nzira inobatsira. Iri muchokwadi chokuti ndiro yakajairwa inoshanduka kuita "smart" imwe. Iyo yekufamba inotaridzika seiyi:

1. Isu tinosarudza zvachose masero ese etafura yedu. Pane nzira dzakawanda dzekusimbisa data rese. Isu tichashandisa kiyi yekubatanidza pane keyboard "CTRL + A".

2. Isu tinotamira kuchikamu che "Kumba", icho chiri pamusoro peiyo interface. Isu tinowana block yemirairo "Styles" uye tinya pane chinhu "Format setafura".

3. Rondedzero ine zvitaera yakavhurwa. Isu tinosarudza chimiro chakakodzera che "smart table" nekudzvanya bhatani rekuruboshwe.

4. Iwindo diki rainzi "Format Table" rairatidzwa pachiratidziri. Pano unoda kutsanangura miganhu yenzvimbo yakasarudzwa. Nekusarudzwa kwakaringana kwekutanga, hapana chikonzero chekuchinja chero chinhu pano. Kana iwe ukaona data isiriyo, unogona kuigadzirisa. Isa cheki padivi pechinhu "Tafura ine misoro". Mushure mekuita zvese manipulations, tinya bhatani "OK".

5. Somugumisiro wekugadzirisa kwedu, ndiro yepakutanga yakashanduka kuva "smart" imwe.

6. Isu tinongofanira kuwedzera mbiru itsva kusvika kumagumo etafura. Isu tinongozadza ruzivo rwakakosha nesero chero riri kurudyi rwe "smart" tafura. Iyo column yakazadzwa nedata inozongoita chinhu che "smart tafura". Mafomati ese achachengetedzwa.

Maitiro ekuisa koramu pakati pemakoramu muExcel?

Zvino ngatitaurei zvakadzama nezve nzira yekuisa koramu pakati pemamwe makoramu muExcel spreadsheet. Ngatitarisei muenzaniso chaiwo. Semuenzaniso, isu tine runyorwa rwemitengo isina nhamba yezvinhu. Isu tinofanirwa kuwedzera imwe mbiru pakati pemakoramu kuitira kuti tizadze mutengo wemutengo wezvinhu nhamba. Pane nzira mbiri dzekushandisa nzira iyi.

Maitiro ekutanga nzira ndeokuti:

1. Fambisa chinongedzo chembeva kune cell A1 uye sarudza.
2. Isu tinotamira kune "Kumba" chikamu, icho chiri pamusoro peiyo spreadsheet interface. Isu tinowana block yemirairo inonzi "Masero" uye sarudza iyo "Insert" chinhu.
3. Rondedzero diki yakavhurwa, umo iwe unofanirwa kusarudza iyo "Isa mbiru papepa" chinhu.

4. Ready! Isu takaita kuwedzera kweiyo nyowani isina chinhu yekuwedzera koramu pakati pemakoramu.

Kubudirira kwechipiri nzira ndeyotevera:

1. Tinya kurudyi pane chikamu A.
2. Iyo diki yemukati menyu yakaratidzwa pachiratidziro, umo iwe unofanirwa kusarudza chinhu chinonzi "Insert".

3. Ready! Isu takaita kuwedzera kweiyo nyowani isina chinhu yekuwedzera koramu pakati pemakoramu.

Mushure mekushandisa imwe yenzira mbiri dzakatsanangurwa pamusoro apa, tinogona kutanga kuzadza mutsara wakagadzirwa nenhamba dzematengo emitengo yezvinhu.

Isa makoramu akawanda pakati pemakoramu kamwechete

Kuenderera mberi nemuenzaniso wemutengo uri pamusoro, ngationei kuti tingawedzera sei makoramu akawanda pakati pemakoramu panguva imwe chete. Rondedzero yemitengo haina makoramu maviri: huwandu uye zviyero zvekuyera (zvidimbu, makirogiramu, marita, mapakeji, zvichingodaro). Iyo yekufamba inotaridzika seiyi:

1. Kuti tishandise kuwedzera kwemamwe makoramu maviri, isu tinofanirwa kuita maitiro ekusarudza huwandu hwemaseru maviri. Isu tinosimbisa C2:D

2. Isu tinotamira kune "Kumba" chikamu, icho chiri pamusoro peiyo spreadsheet interface. Isu tinowana block yemirairo inonzi "Masero" uye sarudza iyo "Insert" chinhu. Rondedzero diki yakavhurwa, umo iwe unofanirwa kusarudza iyo "Isa mbiru papepa" chinhu.
3. Ready! Isu takaita kuwedzera makoramu maviri pakati pemakoramu maviri.

Pane imwe nzira yekuita iyi nzira. Iyo yekufamba inotaridzika seiyi:

1. Isu tinosarudza maviri makoramu misoro C uye D.
2. Dzvanya bhatani rekurudyi rembeva. Mamenu akajairika anovhura. Isu tinowana chinhu chinonzi "Insert" uye tinya pachiri neLMB.

3. Ready! Isu takaita kuwedzera makoramu maviri pakati pemakoramu maviri.

Dzimwe nguva zvinoitika kuti mushandisi, paanenge achishanda neruzivo rwetabular, netsaona anowedzera koramu isingakoshi. Ngationei maitiro ekuita nzira yekubvisa. Iyo yekufamba inotaridzika seiyi:

1. Sarudza huwandu hwemasero ane makoramu atinoronga kudzima.
2. Isu tinoenda kuchikamu che "Kumba", tsvaga "Delete" block uye tinya pane chinhu chinonzi "Delete columns kubva papepa." Neimwe nzira, tinya-kurudyi kuti uvhure menyu yemukati uye sarudza iyo "Delete" chinhu.
3. Ready! Isu takaita kubviswa kwemakoramu asina kufanira kubva pane tabular data.

Zvakakosha kuyeuka! Mamwe makoramu anogara achiwedzerwa kuruboshwe kwemakoramu akasarudzwa. Huwandu hwemakoramu matsva hunoenderana nehuwandu hwemakoramu akapihwa pakutanga. Kurongeka kwemakoramu akaiswa kunoenderana nesarudzo yesarudzo (kuburikidza neimwe uye zvichingodaro).

mhedziso

Iyo Excel spreadsheet ine nhamba huru yenzira dzinokutendera kuti uwedzere mamwe makoramu kune chero nzvimbo patafura. Kushandura iyo sosi yedata kuita "smart tafura" inobvumidza iwe kuti uise mamwe makoramu pasina kutambisa nguva pakugadzirisa, sezvo kutaridzika kwemakoramu matsva kunotora pane yakapedzwa tafura fomati. Nzira dzakasiyana-siyana dzekuwedzera makoramu dzinobvumira mushandisi wega wega kuti asarudze yakanakira ivo pachavo.