Advanced tace a cikin Excel. Yadda ake nema, yadda ake soke tacewar gaba

Shirin Excel yana da ayyuka da yawa. Tace bayanai aiki ne na gama gari. Yawancin masu amfani suna amfani da tacewa lokacin aiki tare da adadi mai yawa na bayanai, amma ba kowa ba ne ya san cewa akwai ingantaccen tacewa wanda ke ƙara sabbin abubuwa. Daga labarin, za ku gano duk fasalulluka na ci gaba na tacewa kuma ku koyi yadda ake amfani da wannan fasalin mai dacewa.

Menene tace bayanai a cikin Excel

Tace bayanai abu ne mai fa'ida wanda ke ba ka damar rarraba bayanai bisa ƙayyadaddun yanayi, da ɓoye layin da ba dole ba.

Amfani da Advanced Filter a Excel

A ce muna da tebur mai bayanin da ke buƙatar tacewa.

Cikakken umarnin yayi kama da haka:

1. Da farko, muna ƙirƙirar ƙarin tebur na 2, wanda zai ƙunshi yanayin tacewa. Muna yin kwafin kan teburin farko kuma mu manna shi cikin na biyu. Don ƙarin fahimtar misalin, bari mu sanya farantin taimako kaɗan fiye da na asali. Ƙari ga haka, cika sabon da wata inuwa dabam. Ya kamata a lura cewa tebur na biyu za a iya sanya shi a ko'ina ba kawai a kan takardar aiki ba, amma a kan dukan littafin gaba ɗaya.

2. A mataki na gaba, za mu cika ƙarin farantin tare da bayanin da ake bukata don ƙarin aiki. Muna buƙatar alamomi daga teburin tushe, ta inda za mu tace bayanai. A cikin wannan misali, muna buƙatar tace ta jinsin mata da wasanni kamar wasan tennis.

3. Bayan cika ƙarin farantin, za mu ci gaba zuwa mataki na gaba. Muna nuna ma'aunin linzamin kwamfuta zuwa kowane tantanin halitta na tushen ko ƙarin teburi. A cikin babban ɓangaren maɓalli na editan dubawa, mun sami sashin "Data" kuma danna kan shi tare da LMB. Mun sami toshe umarni da ake kira "Tace" kuma zaɓi ɓangaren "Advanced".

4. Wani ƙaramin taga na musamman ya bayyana akan allon, wanda ake kira "Advanced Filter". Anan zaka iya yin saituna daban-daban don ci gaba da tacewa.

5. Wannan kayan aiki yana da amfani guda biyu. Zaɓin farko shine "Kwafi sakamakon zuwa wani wuri" zaɓi na biyu kuma shine "Tace jerin a wurin". Waɗannan ayyukan suna aiwatar da fitarwa daban-daban na bayanan da aka tace. Bambanci na 1st yana nuna bayanan da aka tace a wani wuri a cikin littafin, wanda mai amfani ya rigaya ya ƙayyade. Bambancin na 2 yana nuna bayanan da aka tace a cikin babban faranti. Muna zaɓar abin da ake buƙata. A cikin takamaiman misalinmu, mun sanya alamar bincike kusa da rubutun “Tace lissafin a wurin.” Mu ci gaba zuwa mataki na gaba.

6. A cikin layin "Jerin Lissafi" kuna buƙatar shigar da adireshin farantin tare da kanun labarai. Akwai hanyoyi guda biyu don aiwatar da wannan hanya mai sauƙi. Hanya ta farko ita ce rubuta coordinates na farantin ta amfani da madannai. Na biyu - bayan danna gunkin kusa da layin don shigar da kewayon, kuna buƙatar zaɓar farantin ta hanyar riƙe maɓallin linzamin kwamfuta na hagu. A cikin layin "Range of yanayi" a cikin irin wannan hanya, muna fitar da adreshin ƙarin faranti tare da kanun labarai da layi tare da yanayi. Danna "Ok" don tabbatar da canje-canjen da aka yi.

Muhimmin! Lokacin zabar, yi hankali kada a haɗa kowane sel mara komai a cikin yankin da aka zaɓa. Idan komai a cikin tantanin halitta ya faɗi cikin yankin zaɓi, to ba za a yi aikin tacewa ba. Kuskure zai faru.

7. Bayan kammala aikin, kawai bayanin da muke buƙata zai kasance a cikin babban farantin.

8. Bari mu koma 'yan matakai. Idan mai amfani ya zaɓi zaɓin "Kwafi sakamakon zuwa wani wuri", to, za a nuna alamar ƙarshe a wurin da ya ƙayyade, kuma babban farantin ba zai canza ta kowace hanya ba. A cikin layin "Sakamakon wuri a cikin kewayon" kuna buƙatar tuƙi a cikin adireshin wurin da sakamakon zai nuna. Anan zaka iya shigar da filin guda ɗaya, wanda a ƙarshe zai zama tushen sabon ƙarin farantin. A cikin misalinmu na musamman, wannan ita ce tantanin halitta mai adireshin A42.

9. Ta danna “Ok”, sabon ƙarin faranti tare da ƙayyadaddun saitunan tacewa za a saka a cikin tantanin halitta A42 kuma a shimfiɗa shi zuwa wurin da ke kusa.

Soke babban tacewa a cikin Excel

Akwai hanyoyi guda biyu don soke tacewar gaba. Bari mu yi la'akari da kowace hanya daki-daki. Hanya ta farko don ƙetare manyan tacewa:

1. Mun matsa zuwa sashin da ake kira "Gida".
2. Mun sami block na umarni "Tace".
3. Danna maɓallin "Clear".

Hanya ta biyu, wacce ke soke tacewar ci gaba:

1. Mun matsa zuwa sashin da ake kira "Gida".
2. Danna maɓallin linzamin kwamfuta na hagu akan sashin "Editing"
3. A mataki na gaba, muna buɗe ƙaramin jerin "Nauyi da Tace".
4. A cikin mahallin mahallin da ya bayyana, danna LMB akan abin da ake kira "Clear".

Muhimmin! Idan ƙarin lakabin tare da ingantaccen tacewa yana samuwa a cikin sabon wuri, to, hanyar da aka aiwatar ta hanyar "Clean" kashi ba zai taimaka ba. Dukkan magudin za a buƙaci a yi su da hannu.

Ƙarshe da ƙarshe game da ingantaccen tsarin tacewa

A cikin labarin, mun bincika a matakai da yawa hanyoyi don amfani da ci-gaba tace bayanai a cikin Excel maƙunsar editan. Don aiwatar da wannan hanya mai sauƙi, kawai ana buƙatar sabon ƙarin faranti, wanda za a sami yanayin tacewa. Tabbas, wannan hanyar tana da ɗan wahalar amfani fiye da daidaitaccen tacewa, amma tana aiwatar da tacewa lokaci ɗaya akan ma'auni da yawa. Wannan hanyar tana ba ku damar yin aiki da sauri da inganci tare da babban adadin bayanan tabular.