Maitiro ekuwedzera akawanda mitsara kamwechete muExcel

Paunenge uchishanda nematafura muMicrosoft Office Excel, zvinowanzodikanwa kuisa mutsara kana mitsara yakawanda pakati petafura yetafura pakati pezvinhu zviri pedyo kuitira kuti uwedzere ruzivo runodikanwa kumushandisi kwavari, nokudaro uchiwedzera ndiro. Maitiro ekuwedzera mitsara kuExcel ichakurukurwa munyaya ino.

Maitiro ekuwedzera mutsara mumwe panguva muExcel

Kuti uwedzere huwandu hwemitsara mune tafura yakatogadzirwa, semuenzaniso, pakati payo, unofanirwa kuita mashoma akareruka algorithm matanho:

1. Shandisa bhatani rekuruboshwe rembeva kusarudza sero riri padivi paro raunoda kuwedzera hutsva hwezvinhu.

2. Tinya-kurudyi panzvimbo yakaratidzwa.
3. Muchinyorwa chinyorwa hwindo, tinya pane "Isa ...".

4. Iyo diki "Wedzera maseru" menyu ichavhura, iyo yaunoda kutsanangura yaunoda sarudzo. Mumamiriro ezvinhu aya, mushandisi anofanira kuisa shanduko mu "String" ndima, uye wobva wadzvanya "OK".

5. Tarisa mhinduro. Mutsara mutsva unofanirwa kuwedzerwa kune nzvimbo yakagoverwa mutafura yepakutanga. Uyezve, iyo yakamira padanho rekutanga, ichave iri pasi pemutsara usina chinhu.

Teerera! Saizvozvo, iwe unogona kuwedzera huwandu hukuru hwemitsara, nguva yega yega uchidaidza menyu yemukati uye kusarudza iyo yakakodzera sarudzo kubva pane rondedzero yehukoshi hwakaunzwa.

Maitiro ekuwedzera mitsara yakawanda kune excel spreadsheet kamwechete

Microsoft Office Excel ine yakavakirwa-mukati yakakosha sarudzo iyo iwe yaunokwanisa kubata nebasa iri munguva ipfupi inobvira. Zvinokurudzirwa kutevedzera mirairo, iyo isingaite kusiyana nendima yapfuura:

1. Mune yekutanga data array, iwe unofanirwa kusarudza akawanda mitsara sezvaunoda kuwedzera. Avo. unogona kusarudza masero atozadzwa kare, haakanganisa chero chinhu.

2. Nenzira imwecheteyo, tinya panzvimbo yakasarudzwa nebhatani rekurudyi mbeva uye muchimiro chechimiro hwindo, tinya pane "Namira ...".
3. Mune inotevera menyu, sarudza iyo "String" sarudzo uye tinya "OK" kusimbisa chiito.
4. Iva nechokwadi chokuti nhamba inodiwa yemitsara yakawedzerwa kune tafura yetafura. Muchiitiko ichi, masero akasarudzwa kare haazobviswa, achave ari pasi pemitsetse isina chinhu yakawedzerwa.

Maitiro ekubvisa akaiswa mitsara isina chinhu muExcel

Kana mushandisi akaisa zvisiri izvo zvinhu patafura, anogona kukurumidza kuzvidzima. Pane nzira mbiri huru dzekuzadzisa basa racho. Dzichakurukurwa mberi.

Zvinokosha! Unogona kudzima chero chinhu muMS Excel spreadsheet. Semuenzaniso, koramu, mutsetse kana sero rakaparadzana.

Nzira 1. Kubvisa zvinhu zvakawedzerwa kuburikidza nemenu yemamiriro ezvinhu

Iyi nzira iri nyore kuita uye inoda mushandisi kutevedzera inotevera algorithm yezviito:

1. Sarudza huwandu hwemitsara yakawedzerwa nebhatani rekuruboshwe.
2. Tinya-kurudyi chero munzvimbo yakasarudzwa.
3. Muchinyorwa chinyorwa hwindo, tinya pane izwi rekuti "Delete ...".

4. Tarisa mhinduro. Mitsetse isina chinhu inofanira kusunungurwa, uye tafura yetafura inodzokera kune yayo yekare fomu. Saizvozvo, iwe unogona kubvisa zvisingakoshi makoramu mutafura.

Method 2: Bvisa chiito chekare

Iyi nzira yakakosha kana mushandisi akadzima mitsara pakarepo mushure mekuwedzera kune iyo tafura array, zvikasadaro zviito zvekare zvichabviswa, uye zvinozofanirwa kuitwa zvakare. Microsoft Office Excel ine bhatani rakakosha rinokutendera kuti ugadzirise nekukurumidza nhanho yapfuura. Kuti uwane uye uite basa iri, unofanirwa kuenderera sezvizvi:

1. Rega kusarudza zvese zvepepa rebasa nekudzvanya LMB pane chero nzvimbo yemahara.
2. Mukona yekumusoro kuruboshwe kwechidzitiro padivi pebhatani re "Faira", tsvaga chiratidzo muchimiro chemuseve kuruboshwe uye tinya pairi neLMB. Mushure meizvozvo, chiito chekupedzisira chakaitwa chichabviswa, kana chiri kuwedzera mitsara, zvino ichanyangarika.

3. Dzvanya bhatani rekumisa zvakare kana zvichidikanwa kuti udzime akati wandei maitiro apfuura.

Mamwe Mashoko! Unogona kumisa nhanho yapfuura muMS Excel uchishandisa Ctrl + Z hotkey musanganiswa nekudzvanya panguva imwe chete kubva pakombuta keyboard. Nekudaro, zvisati zvaitika, unofanirwa kushandura kune dhizaini yeChirungu.

Maitiro ekuwedzera akawanda makoramu kamwechete muExcel

Kuti uite maitiro aya, iwe uchafanirwa kuita anenge matanho akafanana neaya ekuwedzera mitsetse. Iyo algorithm yekugadzirisa dambudziko inogona kukamurwa mumatanho anotevera:

1. Mune tafura yetafura, uchishandisa bhatani rekuruboshwe, sarudza nhamba yemakoramu ane data rakazara raunoda kuwedzera.

2. Tinya-kurudyi chero munzvimbo yakasarudzwa.
3. Mumenu yemukati inooneka, tinya LMB pamutsara "Isa ...".
4. Mufafitera rekuwedzera maseru anovhurwa, sarudza iyo "Column" sarudzo ine toggle switch, uye tinya "OK".

5. Tarisa mhinduro. Empty columns inofanira kuwedzerwa pamberi penzvimbo yakasarudzwa mutafura yetafura.

Teerera! Muhwindo remukati, unofanirwa kudzvanya bhatani rekuti "Isa ...". Kune zvakare yakajairwa "Namira" mutsara, iyo inowedzera iyo yakambokopwa mavara kubva pa clipboard kuenda kune yakasarudzwa sero.

mhedziso

Nekudaro, muExcel zviri nyore kwazvo kuwedzera mitsara yakati wandei kana makoramu patafura yakatogadzirwa. Kuti uite izvi, unofanirwa kushandisa imwe yenzira dzakurukurwa pamusoro apa.