AutoFilter aiki a cikin Excel. Aikace-aikace da saitin

Lokacin da kake buƙatar nemo layuka ɗaya ko fiye a cikin babban tebur, dole ne ku ciyar da lokaci mai yawa don gungurawa cikin takardar da neman sel masu dacewa da idanunku. Ginin matatar Microsoft Excel a ciki yana sauƙaƙa samun bayanai tsakanin sel da yawa. Bari mu gano yadda ake kunnawa da kashe tacewa ta atomatik, kuma mu bincika yuwuwar da yake ba masu amfani.

Yadda ake kunna AutoFilter a Excel

Akwai hanyoyi da yawa don farawa ta amfani da wannan zaɓi. Bari mu bincika kowannensu a fili. Sakamakon kunna tace zai zama bayyanar maɓallin murabba'i tare da kibiya kusa da kowane tantanin halitta a cikin taken tebur.

1. Shafin Gida ya ƙunshi sassa da yawa. Daga cikin su - "Editing", kuma kana buƙatar kula da shi.
2. Zaɓi tantanin halitta wanda za'a saita tacewa, sannan danna maɓallin "Tsarin da Tace" a wannan sashin.
3. Wani ƙaramin menu zai buɗe inda kake buƙatar zaɓar abu "Tace".

1. Hanya ta biyu tana buƙatar wani shafin a cikin menu na Microsoft Excel - ana kiranta "Data". Yana da wani sashe daban da aka tanada don rarrabuwa da tacewa.
2. Bugu da ƙari, danna kan cell ɗin da ake so, buɗe "Data" kuma danna maɓallin "Tace" tare da hoton mazurari.

Muhimmin! Kuna iya amfani da tacewa kawai idan tebur yana da kan kai. Saita tacewa akan tebur ba tare da kanun labarai ba zai haifar da asarar bayanai a saman jere - za su ɓace daga gani.

Saita tace ta bayanan tebur

Ana amfani da tacewa sau da yawa a cikin manyan teburi. Ana buƙatar don duba layukan rukuni ɗaya cikin sauri, raba su da wasu bayanai na ɗan lokaci.

1. Kuna iya tace bayanai kawai ta bayanan shafi. Bude menu ta danna kibiya a cikin taken shafi da aka zaɓa. Jerin zaɓuka zai bayyana waɗanda za a warware da su.
2. Da farko, bari mu gwada abu mafi sauƙi - cire ƴan alamomi, barin ɗaya kawai.
3. Sakamakon haka, tebur ɗin zai ƙunshi layuka kawai waɗanda ke ɗauke da ƙimar da aka zaɓa.
4. Alamar mazurari zai bayyana kusa da kibiya, yana nuna cewa an kunna tacewa.

Ana kuma aiwatar da rarrabuwa ta hanyar rubutu ko matattarar lamba. Shirin zai bar layi a kan takardar da ta dace da ka'idojin da aka kafa. Misali, tace rubutun "daidai da" yana raba layuka na tebur tare da ƙayyadaddun kalma, "ba daidai ba" yana aiki da sauran hanyar - idan kun saka kalma a cikin saitunan, ba za a sami layuka tare da shi ba. Akwai matattarar rubutu dangane da harafin farko ko ƙarewa.

Ana iya daidaita lambobi ta hanyar tacewa "mafi girma ko daidai", "kasa ko daidai", "tsakanin". Shirin yana iya haskaka lambobi 10 na farko, zaɓi bayanai sama ko ƙasa da matsakaicin ƙimar. Cikakken jerin abubuwan tacewa don rubutu da bayanin lamba:

Idan sel suna inuwa kuma an saita lambar launi, ikon rarrabewa ta launi yana buɗewa. Kwayoyin launi da aka zaɓa suna motsawa zuwa sama. Tace ta launi yana ba ku damar barin akan layuka na allo waɗanda sel waɗanda suke launin launi a cikin inuwar da aka zaɓa daga jerin.

Muhimmin! Na dabam, yana da mahimmanci a lura da aikin "Babba ..." a cikin sashin "Tsarin da Tace". An ƙera shi don faɗaɗa iyawar tacewa. Amfani da ingantaccen tacewa, zaku iya saita yanayi da hannu azaman aiki.

Ana sake saita aikin tace ta hanyoyi biyu. Hanya mafi sauƙi ita ce ta amfani da aikin "Undo" ko danna haɗin maɓallin "Ctrl + Z". Wata hanya kuma ita ce bude bayanan bayanan, nemo sashin "Tsarin da Tace" kuma danna maɓallin "Clear".

Tace na Musamman: Keɓance ta Ma'auni

Ana iya saita tace bayanai a cikin tebur ta hanyar da ta dace ga wani mai amfani. Don yin wannan, zaɓin "Custom filter" yana kunna a cikin menu na autofilter. Bari mu gano yadda yake da amfani da kuma yadda ya bambanta da yanayin tacewa da tsarin ya kayyade.

1. Bude menu na nau'in don ɗaya daga cikin ginshiƙan kuma zaɓi ɓangaren "Tace ta Musamman…" daga menu na tace rubutu/lamba.
2. Tagan saitunan zai buɗe. A gefen hagu akwai filin zaɓin tacewa, a dama kuma akwai bayanai akan tushen abin da za a yi aiki. Kuna iya tace ta ma'auni biyu lokaci guda - shi ya sa akwai filaye guda biyu a cikin taga.

3. Alal misali, bari mu zaɓi tace "daidai" akan layuka biyu kuma saita dabi'u daban-daban - alal misali, 39 akan layi ɗaya da 79 akan ɗayan.
4. Jerin ƙimar yana cikin jerin da ke buɗewa bayan danna kibiya, kuma yayi daidai da abubuwan da ke cikin ginshiƙi inda aka buɗe menu na tacewa. Kuna buƙatar canza zaɓi na cika sharuɗɗan daga "da" zuwa "ko" don aikin tacewa, kuma baya cire duk layuka na tebur.
5. Bayan danna maɓallin "Ok", teburin zai ɗauki sabon salo. Akwai layin da aka saita farashin zuwa 39 ko 79. Sakamakon yayi kama da haka:

Mu lura da aikin tacewa rubutu:

1. Don yin wannan, buɗe menu na tacewa a cikin ginshiƙi tare da bayanan rubutu kuma zaɓi kowane nau'in tacewa - alal misali, "farawa da…".
2. Misali yana amfani da layin autofilter guda ɗaya, amma zaka iya amfani da biyu.

Zaɓi darajar kuma danna maɓallin "Ok".

3. Sakamakon haka, layi biyu da suka fara da waƙar da aka zaɓa suna kan allon.

Kashe AutoFilter ta hanyar Menu na Excel

Don kashe tacewa akan tebur, kuna buƙatar sake kunna menu tare da kayan aikin. Akwai hanyoyi guda biyu don yin wannan.

1. Bari mu bude shafin “Data”, a tsakiyar menu akwai babban maballin “Filter”, wanda bangare ne na bangaren “Sort and Filter”.
2. Idan ka danna wannan maballin, gumakan kibiya za su bace daga kan taken, kuma ba zai yiwu a daidaita layuka ba. Kuna iya kunna tacewa baya idan an buƙata.

Wata hanya ba ta buƙatar motsawa ta cikin shafuka - kayan aikin da ake so yana kan "Gida". Bude sashin "Nauyi da Tace" a hannun dama kuma danna abu "Tace" kuma.

Shawara! Don ƙayyade ko ana kunnawa ko kashewa, zaku iya duba ba kawai a kan teburin tebur ba, har ma a menu. Abun "Tace" yana haskakawa da orange lokacin da aka kunna shi.

Kammalawa

Idan an daidaita autofilter daidai, zai taimaka muku nemo bayanai a cikin tebur mai taken. Tace suna aiki tare da lambobi da bayanan rubutu, wanda ke taimaka wa mai amfani don sauƙaƙe aikin sosai tare da maƙunsar bayanan Excel.