Otomatiki nhamba ye tambo muExcel. 3 nzira dzekugadzirisa otomatiki nhamba yemitsara muExcel

Kana uchishanda patafura, huwandu hunogona kudikanwa. Izvo zvivakwa, zvinokutendera iwe kuti uzvikurumidze uye kutsvaga data rinodiwa. Pakutanga, chirongwa ichi chatove neyekuverenga, asi iwo maitiro uye haakwanise kuchinjwa. Zvinofungidzirwa kupinda mumugodhi kuti uise huwandu hwakakodzera, asi husina kuvimbika, zvakaoma kushandisa kana uchishanda nematafura makuru. Naizvozvo, mune izvi zvinhu zvatichatarisa matatu anobatsira uye ari nyore-kushandisa tafura yetafura yekuverenga muExcel.

Nzira 1: Nhamba Mushure mekuzadza mitsara yekutanga

Iyi nzira ndiyo iri nyore uye inonyanya kushandiswa kana ichishanda nematafura madiki uye epakati. Zvinotora nguva shoma uye inovimbisa kunze kwekunge chero zvikanganiso mukuverenga. Nhanho-ne-nhanho mirairo yavanotaridzika seizvi:

1. Kutanga iwe unoda kugadzira iyo yakasarudzika ikholamu patafura iyo ichagadzirwa kuti ienderere mberi nekuverenga.
2. Achangosikwa nendori, mumutsara wekutanga, isa iyo nhamba 1 mune yechipiri, uye mune yechipiri mutsara, isa iyo manhamba maviri.

Gadzira iyo kolamu uye zadza masero

1. Sarudza iyo yakazadzwa masero maviri uye hover pamusoro pekona yakadzika yekona yenzvimbo yakasarudzwa.
2. Pangangoita black cross icon inooneka, bata iyo lkm uye kutambanudza nzvimbo yacho kusvika kumagumo etafura.

Tambanudza huwandu pane yese reti tafura

Kana zvese zvikaitwa nenzira kwayo, iyo ikhoramu inoverengeka ichangoerekana yazara. Izvi zvichave zvakakwana kuti uwane mhedzisiro yaunoda.

Mhedzisiro yebasa rakaitwa

Nzira 2: String Operator

Zvino toenda kune inotevera nzira yekuverenga, iyo inoreva kushandiswa kwe "tambo ye" tambo ":

1. Kutanga, iwe unofanirwa kugadzira imwe ikholamu yekuverenga, kana pasina munhu.
2. Mune tambo yekutanga yeiyi ikholamu, pinda iyo formula yezvinhu zvinotevera: = mutsara (A1).

Isu tinosuma formula muchitokisi

1. Mushure mekupinda formula, ive shuwa yekudzvanya iyo "Enter" kiyi, iyo inoshandura basa, uye uchaona nhamba 1.

Zadza iyo cell uye kutambanudza huwandu

1. Iye zvino zvaramba zvakafanana nenzira yekutanga kuunza iyo yekukona kusvika pakona yakadzika yepazasi yenzvimbo yakasarudzwa, mirira iyo dema muchinjiro uye kutambanudza nzvimbo yacho kusvika kumagumo etafura yako.
2. Kana zvese zvikaitwa nenzira kwayo, iyo ikholamu ichazadzwa nekuverenga uye inogona kushandiswa kuwedzera kutsvaga ruzivo.

Isu tinofungidzira mhedzisiro

Pane imwe nzira imwe, mukuwedzera kune nzira yakatarwa. Chokwadi, zvichave zvichidikanwa kushandisa "master mabasa" module:

1. Saizvozvo, gadzira chikamu chekuverenga.
2. Dzvanya pachiteshi chekutanga chetsetse yekutanga.
3. Kubva kumusoro pedyo neThe Yekutsvaga tambo Dzvanya pane iyo "FX" icon.

Activate "tenzi mabasa"

1. Iyo "basa master" inoitwa, umo iwe unofanirwa kudzvanya pane "chikamu" pfungwa uye sarudza "zvinongedzo".

Sarudza zvikamu zvinodiwa

1. Kubva kumabasa akakodzera, iwe uchasarudza iyo "mutsara" sarudzo.

Shandisa iyo "tambo" basa

1. Hwindo rekuwedzera rinoonekwa rekupinda ruzivo. Iwe unofanirwa kuisa iyo isaior kune iyo "Reference" chinhu uye mune inotaura kero yesero rekutanga rekisiti (mune yedu A1).

Zadza iyo inodiwa data

1. Kutenda nezviito zvakaitwa muchitokisi chekutanga chakatanga, manhamba anooneka

Tambanudza basa kune iyo yese reti tafura

Zviito izvi zvichabatsira kuwana zvese zvakakosha nhamba uye zvichabatsira kusavhiringidzwa nematsauve akadai uchishandisa tafura.

Nzira 3: Kushandisa kwekufambira mberi

Uye nzira iyi yakasiyana nezvimwe zvinhu zvinobvisa vashandisi kubva kune chinodiwa chekushandisa iyo Autofile Marker. Uyu mubvunzo wakanyatsokosha kwazvo, sezvo chikumbiro chayo chisingashande kana uchishanda nematafura makuru.

1. Gadzira iyo kolamu yekuverenga uye kucherechedza mune yekutanga cell nhamba 1.

Ita zviito zvakakosha

1. Enda kune Toolbar uye shandisa "Chikamu" chatinoenda ku "Editing" Chidimbu "uye uchitsvaga museve icon pasi (paunogara uchipa zita rekuti" zadza ").

Enda ku "kufambira mberi" basa

1. Mukudonha-pasi menyu iwe unofanirwa kushandisa "kufambira mberi" basa.
2. Muwindo rinoonekwa, zvinotevera zvinofanirwa kuitwa:

Zadza ruzivo rwakakodzera

1. Kana zvese zvikaitwa nenzira kwayo, iwe uchaona mhedzisiro ye otomatiki nhamba.

Zvakagashirwa mhedzisiro

Pane imwe nzira yekuita nzira yekuverenga yakadaro inotaridzika seizvi:

1. Isu tinodzokorora zviito kuti vagadzire chikamu uye mucherechedzo muchitokisi chekutanga.
2. Isu tinogovera iyo yese reti tafura yaunoronga kuverenga.

Isu tinopemberera huwandu hwese hwetafura

1. Enda kune "chikamu chepamba" uye sarudza iyo "yekugadzirisa".
2. Tiri kutsvaga chinhu "zadza" uye sarudza "kufambira mberi".
3. Muwindo rinoonekwa, tinoona zvakafanana data, chokwadi ikozvino hachina kuzadza chinhu icho "muganho zvinoreva".

Zadza data muhwindo rakasiyana

1. Dzvanya pane "Zvakanaka".

Iyi sarudzo inonyanya kuitika, nekuti haidi kuwanda kwekumanikidzwa kwemitsara inoda kuverengeka. Chokwadi, mune chero mamiriro ezvinhu iwe uchafanirwa kugovera huwandu hunofanirwa kuverengerwa.

Zvakagadzirira

Mhedziso

Row kuverenga kuverenga inogona kurerutsa basa netafura inoda kuramba ichidzokorora kana kutsvaga kweruzivo rwaunoda. Nekuda kwemirairo yakatsanangurwa yakatsanangurwa pamusoro apa, unogona kusarudza mhinduro yakanyanya kurongeka yekugadzirisa basa racho.

Message otomatiki nhamba ye tambo muExcel. 3 Nzira dzekugadzirisa otomatiki dzimba dzekutenderera muExcel yakabuda kutanga pane tekinoroji yeruzivo.