Tace a cikin Excel - Basics

Tace bayanai a cikin Excel yana ba ku damar nunawa tsakanin ɗimbin bayanai kawai abin da kuke buƙata a halin yanzu. Misali, samun jerin dubunnan kayayyaki a cikin babban kantin sayar da kayayyaki a gabanku, zaku iya zaɓar kawai shampoos ko creams daga gare ta, kuma ku ɓoye sauran na ɗan lokaci. A cikin wannan darasi, za mu koyi yadda ake amfani da filtata zuwa jeri a cikin Excel, saita tacewa a kan ginshiƙai da yawa lokaci guda, da kuma cire masu tacewa.

Idan teburin ku ya ƙunshi adadi mai yawa na bayanai, yana iya zama da wahala a sami bayanin da kuke buƙata. Ana amfani da tacewa don taƙaita adadin bayanan da aka nuna akan takardar Excel, yana ba ku damar ganin bayanan da kuke buƙata kawai.

Aiwatar da tacewa a cikin Excel

A cikin misali mai zuwa, za mu yi amfani da matattara zuwa log ɗin amfani da kayan aikin don nuna kwamfyutocin kwamfyutoci da allunan da ke akwai don dubawa.

1. Zaɓi kowane tantanin halitta a cikin tebur, misali cell A2.

Don tacewa don yin aiki daidai a cikin Excel, takardar aikin dole ne ya ƙunshi layin taken da ake amfani da shi don suna kowane shafi. A cikin misali mai zuwa, an tsara bayanan da ke kan takardar aikin azaman ginshiƙai tare da kanun labarai a jere na 1: ID #, Nau'in, Bayanin Iron, da sauransu.

1. danna data, sannan danna umarni Tace.
2. Maɓallin kibiya suna bayyana a cikin taken kowane shafi.
3. Danna irin wannan maɓallin a cikin ginshiƙi da kake son tacewa. A cikin yanayinmu, za mu yi amfani da tacewa zuwa shafi na B don ganin kawai nau'ikan kayan aikin da muke buƙata.
4. Menu tace zai bayyana.
5. Cire alamar akwatin Zaɓi dukdon cire duk abubuwa da sauri.
6. Duba akwatunan don nau'ikan kayan aikin da kuke son barin a cikin tebur, sannan danna OK. A cikin misalinmu, za mu zaɓa kwamfyutocin cinya и Allunandon ganin nau'ikan kayan aiki kawai.
7. Za a tace teburin bayanai, na ɗan lokaci ɓoye duk abun ciki wanda bai dace da ma'auni ba. A cikin misalinmu, kwamfutar tafi-da-gidanka da Allunan kawai sun kasance a bayyane.

Hakanan ana iya amfani da tacewa ta zaɓin umarni Tace sannan tace tab Gida.

Aiwatar da matattara da yawa a cikin Excel

Za a iya taƙaita matattara a cikin Excel. Wannan yana nufin cewa zaku iya amfani da tacewa da yawa zuwa tebur ɗaya don taƙaita sakamakon tacewa. A cikin misalin da ya gabata, mun riga mun tace tebur don nuna kwamfyutoci da kwamfutar hannu kawai. Yanzu aikinmu shine mu taƙaita bayanan har ma da nuna kwamfyutocin kwamfyutoci da allunan da aka ƙaddamar don dubawa a watan Agusta.

1. Danna maɓallin kibiya a cikin ginshiƙi da kake son tacewa. A wannan yanayin, za mu yi amfani da ƙarin tacewa zuwa shafi na D don ganin bayanai ta kwanan wata.
2. Menu tace zai bayyana.
3. Duba ko cire alamar akwatunan dangane da bayanan da kuke son tacewa, sannan danna OK. Za mu cire duk abubuwa sai dai Agusta.
4. Za a yi amfani da sabon tacewa, kuma kwamfutar tafi-da-gidanka da kwamfutocin da aka gabatar don tantancewa a watan Agusta ne kawai za su kasance a cikin tebur.

Cire tacewa a cikin Excel

Bayan shafa matattara, ba dade ko ba dade zai zama dole a cire ko cire shi don tace abubuwan da ke cikin ta wata hanya dabam.

1. Danna maɓallin kibiya a cikin ginshiƙi da kake son cire tacewa daga. A cikin misalinmu, za mu cire tacewa daga shafi na D.
2. Menu tace zai bayyana.
3. Zaɓi abu Cire tacewa daga shafi… A cikin misalinmu, za mu cire tacewa daga ginshiƙi An gabatar da shi don dubawa.
4. Za a cire tacewa kuma bayanan da aka ɓoye a baya zasu sake bayyana a cikin takardar Excel.

Don cire duk masu tacewa a cikin tebur na Excel, danna umarnin Tace tab data.