Yadda ake tace ta kwanan wata a cikin Excel

Tables da aka ƙirƙira a cikin Microsoft Office Excel ana iya tace su ta kwanan wata. Ta hanyar saita tace mai dacewa, mai amfani zai iya ganin kwanakin da yake buƙata, kuma za a rage tsararrun kanta. Wannan labarin zai tattauna yadda ake saita tace ta kwanan wata a cikin Excel ta amfani da kayan aikin da aka gina a cikin shirin.

Yadda ake amfani da tace ta kwanan wata zuwa tsararrun tebur

Akwai daidaitattun hanyoyin da za a iya cika aikin, kowannensu yana da nasa nuances. Don cikakkiyar fahimtar batun, ya zama dole a bayyana kowace hanya daban.

Hanyar 1. Yin amfani da zaɓi na "Filter".

Hanya mafi sauƙi don tace bayanan tabular a cikin Excel, wanda ke nuna algorithm na ayyuka masu zuwa:

1. Ƙirƙirar tebur mai buƙatar tacewa ta kwanan wata. Dole ne wannan jeri ya ƙunshi takamaiman ranaku na wata.

2. Zaɓi teburin da aka haɗa tare da maɓallin linzamin kwamfuta na hagu.
3. Je zuwa shafin "Gida" a saman kayan aiki na babban menu na Excel.
4. Danna maballin "Filter" a cikin zaɓukan panel da ya bayyana. Har ila yau, a cikin wannan sashe akwai aikin "Nau'i", wanda ke canza tsarin nuni na layuka ko ginshiƙai a cikin tebur mai tushe, yana rarraba su ta wasu sigogi.

5. Bayan yin magudin da ya gabata, za a yi amfani da tacewa a kan tebur, watau ƙananan kibiyoyi za su bayyana a cikin sunayen ginshiƙan array, ta danna inda za ku iya buɗe zaɓuɓɓukan tacewa. Anan kuna buƙatar danna kowace kibiya.

6. A cikin mahallin mahallin da ke buɗewa, nemo sashin “Yankin Bincike” kuma zaɓi watan da za a yi tacewa. Waɗancan watanni ne kawai waɗanda ke cikin jeri na asali na tebur ana nunawa anan. Mai amfani yana buƙatar duba akwatin kusa da daidai watan kuma danna "Ok" a ƙasan taga. Yana yiwuwa a zaɓi zaɓuɓɓuka da yawa lokaci guda.

7. Duba sakamakon. Teburin zai ƙunshi bayanai kawai akan watannin da mai amfani ya zaɓa a cikin taga mai tacewa. A sakamakon haka, bayanan da ba su da yawa za su ɓace.

Kula! A cikin menu mai rufin tacewa, zaku iya tace bayanai ta shekara.

Hanyar 2. Yin amfani da zaɓin "Tace ta kwanan wata".

Wannan aiki ne na musamman wanda ke ba ku damar tace bayanai nan da nan a cikin jeri na tebur ta kwanaki. Don kunna shi, kuna buƙatar bin matakai kaɗan:

1. Aiwatar da tacewa a kan tebur na asali ta hanya guda.
2. A cikin taga tacewa, nemo layin "Tace kwanan wata" kuma yi amfani da maɓallin linzamin kwamfuta na hagu don danna kibiya da ke hannun dama.
3. Menu mai saukewa zai buɗe. Anan akwai zaɓuɓɓuka don tace bayanai ta kwanan wata.

4. Misali, danna maballin “Tsakanin…”.
5. Tagan AutoFilter na Custom zai buɗe. Anan, a cikin layi na farko, dole ne ku ƙayyade ranar farawa, kuma a layi na biyu, ranar ƙarshe.

6. Duba sakamakon. Ƙimar da ke tsakanin ƙayyadaddun kwanakin za su kasance a cikin tebur.

Hanyar 3: Tace da hannu

Wannan hanya ce mai sauƙi don aiwatarwa, amma yana ɗaukar lokaci mai yawa daga mai amfani, musamman ma idan kuna aiki tare da manyan tebur. Don saita tacewa da hannu, dole ne ku:

1. A cikin tsararrun tebur na asali, nemo kwanakin da mai amfani baya buƙata.
2. Zaɓi layin da aka samo tare da maɓallin linzamin kwamfuta na hagu.
3. Danna maɓallin "Backspace" daga madannai na kwamfuta don share zaɓaɓɓun ƙimar.

Ƙarin Bayani! A cikin Microsoft Office Excel, zaku iya zaɓar layuka da yawa a cikin tsararrun tebur a lokaci guda don share su nan da nan don adana lokacin mai amfani.

Hanyar 4. Amfani da ci-gaba tace ta kwanan wata

A sama, an yi la'akari da hanyar tace ƙimar a cikin tsararrun tebur dangane da zaɓin "Tsakanin...". Don cikakken bayyana batun, ya zama dole a tattauna zaɓuɓɓuka da yawa don ingantaccen tacewa. Ba daidai ba ne a yi la'akari da duk nau'ikan tacewa a cikin tsarin wannan labarin. Don shafa ɗaya ko wani tace ta kwanan wata zuwa tebur, dole ne ku:

1. Aiwatar da tacewa a kan tebur ta shafin "Gida". Yadda za a yi wannan an bayyana a sama.
2. Fadada jerin abubuwan da aka saukar a cikin taken kowane shafi a cikin tebur kuma danna LMB akan layin "Tace ta kwanan wata".
3. Ƙayyade kowane zaɓin. Alal misali, danna kan layi "Yau".

4. Za a tace bayanan da ke cikin tsararru ta ƙayyadadden kwanan wata. Wadancan. kawai bayanan da kwanan wata zai kasance a cikin tebur. Lokacin saita irin wannan tacewa, Excel za ta kasance ta hanyar kwanan wata da aka saita akan kwamfutar.
5. Ta zaɓar zaɓin “Ƙari…”, mai amfani zai shigar da takamaiman lamba. Bayan haka, jeri na tebur zai ƙunshi kwanakin da suka fi wanda aka ƙayyade. Duk sauran dabi'u za a share su.

Muhimmin! Hakanan ana amfani da sauran zaɓuɓɓukan tacewa na gaba.

Yadda ake gyara tacewa a cikin Excel

Idan mai amfani da gangan ya ƙayyade tace ta kwanan wata, to don soke shi, kuna buƙatar aiwatar da matakai masu zuwa:

1. Zaɓi LMB farantin da ake yin tacewa.
2. Je zuwa sashin "Gida" kuma danna maɓallin "Filter". Menu mai saukewa zai buɗe.
3. A cikin mahallin menu, danna maɓallin "Clear". Bayan yin wannan aikin, za a soke tacewa kuma tsarin tebur zai dawo zuwa ainihin sigarsa.

Kula! Kuna iya soke aikin da aka yi a baya ta amfani da maɓallan "Ctrl + Z".

Kammalawa

Don haka, tace ta kwanan wata a cikin Microsoft Office Excel yana ba ku damar cire kwanakin da ba dole ba na wata daga tebur da sauri. An bayyana manyan hanyoyin tacewa a sama. Don fahimtar batun, kuna buƙatar karanta su a hankali.