Share layuka masu ɓoye a cikin Excel. Daya bayan daya kuma gaba daya

A cikin Microsoft Office Excel, zaku iya hanzarta cire ɓoyayyun layukan da ba komai a ciki waɗanda ke ɓata fasalin tsarin tebur. Yadda za a yi hakan za a tattauna a wannan talifin.

Yadda ake cire layuka masu ɓoye a cikin Excel

Akwai hanyoyi da yawa don cika aikin, aiwatar da su ta amfani da daidaitattun kayan aikin shirin. Mafi na kowa daga cikinsu za a tattauna a kasa.

Hanyar 1. Yadda ake share layuka a cikin tebur ɗaya bayan ɗaya ta menu na mahallin

Don jimre wa wannan aiki, ana bada shawarar yin amfani da algorithm mai zuwa:

1. Zaɓi layin da ake so na layin LMB.
2. Danna ko'ina a cikin yankin da aka zaɓa tare da maɓallin linzamin kwamfuta na dama.
3. A cikin mahallin menu, danna kalmar "Share...".

4. A cikin taga da ya buɗe, sanya maɓallin kunnawa kusa da siginar "String" kuma danna "Ok".

5. Duba sakamakon. Ya kamata a cire layin da aka zaɓa.
6. Yi haka don sauran abubuwan faranti.

Kula! Hanyar da aka yi la'akari kuma za ta iya cire ginshiƙan ɓoye.

Hanyar 2. Single uninstallation na Lines ta zabin a cikin shirin kintinkiri

Excel yana da daidaitattun kayan aikin don share sel tsararrun sel. Don amfani da su don share layi, dole ne ku ci gaba kamar haka:

1. Zaɓi kowane tantanin halitta a jere da kake son gogewa.
2. Je zuwa shafin "Gida" a cikin babban panel na Excel.
3. Nemo maɓallin "Share" kuma fadada wannan zaɓi ta danna kan kibiya a dama.
4. Zaɓi zaɓin "Share layuka daga takarda".

5. Tabbatar cewa an cire layin da aka zaɓa a baya.

Hanyar 3. Yadda ake cire duk layukan ɓoye lokaci guda

Hakanan Excel yana aiwatar da yuwuwar cirewar rukuni na abubuwan da aka zaɓa na tsararrun tebur. Wannan fasalin yana ba ku damar cire layin da ba komai a warwatse a sassa daban-daban na farantin. Gabaɗaya, tsarin cirewa ya kasu zuwa matakai masu zuwa:

1. Hakazalika, canza zuwa shafin "Gida".
2. A cikin yankin da ya buɗe, a cikin sashin "Editing", danna maɓallin "Nemo kuma zaɓi".
3. Bayan yin aikin da ya gabata, menu na mahallin zai bayyana wanda mai amfani zai buƙaci danna kan layin "Zaɓi ƙungiyar sel…".

4. A cikin taga da ya bayyana, dole ne ku zaɓi abubuwan da za ku haskaka. A cikin wannan yanayin, sanya maɓallin kunnawa kusa da siginar "Empty Cells" kuma danna "Ok". Yanzu ya kamata a zaɓi duk layukan da ba komai a cikin lokaci guda a cikin teburin tushe, ba tare da la'akari da wurinsu ba.

5. Danna-dama akan kowane layukan da aka zaɓa.
6. A cikin nau'in mahallin mahallin taga, danna kalmar "Share ..." kuma zaɓi zaɓi "String". Bayan danna "Ok" duk abubuwan da aka ɓoye an cire su.

Muhimmin! Hanyar cirewar rukuni da aka tattauna a sama kawai za a iya amfani da shi don cikakken layukan wofi. Kada su ƙunshi kowane bayani, in ba haka ba amfani da hanyar zai haifar da cin zarafi na tsarin tebur.

Hanyar 4: Aiwatar da rarrabawa

Ainihin hanyar, wanda aka yi bisa ga algorithm mai zuwa:

1. Zaɓi taken tebur. Wannan shi ne yankin da za a jera bayanan.
2. A cikin shafin "Gida", fadada sashin "Tsarin da Tace".
3. A cikin taga da ya bayyana, zaɓi zaɓi "Custom sorting" ta danna kan shi tare da LMB.

4. A cikin menu na rarrabuwa na al'ada, duba akwatin kusa da zaɓin "Bayanai na ya ƙunshi kanun labarai".
5. A cikin ginshiƙin oda, ƙididdige kowane zaɓi na rarrabawa: ko dai “A zuwa Z” ko “Z zuwa A”.
6. Bayan kammala rarrabuwa saituna, danna kan "Ok" a kasan taga. Bayan haka, za a jera bayanan da ke cikin tsararrun tebur bisa ga ƙayyadadden ma'auni.

7. Dangane da makircin da aka tattauna a sashin da ya gabata na labarin, zaɓi duk layin da ke ɓoye kuma share su.

Rarraba dabi'u ta atomatik yana sanya duk layukan wofi a ƙarshen tebur.

Ƙarin Bayani! Bayan an tsara bayanan da ke cikin tsararru, ana iya cire abubuwan ɓoye ta hanyar zaɓar su duka kuma danna abin "Share" a cikin menu na mahallin.

Hanyar 5. Aiwatar da tacewa

A cikin maƙunsar bayanai na Excel, yana yiwuwa a tace tsararrun da aka bayar, barin kawai bayanan da ake buƙata a ciki. Ta wannan hanyar zaku iya cire kowane jere daga tebur. Yana da mahimmanci a yi aiki bisa ga algorithm:

1. Yi amfani da maɓallin linzamin kwamfuta na hagu don zaɓar taken tebur.
2. Je zuwa sashin "Data" dake saman babban menu na shirin.
3. Danna maɓallin "Filter". Bayan haka, kibiyoyi za su bayyana a cikin taken kowane ginshiƙi na tsararrun.

4. Danna LMB akan kowace kibiya don fadada jerin abubuwan tacewa.
5. Cire alamun bincike daga ƙimar da ke cikin layin da ake buƙata. Don cire layin mara komai, kuna buƙatar saka lambar serial ɗin sa a cikin tsararrun tebur.

6. Duba sakamakon. Bayan danna "Ok", canje-canje yakamata su fara aiki, kuma abubuwan da aka zaɓa yakamata a goge su.

Kula! Ana iya tace bayanan da ke cikin tsararrun tebur da aka haɗe da sauri ta ma'auni daban-daban. Misali, ta launi ta tantanin halitta, ta kwanan wata, ta sunayen ginshiƙai, da sauransu. An cika wannan bayanin a cikin akwatin zaɓin tacewa.

Kammalawa

Don haka, a cikin Microsoft Office Excel, cire ɓoye layuka a cikin tebur abu ne mai sauƙi. Ba kwa buƙatar zama babban mai amfani da Excel don yin wannan. Ya isa ya yi amfani da ɗaya daga cikin hanyoyin da ke sama, wanda ke aiki ba tare da la'akari da sigar software ba.