Marubucin ba komai bane illa takarda da ke tsara bayanai ta hanyar layuka da ginshiƙai. Kusan kowace ƙungiyar kasuwanci tana amfani da maƙunsar bayanai don kiyaye bayananta da gudanar da ayyuka akan waɗannan bayanan. Hatta makarantu da kwalejoji suna amfani da software na falle don kula da bayanansu. Lokacin da yazo ga software na falle, Microsoft Excel kuma Google sheets sune babbar manhaja da mutane da yawa ke amfani da su. A zamanin yau, ƙarin masu amfani suna zaɓar Google Sheets akan Microsoft Excel yayin da yake adana ma'ajin su akan Cloud Storage, watau Google Drive wanda za'a iya shiga daga kowane wuri. Abinda kawai ake buƙata shine ya kamata a haɗa kwamfutarka zuwa Intanet. Wani babban abu game da Google Sheets shine cewa zaku iya amfani dashi daga taga mai binciken ku akan PC ɗinku.
Idan ya zo ga kiyaye shigarwar bayanai, ɗaya daga cikin al'amuran gama gari da masu amfani da yawa ke fuskanta shine kwafi ko shigarwar kwafi. Misali, yi tunanin kana da bayanan mutanen da aka tattara daga binciken. Lokacin da ka jera su ta amfani da software na falle kamar Google Sheets, akwai yuwuwar kwafin bayanan. Wato, mutum ɗaya zai iya cika binciken fiye da sau ɗaya, don haka Google Sheets zai jera shigarwar sau biyu. Irin waɗannan shigarwar da aka kwafi sun fi damuwa idan ana batun kasuwanci. Yi tunanin idan an shigar da ma'amalar kuɗi a cikin bayanan fiye da sau ɗaya. Lokacin da kuka ƙididdige jimlar kuɗin da wannan bayanan, zai zama matsala. Don guje wa irin waɗannan yanayi, ya kamata mutum ya tabbatar da cewa babu kwafin bayanai a cikin maƙunsar bayanai. Yadda za a cimma wannan? To, a cikin wannan jagorar, zaku tattauna hanyoyi daban-daban guda 6 don cire kwafi a cikin Google Sheets. Ku zo, ba tare da ƙarin gabatarwa ba, bari mu ɗan leƙa cikin batun.
Abubuwan da ke ciki[ boye ]
- Yadda ake Cire Kwafi a cikin Google Sheets?
- Hanyar 1: Amfani da Zaɓin Cire Kwafin Kwafi
- Hanyar 2: Cire Kwafi tare da Formulas
- Hanyar 3: Cire Kwafin shigarwar tare da Tsarin Sharadi
- Hanyar 4: Cire Rubutun Kwafi tare da Teburan Pivot
- Hanyar 5: Amfani da Rubutun Apps
- Hanyar 6: Yi amfani da Ƙara don Cire Kwafi a cikin Google Sheets
Yadda ake Cire Kwafi a cikin Google Sheets?
Rubutun kwafi suna da matukar wahala a yanayin kiyaye bayanan bayanai. Amma ba kwa buƙatar damuwa saboda kuna iya cire abubuwan da aka kwafi daga maƙunsar bayanan ku na Google Sheets. Bari mu ga wasu hanyoyin da zaku iya kawar da kwafi a cikin Google Sheets.
Hanyar 1: Amfani da Zaɓin Cire Kwafin Kwafi
Google Sheets yana da ginanniyar zaɓi don cire shigarwar da ke maimaitawa (shigarwa kwafi). Don amfani da wannan zaɓi, bi hoton da ke ƙasa.
1. Misali, dubi wannan (duba hoton da ke ƙasa). A nan za ku iya ganin cewa rikodin Ajit ana shiga sau biyu. Wannan rikodin kwafi ne.
2. Don cire kwafin shigarwar. zaɓi ko haskaka layuka da ginshiƙai.
3. Yanzu danna kan zaɓin menu da aka lakafta Bayanai . Gungura ƙasa sannan danna kan Cire kwafi zaɓi.
4. Akwatin pop-up zai fito, yana tambayar wane ginshiƙai don tantancewa. Zaɓi zaɓuɓɓukan gwargwadon bukatunku sannan danna kan Cire kwafi maballin.
5. Za a shafe duk kwafin bayanan, kuma abubuwa na musamman zasu kasance. Shafukan Google za su ba ku shawarar adadin kwafin bayanan da aka shafe .
6. A cikin yanayinmu, an cire shigarwar kwafin guda ɗaya (Ajit). Kuna iya ganin cewa Google Sheets ya cire kwafin shigarwar (koma zuwa hoton da ke biyo baya).
Hanyar 2: Cire Kwafi tare da Formulas
Formula 1: UNIQUE
Google Sheets yana da dabara mai suna UNIQUE wanda ke riƙe da bayanai na musamman kuma zai kawar da duk abubuwan da aka kwafi daga maƙunsar bayanan ku.
Misali: = BABBAN (A2:B7)
1. Wannan zai bincika shigarwar kwafin a cikin takamaiman kewayon sel (A2:B7) .
biyu. Danna kowane tantanin halitta mara komai akan maƙunsar bayanan ku kuma shigar da dabarar da ke sama. Google Sheets zai haskaka kewayon sel waɗanda ka ƙididdige su.
3. Google Sheets zai jera na musamman records inda kuka buga dabara. Hakanan zaka iya maye gurbin tsoffin bayanai tare da bayanan musamman.
Formula 2: COUNTIF
Kuna iya amfani da wannan dabarar don haskaka duk shigarwar da aka kwafi a cikin maƙunsar bayanan ku.
1. Misali: Yi la'akari da hoton hoton da ke ƙunshe da shigarwa guda ɗaya.
2. A cikin hoton da ke sama, a cell C2, bari mu shigar da dabara kamar, = COUNTIF(A:A2, A2)>1
3. Yanzu, da zarar an danna maɓallin Shigar, zai nuna sakamakon kamar haka KARYA.
4. Matsar da linzamin kwamfuta da kuma sanya shi a kan ƙananan murabba'i a kasan ɓangaren tantanin halitta da aka zaɓa. Yanzu za ku ga alamar ƙari maimakon siginan linzamin ku. Danna ka riƙe kan wannan akwatin, sannan ka ja shi zuwa tantanin halitta inda kake son nemo abubuwan da aka kwafi. Shafukan Google zai kwafi da dabara ta atomatik zuwa sauran sel .
5. Google Sheet zai ƙara ta atomatik GASKIYA a gaban kwafin shigarwa.
NOTE : A cikin wannan yanayin, mun ƙayyade kamar yadda > 1 (fiye da 1). Don haka, wannan yanayin zai haifar GASKIYA a wuraren da ake samun shigarwa fiye da sau ɗaya. A duk sauran wurare, sakamakon shine KARYA.
Hanyar 3: Cire Kwafin shigarwar tare da Tsarin Sharadi
Hakanan zaka iya yin amfani da tsari na sharaɗi don kawar da kwafin bayanan daga Google Sheets.
1. Da farko, zaɓi saitin bayanan da kuke son aiwatar da tsarin sharaɗi a kansu. Sa'an nan, daga Menu zaži Tsarin kuma gungura ƙasa sannan zaɓi Tsarin sharaɗi.
2. Danna kan Tsara sel idan… akwatin saukarwa, kuma zaɓi Tsarin al'ada zaɓi.
3. Shigar da dabara kamar = COUNTIF(A:A2, A2)>1
Lura: Kuna buƙatar canza bayanan jere & shafi bisa ga Google Sheet ɗin ku.
4. Wannan dabarar za ta tace bayanai daga shafi A.
5. Danna kan Anyi maballin. Idan shafi A ya ƙunshi kowane kwafin bayanan , Google Sheets zai haskaka shigarwar da aka maimaita (kwafi).
6. Yanzu za ka iya sauƙi share wadannan kwafin records.
Hanyar 4: Cire Rubutun Kwafi tare da Teburan Pivot
Kamar yadda allunan pivot ke da sauri-da-amfani da sassauƙa, za ka iya amfani da shi don nemo & kawar da kwafi daga cikin Google Sheet.
Da farko, dole ne ka haskaka bayanai a cikin Google Sheet. Na gaba, ƙirƙirar tebur pivot kuma sake haskaka bayanan ku. Don ƙirƙirar tebur pivot tare da saitin bayanan ku, kewaya zuwa ga Bayanai karkashin Google Sheet menu kuma danna kan Teburin Pivot zaɓi. Za a sa ku tare da akwatin tambayar ko za a ƙirƙiri teburin pivot a cikin takardar da ke akwai ko sabon takarda. Zaɓi zaɓi mai dacewa kuma ci gaba.
Za'a ƙirƙiri teburin pivot ɗin ku. Daga panel a hannun dama, zaɓi Ƙara maballin kusa da Layuka don ƙara layuka daban-daban. Kusa da ƙimar, zaɓi don Ƙara shafi don bincika kwafin ƙimar. Teburin pivot ɗin ku zai jera ƙididdiga tare da ƙididdige su (watau adadin lokutan da ƙimar ke faruwa a cikin takardar ku). Kuna iya amfani da wannan don bincika kwafin shigarwar a cikin Google Sheet. Idan ƙidayar ta fi ɗaya, wannan yana nufin an maimaita shigarwar fiye da sau ɗaya a cikin maƙunsar bayanan ku.
Hanyar 5: Amfani da Rubutun Apps
Wata babbar hanya don kawar da kwafi daga takardunku ita ce ta amfani da Rubutun Apps. An bayar a ƙasa shine rubutun-app don kawar da abubuwan da aka kwafi daga maƙunsar bayanan ku:
|_+_|Hanyar 6: Yi amfani da Ƙara don Cire Kwafi a cikin Google Sheets
Yin amfani da ƙari don kawar da kwafin shigarwar daga maƙunsar bayanai na iya zama da fa'ida. Irin waɗannan kari da yawa sun zama masu taimako. Ɗayan irin wannan shirin ƙarawa shine ƙarawa Abubuwan iyawa mai suna Cire Kwafi .
1. Bude Google Sheets, sannan daga Ƙara-kan menu danna kan Samu add-ons zaɓi.
2. Zaba Kaddamar icon (wanda aka haskaka a cikin hoton allo) don ƙaddamar da G-Suite Kasuwa .
3. Yanzu bincika Kari kana bukatar kuma shigar da shi.
4. Shiga cikin bayanin add-on idan kuna so sannan danna kan Shigar zaɓi.
Karɓi izini masu mahimmanci don shigar da ƙari. Wataƙila dole ne ku shiga tare da takaddun shaidar asusunku na Google. Bayan kun shigar da add-on, zaku iya cire kwafi daga Google Sheets cikin sauƙi.
An ba da shawarar:
- Yadda ake Share Sashe Hutu a cikin Microsoft Word
- Hanyoyi 5 don Saka Alamar Tushen Square a cikin Kalma
- Yadda Ake Rufe Rubutu cikin Sauri a cikin Sheets na Google?
Muna fatan wannan bayanin ya taimaka kuma kun iya a sauƙaƙe cire kwafin shigarwar daga Google Sheets. Idan kuna da wasu shawarwari ko tambayoyi a zuciyarku, yi amfani da sashin sharhi don yi musu.
Elon Decker Elon marubucin fasaha ne a Cyber S. Ya kasance yana rubuta yadda ake jagorori kusan shekaru 6 yanzu kuma ya rufe batutuwa da yawa. Yana son rufe batutuwan da suka shafi Windows, Android, da sabbin dabaru da shawarwari.