Kayan iya ƙirƙirar ɓangaren litattafai a cikin Excel a cikin littafi guda ɗaya zai iya ba da damar ƙirƙirar takardu da yawa a cikin fayil ɗaya, kuma, idan ya cancanta, haɗi da su tare da nassoshi ko dabara. Tabbas, wannan yana ƙara haɓaka aikin wannan shirin kuma yana ba ka damar fadada yanayin da ayyuka ke. Amma wani lokacin ya faru cewa wasu daga cikin takardun da ka ƙirƙiri ɓacewa ko duk gajerun hanyoyi a cikin matsayi na mashi ya ɓace. Bari mu gano yadda za a dawo da su.
Fusoshin farfadowa
Hanya tsakanin ɗakunan littafi ya ba ka damar ɗaukar gajerun hanyoyi da suke a gefen hagu na taga sama da matsayi na matsayi. Za mu yi la'akari da tambaya game da dawo da su a yayin hasara.
Kafin mu fara nazarin algorithm dawowa, bari mu ga dalilin da yasa zasu iya ɓacewa. Akwai dalilai guda hudu da ya sa wannan zai iya faruwa:
- Kashe barikin gajeren hanya;
- Abubuwan da aka boye a bayan gefen gungura mai kwance;
- An fassara alamomi guda ɗaya zuwa ɓoyayye ko ɓoyayye;
- Uninstall.
A dabi'a, kowanne daga cikin wadannan abubuwa yana haifar da matsala da ke da algorithm kansa.
Hanyarka 1: Gyara bargon gajeren hanya
Idan sama da matsayi na matsayi babu matakan gajerun hanyoyi a wurinsu, ciki har da lakabin mai aiki, wannan yana nufin cewa nuni ne kawai ya kashe wanda ke cikin saitunan. Ba za a iya yin wannan ba don littafin yanzu. Wato, idan ka bude wani fayil na Excel tare da wannan shirin, kuma ba a canza saitunan da aka sa a cikinta ba, za a nuna hanyar barci ta hanya a ciki. Nemo yadda zaka iya sake ganin ganuwa idan har kwamitin ya ƙare a cikin saitunan.
- Jeka shafin "Fayil".
- Gaba, muna matsa zuwa sashe. "Zabuka".
- A cikin maɓallin zaɓi na Excel wanda ya buɗe, je shafin "Advanced".
- A gefen dama na taga wanda ya buɗe, akwai saitunan Excel daban-daban. Muna buƙatar nemo wani ɓangaren saitunan "Nuna zabin don littafin na gaba". A cikin wannan toshe akwai matsala "Nuna alamun takarda". Idan babu alamar dubawa a gabansa, to, ya kamata a shigar. Kusa, danna maballin "Ok" a kasan taga.
- Kamar yadda zaku iya gani, bayan yin aikin da aka sama, ana nuna maɓallin hanyar gajeren hanya a cikin littafin littafin Excel na yanzu.
Hanyar 2: motsa maɓallin gungura
Wani lokaci akwai lokuta lokacin da mai amfani ba zana kwashe gungumen gungura a gefen gajeren hanya ba. Saboda haka, sai ya boye su, bayan haka, lokacin da aka bayyana wannan gaskiyar, bincike mai tsanani ya nuna dalilin da ya sa babu takardun shaida.
- Don magance matsalar wannan abu ne mai sauƙi. Saita siginan kwamfuta a hannun hagu na gungumen gungura mai kwance. Ya kamata a juya zuwa arrow arrowrectional. Riƙe maɓallin linzamin hagu kuma ja mai siginan kwamfuta zuwa dama har sai duk abubuwan da ke kan panel suna nunawa. A nan ma yana da mahimmanci kada ku ci gaba da shi kuma kada ku sanya maɓallin gungurawa ƙananan ƙananan, saboda ana buƙatar ta nema ta hanyar daftarin aiki. Sabili da haka, ya kamata ka daina janye tsiri a duk lokacin da aka bude dukkan panel.
- Kamar yadda kake gani, ana sake nunawa a kan allon.
Hanyar 3: Gyara nuni na alamu na ɓoye
Hakanan zaka iya boye takardun kowanne. A lokaci guda, za a nuna panel da wasu gajerun hanyoyi a kai. Bambanci tsakanin abubuwa boye da abubuwa masu nisa shine cewa, idan an so, ana iya nuna su koyaushe. Bugu da ƙari, idan a takarda ɗaya akwai dabi'u waɗanda suke janye ta hanyar samfurori da ke cikin ɗayan, to, a cikin batun shafe wani abu, waɗannan ƙididdiga zasu fara nuna wani kuskure. Idan an raba kashi a ɓoye, to, babu canje-canje a cikin aikin da za'a yi, amma kawai gajerun hanyoyi don miƙa mulki ba zasu kasance ba. A cikin sauƙi mai mahimmanci, abu zai kasance a cikin nau'i guda kamar yadda yake, amma kayan aiki masu gujewa don yin tafiya zuwa gareshi zasu shuɗe.
Hanyar ɓoyewa yana da sauki. Kana buƙatar danna-dama a kan gajeren hanya mai dacewa kuma a cikin menu da aka bayyana aka zaɓi abu "Boye".
Kamar yadda kake gani, bayan wannan aikin, za a ɓoye abin da aka zaɓa.
Yanzu bari mu kwatanta yadda zaku nuna alamar da aka ɓoye. Wannan ba shi da wuya fiye da ɓoye su da kuma mahimmanci.
- Mu danna-dama a kowane gajeren hanya. Yanayin mahallin ya buɗe. Idan akwai abubuwa masu ɓoye a cikin littafin yanzu, to, abu yana aiki a cikin wannan menu. "Nuna ...". Danna kan shi tare da maɓallin linzamin hagu.
- Bayan da latsawa, ƙananan taga yana buɗewa, wanda aka ajiye jerin zane-zane a wannan littafin. Zaɓi abin da muke so mu nuna a kan panel. Bayan wannan latsa maɓallin "Ok" a kasan taga.
- Kamar yadda kake gani, ana sake nuna lakabin abin da aka zaɓa a kan kwamitin.
Darasi: Yadda zaka boye takarda a Excel
Hanyar 4: Nuna Fayilolin Fari Na Farko
Bugu da ƙari ga shafukan da aka boye, akwai har yanzu suna ɓoye. Sun bambanta da na farko a cikin cewa ba za ka sami su a cikin jerin sunaye na nuna abin da aka ɓoye akan allon ba. Ko da muna da tabbacin cewa wannan abu ya wanzu kuma babu wanda ya share shi.
Ta wannan hanyar, abubuwa zasu iya ɓacewa kawai idan wani ya ɓoye su ta hanyar VBA macro edita. Amma don samun su kuma mayar da nuni a kan kwamitin ba shi da wahala idan mai amfani ya san algorithm na ayyuka, wanda zamu tattauna a kasa.
A cikin yanayinmu, kamar yadda muka gani, a kan panel babu sunayen da aka rubuta na hudu da na biyar.
Kunna zuwa taga don nuna abubuwan ɓoye, hanyar da muka yi magana a cikin hanyar da ta wuce, mun ga cewa sunan kawai na huɗu shine aka nuna a ciki. Saboda haka, yana da shakka a ɗauka cewa idan ba a cire takardar biyar ba, to an ɓoye shi ta hanyar kayan aikin VBA.
- Da farko, kana buƙatar kunna yanayin macro da kunna shafin "Developer"wanda aka lalace ta tsoho. Kodayake, idan a cikin wannan littafi akwai wasu abubuwa da aka sanya matsayi na asali, to, yana yiwuwa an riga an aiwatar da wadannan hanyoyin a cikin shirin. Amma, kuma, babu tabbacin cewa bayan abubuwan ɓoyewa, mai amfani da ya yi wannan, kuma bai ƙyale kayan aikin da za a iya ba da damar nuna girman ɗakunan ɓoye ba. Bugu da ƙari, yana yiwuwa yiwuwar haɗa ƙananan hanyoyi ba a kan kwamfutar da suke boye ba.
Jeka shafin "Fayil". Kusa, danna kan abu "Zabuka" a cikin menu na tsaye a gefen hagu na taga.
- A cikin maɓallin zaɓi na Excel wanda ya buɗe, danna kan abu Ribbon Saita. A cikin toshe "Babban shafuka"wanda yake a gefen dama na taga wanda ya buɗe, saita sifa, idan ba, kusa da saiti ba "Developer". Bayan hakan zuwa yankin "Cibiyar Gidan Tsaro"ta amfani da menu na tsaye a gefen hagu na taga.
- A farkon taga danna maballin. "Cibiyar Tsaron Tsaro Zabuka ...".
- Gudun taga "Cibiyar Gidan Tsaro". Je zuwa sashen "Zaɓuɓɓukan Macro" ta hanyar menu na tsaye. A cikin asalin kayan aiki "Zaɓuɓɓukan Macro" saita canzawa zuwa matsayi "Haɗa dukkan macros". A cikin toshe "Zaɓuɓɓukan Macro don mai haɓakawa" duba akwatin "Tabbatacciyar Samun Samun Hanya na Model VBA". Bayan aiki tare da macros an kunna, danna kan maballin. "Ok" a kasan taga.
- Komawa zuwa saitunan Excel domin duk canje-canje zuwa saitunan sunyi tasiri, kuma latsa maballin "Ok". Bayan haka, za a kunna maƙallan mai aiki da macros.
- A yanzu, don bude editan macro, koma zuwa shafin "Developer"cewa mun kunna. Bayan haka a kan tef a cikin asalin kayan aiki "Code" danna babban icon "Kayayyakin Gida".
Za a iya fara maɓallin macro ta hanyar buga gajeren hanya na keyboard Alt F11.
- Bayan haka, maɓallin editan macro zai buɗe, a gefen hagu na yankunan "Shirin" kuma "Properties".
Amma yana yiwuwa yiwuwar waɗannan wurare ba su bayyana a cikin taga da ke buɗewa ba.
- Don ba da nuni ga yanki "Shirin" danna kan abun da ke cikin kwance "Duba". A cikin jerin da ya buɗe, zaɓi matsayi "Mafarin Bincike". A madadin, za ka iya danna maɓallin haɗari mai zafi. Ctrl + R.
- Don nuna yankin "Properties" danna maɓallin menu a sake "Duba", amma wannan lokaci a cikin lissafin da muka zaɓi matsayi "Window Properties". Ko, a madadin haka, za ka iya danna maɓallin aikin kawai. F4.
- Idan wani yanki ya hau wani, kamar yadda aka nuna a cikin hoton da ke ƙasa, to kana buƙatar saita siginan kwamfuta a iyakar yankunan. A daidai wannan lokacin, dole ne a canza shi a cikin arrow arrow. Sa'an nan kuma ka riƙe maɓallin linzamin hagu kuma ja iyakokin domin dukkanin yankunan suna cikakke a cikin maɓallin editan macro.
- Bayan haka a yankin "Shirin" zaɓi sunan ɓoyayyen ɓoyayyen, wanda baza mu iya samun ko dai a kan panel ko a cikin jerin gajerun hanyoyi masu ɓoye ba. A wannan yanayin shi ne "Sheet 5". A lokaci guda a yankin "Properties" yana nuna saitunan wannan abu. Muna sha'awar wannan abu "Ganuwa" ("Ganuwa"). A halin yanzu, ana saita saitin gaban shi. "2 - xlSheetVeryHidden". Fassara zuwa Rasha "Mafi Hannu" yana nufin "ɓoye sosai", ko kamar yadda muka bayyana a baya "super-boye". Don canza wannan sigin kuma sake dawowa zuwa lakabin, danna kan maƙallan zuwa hannun dama.
- Bayan haka, lissafin yana bayyana tare da zaɓuɓɓuka uku don matsayi na takarda:
- "-1 - xlSheetVisible" (bayyane);
- "0 - xlSheetHidden" (boye);
- "2 - xlSheetVeryHidden" (super boye).
Domin hanyar gajeren hanya ta sake nunawa a kan panel, zaɓi matsayi "-1 - xlSheetVisible".
- Amma, kamar yadda muka tuna, har yanzu ana boye "Sheet 4". Tabbas, ba zane-bane ba saboda haka za'a iya saita nuni tare da Hanyar 3. Zai zama ma sauƙi kuma mafi dacewa. Amma, idan muka fara magana game da yiwuwar hada da alamun gajeren hanyoyi ta hanyar editan macro, bari bari mu ga yadda za a iya amfani da shi don mayar da abubuwan da aka ɓoye.
A cikin toshe "Shirin" zaɓi sunan "Sheet 4". Kamar yadda muka gani, a yankin "Properties" gaba aya "Ganuwa" saita zaɓi "0 - xlSheetHidden"wanda ya dace da abu na asali. Danna maɓallin triangle zuwa hagu na wannan saitin don canza shi.
- A cikin jerin sigogi wanda ya buɗe, zaɓi abu "-1 - xlSheetVisible".
- Bayan mun kafa nuni na duk abubuwan boye a kan panel, za ka iya rufe editan macro. Don yin wannan, danna maɓallin kusa kusa da shi a cikin hanyar gicciye a kusurwar dama na taga.
- Kamar yadda kake gani, yanzu duk alamu suna nunawa a cikin kwamitin Excel.
Darasi: Yadda za a iya taimakawa ko musanya macros a Excel
Hanyar 5: Sauke Fayilolin Ana Share
Amma sau da yawa yakan faru cewa alamun sun ɓace daga kwamitin kawai saboda an cire su. Wannan shine babban zaɓi mai wuya. Idan a cikin lokuta da suka gabata, tare da daidaitaccen algorithm na ayyuka, yiwuwar sake dawo da nuni na alamu shine 100%, to, idan an share su, babu wanda zai iya tabbatar da wannan sakamako mai kyau.
Ana cire hanyar gajeren hanya mai sauƙi ne kuma mai mahimmanci. Danna danna kawai tare da maɓallin linzamin linzamin dama sa'annan a cikin menu da aka bayyana ya zaɓi zaɓi "Share".
Bayan haka, gargadi game da sharewa yana bayyana a cikin hanyar maganganu. Don kammala hanyar, kawai latsa maballin. "Share".
Ajiye abu mai goge yana da wuya.
- Idan kun saka lakabi akan shi, amma ku gane cewa kunyi banza kafin ku ajiye fayil din, kuna buƙatar rufe shi ta danna kan maɓallin daidaitaccen don rufe takardun a cikin kusurwar dama na taga a cikin hanyar gicciye a gilashin ja.
- A cikin akwatin maganganu wanda ya buɗe bayan wannan, danna kan maballin Kar a ajiye.
- Bayan ka sake bude wannan fayil ɗin, abin da aka share zai kasance.
Amma ya kamata ku kula da gaskiyar cewa mayar da takarda a wannan hanya, za ku rasa duk bayanan da aka shigar a cikin takardun, tun lokacin da ta ƙarshe ya ajiye. Wannan shine, a gaskiya, mai amfani yana da zabi tsakanin abin da yake da mahimmanci a gare shi: abun da aka share ko bayanan da ya gudanar don shigarwa bayan ƙarshe.
Amma, kamar yadda aka ambata a sama, wannan zaɓi na dawowa ya dace ne kawai idan mai amfani ba shi da lokaci don ajiye bayanan bayan sharewa. Menene za a yi idan mai amfani ya ajiye takardun ko koda ya bar shi tare da ajiyewa?
Idan, bayan cire lakabin, kun rigaya ya ajiye littafin, amma ba su da lokaci don rufe shi, wato, yana da mahimmanci don shiga cikin fayilolin fayil.
- Don zuwa mai duba mai kallo, matsa zuwa shafin. "Fayil".
- Bayan haka je yankin "Bayanai"wanda aka nuna a menu na tsaye. A cikin ɓangaren ɓangaren ɓangaren da aka buɗe akwai asibiti. "Harsuna". Ya ƙunshi jerin dukan nau'in wannan fayil ɗin, wanda aka ajiye tare da taimakon kayan aiki Excel. Wannan kayan aiki ya kunna ta tsohuwa kuma ya adana takardun a kowane minti 10 idan ba ku aikata shi ba. Amma, idan kun yi gyare-gyaren haɓakawa a cikin saitunan Excel, ƙetare autosave, to, ba za ku iya dawo da abubuwan da aka share ba. Ya kamata ku kuma ce bayan rufe fayil ɗin, an share wannan jerin. Sabili da haka, yana da muhimmanci a lura da ɓacewar abu kuma yanke shawara game da buƙatar sake mayar da shi tun kafin ka rufe littafin.
Saboda haka, a cikin jerin samfurin da aka adana ta atomatik, muna neman samfurin da aka yi kafin kwanan nan. Danna kan wannan abu a cikin jerin da aka kayyade.
- Bayan haka, za a buɗe littafin da aka ajiye ta atomatik a cikin sabon taga. Kamar yadda kake gani, yana ƙunsar abu mai goge baya. Domin kammala dawo da fayil, danna maballin. "Gyara" a saman taga.
- Bayan wannan, akwatin kwance zai buɗe, wanda zai ba da damar maye gurbin littafin da aka ajiye na karshe da wannan littafin. Idan wannan ya dace da ku, sai ku danna maballin. "Ok".
Idan kana so ka ci gaba da iri biyu na fayil (tare da dogon dogon da kuma bayanan da aka kara wa littafin bayan an share), to, je zuwa shafin "Fayil" kuma danna abu "Ajiye Kamar yadda ...".
- Zaɓin ajiyewa zai fara. Tabbas tabbas za a sake suna littafin da aka dawo, sannan danna maballin "Ajiye".
- Bayan haka zaka sami duka nau'i na fayil ɗin.
Amma idan ka adana da rufe fayil ɗin, da kuma lokacin da ka bude shi, ka ga cewa an cire ɗaya daga cikin gajerun hanyoyi, ba za ka iya mayar da shi a cikin hanyar ba, tun lokacin da za'a rarraba jerin jumloli. Amma zaka iya ƙoƙarin dawowa ta amfani da maɓallin sarrafawa, kodayake yiwuwar nasara a cikin wannan yanayin ya fi ƙasa da tsohuwar fasali.
- Jeka shafin "Fayil" da kuma cikin sashe "Properties" danna maballin Kuskuren Kundin. Bayan wannan menu na ƙaramin ya bayyana, kunshi abu guda ɗaya - "Sauya litattafan da basu da ceto". Danna kan shi.
- Gila yana buɗewa don buɗe wani takardu a cikin shugabanci inda littattafan da basu da ceto sun kasance cikin tsarin xlsb binary. Zaɓi sunayen daya daya kuma latsa maballin "Bude" a kasan taga. Zai yiwu ɗaya daga waɗannan fayiloli zai kasance littafin da kake buƙatar ɗaukar abin da aka share.
Sai kawai bayan duk yiwuwar samun littafin da ake bukata ba shi da muhimmanci. Bugu da ƙari, ko da idan yake a cikin wannan jerin kuma yana dauke da wani abu da aka share, mai yiwuwa cewa littafinsa zai zama tsoho kuma baya ƙunsar canje-canje da yawa da aka yi a baya.
Darasi: Sake dawo da littafin Excel wanda basu da ceto
Kamar yadda ka gani, bacewar hanyoyi na gajerun hanyoyi na iya haifar da wasu dalilai, amma duk zasu iya raba kashi biyu: kungiyoyin da aka boye ko an share su. A cikin akwati na farko, zane-zane ya ci gaba da zama ɓangare na takardun, kawai samun dama garesu yana da wuya. Amma idan kuna so, kayyade hanyar da aka lalata sunayen, adreshin algorithm na ayyuka, ba zai yi wuyar mayar da nuni a cikin littafin ba. Wani abu kuma, idan an share abubuwa. A wannan yanayin, an cire su gaba ɗaya daga cikin takardun, kuma sabunta su ba koyaushe ba. Duk da haka, koda a wannan yanayin, wani lokaci yana fitowa don dawo da bayanan.
