Tebur wanda ke ɗauke da layuka mara wofi basa kama da kyau da kyau. Bugu da kari, saboda karin layin, kewayawa akan su na iya zama mai rikitarwa, tunda dole ne ka gungura ta hanyar mafi girma daga sel don tafiya daga farkon tebur zuwa ƙarshen. Bari mu gano waɗanne hanyoyi don cire layin mara lahani a cikin Microsoft Excel, da kuma yadda za'a cire su cikin sauri da sauƙi.
Tsarin daidaitaccen lokaci
Hanya mafi shahara da shahara don share layin komai shine amfani da menu na Excel akan menu. Don cire layuka ta wannan hanyar, zaɓi kewayon sel waɗanda ba su da bayanai, kuma danna-dama. A cikin menu na mahallin da zai buɗe, je zuwa abu "Share ...". Ba za ku iya kiran menu na mahallin ba, amma rubuta a kan gajeriyar hanyar keyboard "Ctrl + -".
Windowaramin taga yana bayyana wanda kuke buƙatar bayyana ainihin abin da muke so mu goge. Mun sanya canjin a cikin "layin". Latsa maɓallin "Ok".
Bayan haka, za a share duk layin da aka zaɓa.
A matsayin madadin, zaku iya zaɓar sel a cikin layin da ya dace, kuma a cikin shafin "Gidan", danna maɓallin "Share", wanda yake a cikin kayan aiki na "Sel" a ƙirar kintinkiri. Bayan haka, share zai fara faruwa ba tare da ƙarin akwatinan maganganu ba.
Tabbas, hanyar tana da sauqi kuma sananne ce. Amma shin ya fi dacewa, mafi sauri da aminci?
Tacewa
Idan layin da ba komai a ciki suke a wuri guda, to cirewarsu zai zama da sauki. Amma, idan sun warwatse ko'ina cikin tebur, to binciken su da cirewa na iya ɗaukar lokaci mai yawa. A wannan yanayin, rarrabawa ya kamata ya taimaka.
Zaɓi duka tebur. Mun danna shi tare da maɓallin linzamin kwamfuta na dama, kuma zaɓi abu "tsara" a menu na mahallin. Bayan haka, wani menu ya bayyana. A ciki akwai buƙatar zaɓi ɗayan abubuwa masu zuwa: "A ware daga A zuwa Z", "Daga ƙaramin zuwa mafi girma", ko "Daga sabo zuwa tsofaffi." Wanne daga cikin abubuwan da aka lissafa zai kasance cikin menu ya dogara da nau'in bayanan da aka sanya a cikin sel tebur.
Bayan an yi wannan aikin da ke sama, za a tura duk ƙwayoyin komai a cikin ƙarshen teburin. Yanzu, zamu iya cire waɗannan sel ta kowace hanyar da aka tattauna a farkon sashin darasin.
Idan tsari na sanya sel a cikin tebur yana da mahimmanci, to, kafin a ware, saka wani shafi a tsakiyar teburin.
Dukkanin kwayoyin wannan shafin suna lissafinsu da tsari.
Bayan haka, saita kowane sauran shafi, sannan ka goge sel ɗin da aka sauka ƙasa, kamar yadda aka riga aka bayyana a sama.
Bayan haka, don dawo da tsarin jere a kan wanda ya rigaya kafin rarrabewa, muna warware a cikin shafi tare da lambobin layi "Daga ƙarami zuwa matsakaici".
Kamar yadda kake gani, layin suna layi cikin tsari iri ɗaya, ban da waɗanda ba komai waɗanda aka goge su. Yanzu, dole ne mu share shafin da aka kara tare da lambobin serial. Zaɓi wannan shafi. Saika danna maballin akan kifin "Share". A cikin menu wanda yake buɗe, zaɓi abu "Share ginshiƙai daga takardar". Bayan haka, za a share shafi da ake so.
Darasi: Tarar a Microsoft Excel
Aikace-aikacen matattara
Wani zabin don ɓoye ƙwayoyin wofi shine amfani da tacewa.
Zaɓi duk yankin teburin, kuma, wanda yake a cikin shafin "Gidan", danna maɓallin "Tsara da Filin", wanda ke cikin toshe kan "Shirya" saiti. A cikin menu wanda ya bayyana, je zuwa "Filter" abu.
Alamar halayyar tana bayyana a cikin sel na tebur. Danna wannan alamar a kowane shafi na zabi.
A cikin menu wanda ya bayyana, ɓo alamar "Babu komai". Latsa maɓallin "Ok".
Kamar yadda kake gani, bayan wannan, duk layin komai ya lalace, tunda aka tace su.
Darasi: Yadda zaka yi amfani da injin sarrafa kansa a Microsoft Excel
Zaɓin Maɓallin tantanin halitta
Wata hanyar sharewa tana amfani da zaɓi na rukuni na sel marasa komai. Don amfani da wannan hanyar, da farko zaɓi teburin gaba ɗaya. Bayan haka, kasancewa cikin maɓallin "Gida", danna maɓallin "Find da Select", wanda ke kan kintinkiri a cikin rukunin kayan aiki "Gyara". A cikin menu wanda ya bayyana, danna kan abu "Zaɓi rukuni na sel ...".
Wani taga yana buɗewa wanda muke canza juyawa zuwa matsayin "komai sel". Latsa maɓallin "Ok".
Kamar yadda kake gani, bayan wannan, duk layuka dauke da sel marasa lahani an fifita su. Yanzu danna maɓallin "Share", wanda ya riga ya saba da mu, wanda yake a kan kintinkiri a cikin ƙungiyar kayan aiki.
Bayan haka, za a share duk layuka komai a tebur.
Mahimmin sanarwa! Ba za a iya amfani da hanyar ta ƙarshe a cikin tebur tare da kewayon jeri ba, kuma tare da sel marasa kan gado waɗanda ke cikin layuka inda bayanai suke. A wannan yanayin, canjin kwayar halitta na iya faruwa kuma teburin zai fashe.
Kamar yadda kake gani, akwai hanyoyi da yawa don cire ƙwayoyin wofi daga tebur. Wace hanya ce mafi kyau don amfani da ita ya dogara da hadaddun tebur, da kuma yadda za a warwatse layuka mara lafuzzan a kewayenta (ana zaune cikin falo ɗaya, ko kuma gauraye da layuka cike da bayanai).
