Yadda ake cire daskare a cikin maƙunsar bayanai na Excel

Lokacin da dole mu aiwatar da bayanai da yawa, ba sabon abu ba ne a gare mu mu gungura cikin jerin dogayen jeri. Don kiyaye layuka na farko a bayyane, akwai siffa ta musamman da ake kira fiɗaɗɗen layuka. Wannan yana ba ku damar fahimtar, alal misali, wane nau'in tantanin halitta ke cikinsa, ba tare da buƙatar gungurawa takardar ba. Hakanan yuwuwar ita ce game da ginshiƙan tebur. Ana yin gyaran gyare-gyare ta hanyar shafin ko menu "Duba", dangane da sigar ɗakin ofis ɗin da aka yi amfani da shi.

Amma ba dade ko ba dade, mai amfani yana fuskantar buƙatar cire kayan haɗin layi. Wannan na iya zama saboda dalilai daban-daban. Alal misali, an yi gyaran gyare-gyaren don dalilai na fasaha. Bayan an gama aikin akan teburin, maƙalawar ƙila bazai zama dole ba. A wannan yanayin, kuna buƙatar samun damar cire shi. 

Yadda ake kwance layi a Excel

Don haka, menene ya kamata a yi don cire layin a cikin sabbin nau'ikan Excel? Da farko kana buƙatar nemo shafin "View" akan babban panel kuma danna shi tare da linzamin kwamfuta. Bugu da ari a kan kintinkiri, za ku iya ganin maɓalli guda ɗaya wanda muka sanya wuraren a baya. Kuna buƙatar danna shi. Menu mai tasowa zai bayyana. Akwai maballin "Cire wuraren". Bayan mun danna shi, an cire layin mu.

Gabaɗaya jerin ayyuka sun bambanta dangane da wane nau'in Excel da wani mutum ke amfani da shi. A cikin sigar 2003, wannan ya ɗan fi sauƙi, a cikin 2007 da tsofaffi ya fi wahala. 

Yadda ake cire daskare a cikin Excel

Hanyar kwance ginshiƙi a cikin Excel yayi kama da wanda ake amfani da shi don layuka. Hakazalika, muna buƙatar nemo shafin "View" akan babban panel na Excel, bayan haka zamu sami sashin "Window" a can kuma danna maballin daya da ke sama (wanda muka cire layukan layi). Kuma ginshiƙan da ba a daskarewa ana yin su daidai daidai da layuka - ta hanyar maɓallin "Canza yankuna". 

Yadda ake kwance wurin da aka lika a baya a cikin ma'auni na Excel

Idan gabaɗayan yanki an gyara shi a baya, to cire shi ba zai yi wahala ba. Don yin wannan, bi jerin ayyukan da aka kwatanta a sama. Matsakaicin matakan matakai na iya bambanta dangane da sigar Excel, amma dabaru gabaɗaya iri ɗaya ne. Misali, a cikin sigar 2007 da sababbi, ana aiwatar da wannan jerin ayyuka ta hanyar kayan aiki, wanda kuma galibi ake kira ribbon. 

Kuma a cikin sigar 2003, ana yin wannan ta ɗan ɗan bambanta, wanda zamu tattauna dalla-dalla a ƙasa.

Yana da mahimmanci a tuna cewa nau'ikan Excel masu rahusa ba sa ba da ikon daskare da kwance layuka da ginshiƙai. Idan ba zato ba tsammani ya bayyana cewa wannan zaɓi ba a kan tef a wuri mai dacewa ba, kada ku ji tsoro. Kuna iya buƙatar biya don ƙarin ci gaba shirin maƙunsar rubutu. 

Sabanin abin da aka sani, siyan sigar satar fasaha ba zai magance matsalar ba a cikin dogon lokaci. Abun shine ana iya amfani da software mai lasisi a wurin aiki ba tare da haɗarin shiga matsala da doka ba. Bugu da kari, Microsoft koyaushe yana bincika shirye-shiryen da masu amfani ke amfani da su don kasancewar maɓallan fashe. Idan an sami irin wannan gaskiyar, kunnawa ya ɓace.

Yadda ake cire layuka da ginshiƙai

Masu amfani galibi suna sha'awar abin da za a iya yi don cire ginshiƙai da layuka da aka kafa a baya. Ana iya yin wannan tare da aiki ɗaya mai sauƙi. Bugu da ƙari, jerin ayyuka za su yi mamakin gaske tare da sauƙi. To mene ne ya kamata mu yi?

Da farko, buɗe takaddar Excel da ake so. Bayan haka, buɗe shafin "View" kuma a can nemo sashin "Window". Na gaba, za ku ga sashin “Kulle Panes” da kuka gani a baya.

Bayan haka, ya rage kawai don danna maɓallin "Unpin yankunan" button. Kamar yadda kake gani, ayyukan sun yi kama da na baya. 

Yadda ake cire sel a cikin Excel 2003

Excel 2003 ya kasance sanannen shiri ne wanda mutane da yawa ba sa son haɓakawa zuwa mafi na zamani da sigar 2007 mai aiki. Yanzu halin da ake ciki ya kasance akasin haka, irin wannan rashin jin daɗi a kallon farko yanzu yana da kyau ga matsakaita mai amfani. Saboda haka, ƙirar ƙirar 2003 na maƙunsar bayanai ba ta da hankali. 

Don haka, mutane da yawa suna mamakin abin da za a iya yi don cire sel a cikin sigar Excel 2003?

Jerin ayyuka kamar haka:

1. Bude menu na Window.
2. Danna maɓallin "Unpin yankunan" button.

Kamar yadda kake gani, yanzu ya bayyana a fili dalilin da yasa nau'in 2003 na Excel ya shahara sosai. Ya isa kawai don yin dannawa biyu tare da maɓallin linzamin kwamfuta na hagu, kuma ana yin aikin da ake so. Don yin irin wannan aiki a cikin Excel 2007, kuna buƙatar yin dannawa 3. Da alama ɗan ƙaramin abu ne, amma idan dole ne ku aiwatar da waɗannan ayyukan akai-akai, to waɗannan daƙiƙan suna ƙara har zuwa sa'o'i. Bugu da ƙari, agogon gaske ba kwata-kwata ba ne. Yana da sauƙin isa don ƙididdigewa. A wasu bangarorin, sabon tsarin sadarwa na Excel yana da matukar dacewa sosai, amma a irin wadannan bangarorin ba ya jin kamshin ergonomics.

Gabaɗaya, mun ɗan ƙaura daga batun. Bari mu yi magana dalla-dalla game da yadda ake share wurin da aka liƙa. Fiye da daidai, bari mu taƙaita abin da aka riga aka sani.

Cire wurin da aka liƙa

Don haka, mun fahimci yadda za a cire yankin da aka saka. Don yin wannan, yi amfani da menu na "Duba", wanda a cikin Excel 2003 yana cikin babban menu na pop-up kai tsaye a ƙarƙashin maƙallan take, kuma a cikin tsofaffin juzu'i - akan shafin na musamman tare da suna iri ɗaya.

Bayan haka, kuna buƙatar ko dai zaɓi abin “Daskarewa”, sannan danna kan “Buɗe wuraren da aka daskare” ko danna wannan maɓallin nan da nan (zaɓin na ƙarshe shine na yau da kullun ga tsoffin juzu'in ƙirar Excel). 

Bayan haka, za a cire pinning na sel. Komai abu ne mai sauqi qwarai, komai yawan dannawa zaka iya yi.