Maitiro ekuchinja tafura pasi muExcel

Chero ani zvake anoshanda kwenguva yakareba aine matafura ekunyepedzera, zviso zviso iwe paunofanirwa kuendesa imwe kana madonhwe emakonzo pasi. Izvi zvinogona kunge zvichikonzerwa nenyaya yekuti nhamba yakakura yedata inofanirwa kuitwa kunzvimbo yekushanda kana iwe unofanirwa kuenzanisa matafura ehotera (makoramu) pakati pavo. Iko hakuna chishandiso chakaparadzana chekuita chiito ichi muExcel. Nekudaro, izvi zvinogona kuitwa nekusanganisa kugona kwechirongwa ichi pakati pavo. Pane nzira dzakaratidzwa dzekufambisa tafura hurukuro yakawanda mune ino nyaya.

Kutamisa imwe kana anopfuura makoramu kuburikidza ne "akacheka" uye "kopi" basa + "paste"

Iyo yakazotaurwa uye inonyanya kufarirwa nzira yekufambisa tafura pasi kana mamwe mapato - kuburikidza ne "akacheka" uye "paste" basa. Nekudaro, zvakakosha kuti uzive kuti maitiro acho achange akasiyana zvichienderana neiyo imwe ikoramu kana tafura yese ichashandurwa. Maitiro ekufambisa imwe ikholamu:

1. Pakutanga, iwe unofanirwa kuratidza chikamu chose neruzivo. Kuita izvi, tinya pane yechiLatin tsamba mumusoro wayo.
2. Kucheka chikamu, unogona kudzvanya iyo kiyi musanganiswa - Ctrl + x. Sarudzo yechipiri ndeyekudaidza mamiriro emenyu nekudzvanya bhatani rekurudyi mbeva pamwe necumn musoro, sarudza "kucheka" basa.

Shandisa "kucheka" basa kune chimwe chinhu chidiki chidiki

1. Iyo mbeva inojekeswa kwaunoda kufambisa iyo ikholamu. Dzvanya PKM, sarudza iyo "isa yakatemwa akacheka" basa.
2. Iyo yakasarudzwa yekutanga chinhu chetafura yekushanda ichaendeswa kunzvimbo yakasarudzwa.

Kuti udzore mhuru dzinoverengeka padanho kamwechete, unogona kushandisa imwe ye nzira nhatu:

1. Uchishandisa mabasa - "Copy" + isa "+" Delete "(Zvakawandisa zvasara).
2. Uchishandisa mirairo - "Cheka" + "isa".
3. Kudhonza mbeva.

Maitiro ekutamisa tafura imwe chete kana anopfuura emirairo kuburikidza nemirairo "kopi" + isa "+" Delete ":

1. Chekutanga pane zvese, iwe unofanirwa kuratidza imwe kana more makoramu iwe unofanirwa kufamba. Iwe unogona kuiita mbeva kana kuburikidza nekiyi pane keyboard .

Kugoverwa kwemasero idzo chete azere nedzimwe data

1. Tevere, zvinodikanwa kuti utarise nzvimbo iyo patafura yaunoda kufambisa iyo yakazvitsaurira huwandu neiyo data (kudzvanya bhatani rekuruboshwe). Dzvanya PCM panzvimbo yakasarudzwa, kubva pamhaurirwo menyu, sarudza iyo "isa coped cell masero" basa.

Kuwedzera iyo yakazvitsaurira kune iyo inodiwa tafura nzvimbo

1. Chiitiko chekupedzisira chaunoda kuti uongorore iyo kirabhu yekutanga neiyo data, tinya PCM kuti ufonere mamiriro emenyu, tinya bhatani re "Delete".

Fambisa tafura yetsandanyama

Nzira iri nyore yekufambisa mhodzi yemunhu kana pakarepo muTallple tafura - kudhonza mbeva. Maitiro:

1. Iyo mbeva yakagoverwa imwe kana zvimwe makoramu. Kana iwe ukasanganisa lkm neiyo shift bhatani, unogona kukurumidza kumaka huwandu.
2. Cheka cuuse curtor kusvika kumuganhu wekamuri kana iyo yakanyorwa, iyo ichachinjika. Izvo zvakakosha kumirira kutaridzika kwemufananidzo wemuchinjiro nemiseve kudzika mumisiyano dzakasiyana.
3. Tevere, iwe unofanirwa kubata kiyi yekuchinja, dhonza huwandu hwehuwandu umo iwe unofanirwa kuzvishandura kuti ive muganho wakasarudzwa.

Kana 1 kana akati wandei makoramu anozununguka kunzvimbo yaunoda, iwe unofanirwa kusunungura bhatani re mbeva uye kiyi yekuchinja.

Shandisa Macros

Vashandisi vane mwero yakakwirira yebasa neexcel matafura anongoshandisa macro anokosha kuti afambise zvinhu zvega zvefurafura, yakatsaurwa kubva kunzvimbo dzinoratidzwa. Kuita izvi maitiro, iwe unofanirwa kunyorera vba macro. Nekudaro, nzira iyi ine yakakosha dhidha. Nguva yakareba inguva yekugadzirisa macro kune iyo column kana yakanyorwa huwandu kuti iendeswa kunzvimbo yaunoda.

Fambisa imwe kana anopfuura tafura mitsara

Kutarisirwa kwakakosha kunofanirwa kupihwa kune imwe nzira yakajairika - kudzikisira pasi-kumusoro imwe kana anopfuura tafura mitsara. Maitiro ekufambisa mutsara mumwe:

1. Dzvanya bhatani rekuruboshwe mbeva nehuwandu hwetsetse iyo inofanirwa kufambiswa (iyo huwandu nehuwandu hwakawanikwa kuruboshwe rwetafura).
2. Mushure mekunge iyo yakasarudzwa munda ichiratidzika, donhedza mbeva ine yakarongedzwa lkm kune iyo nhamba yaunoda yemitsara pasi.

Kana mutsara wakasarudzwa uri munzvimbo yaunoda, iwe unofanirwa kuburitsa bhatani re mbeva. Maitiro ekufambisa mitsara yepedyo:

1. Kuruboshwe-tinya pane yekutanga nhamba yenhamba kubva kune renji. Dzvanya iyo Shift kiyi.
2. Peta mbeva kuti utange tafura tafura.
3. Sunungura iyo Shift BUTTON mushure memitsetse inodiwa inoonekwa.

Mushure meizvozvo, inosara yekudzvanya LKM pane chero nhamba yemitsetse yakasarudzwa, chinja huwandu hwese pasi. Maitiro ekudzikama pasi pasi akati wandei anowanikwa zvakasiyana kubva kune mumwe nemumwe:

1. Dzvanya bhatani reCTRL.
2. Kuruboshwe mbeva bhatani chiratidzo manhamba ese anofanirwa kufambiswa.

Dzvanya iyo LKM pane chero nhamba yemitsetse yakasarudzwa, uvaite kune imwe nzvimbo pasi, regai kubatani bhatani re mbeva.

Mhedziso

Maitiro ekufambisa tafura yekushanda kana rombo rakazvipira rakanyanyooma, kana iwe usingazive nzira yekubatanidza iyo yakakosha mabasa ebetseri. Zviri nyore kwazvo kudzinga zvinhu zvega zvezvinhu zvekushanda kuruboshwe kana kurudyi. Nekudaro, zvainzwisisa nemaitiro ekufambisa zvimwe mufungo, mune chekuita kuti hapana chakaoma.

Mharidzo seyekupedzisira fambisa tafura yekudzika yakaonekwa yekutanga kune tekinoroji yeruzivo.