Microsoft Kuskuren Kuskuren Microsoft "Da yawa Tsarin Kwayoyin Kwayoyin"

Ofayan matsalolin da masu amfani ke fuskanta lokacin aiki tare da tebur a Microsoft Excel shine kuskuren "Tsarin nau'ikan sel da yawa." Ya fi dacewa musamman lokacin aiki tare da tebur tare da tsawo .xls. Bari mu fahimci asalin wannan matsalar kuma mu gano ta waɗanne hanyoyi za a iya kawar da ita.

Dubi kuma: Yadda za a rage girman fayil a Excel

Bug fix

Don fahimtar yadda ake gyara kuskure, kuna buƙatar sanin asalin sa. Gaskiyar ita ce cewa fayilolin Excel tare da .xlsx fadada tallafin aiki lokaci daya tare da foda 64,000 a cikin takaddar, kuma tare da .xls tsawo - kawai 4,000. Lokacin da aka wuce waɗannan iyakokin, wannan kuskuren ya faru. Tsarin abubuwa haɗuwa ne da abubuwan tsara abubuwa daban-daban:

• Iyakokin;
• Cika;
• Harafi
• Histogram, da sauransu.

Saboda haka, a cikin sel ɗaya za'a iya samun tsari da yawa a lokaci guda. Idan takaddar ta yi amfani da tsarukan jujjuyawar, to wannan na iya haifar da kuskure kawai. Bari yanzu mu gano yadda za mu gyara wannan matsalar.

Hanyar 1: adana fayil tare da .xlsx tsawo

Kamar yadda aka ambata a sama, takardu tare da .xls mai tsawo suna tallafawa aikin na lokaci ɗaya na raka'a 4,000 kawai na sifofin. Wannan yana bayanin gaskiyar cewa galibi wannan kuskuren yakan faru ne a cikin su. Canza littafin zuwa mafi mahimmancin rubutun XLSX na zamani, wanda ke goyan bayan aiki tare da abubuwan abubuwan tsara 64,000 a lokaci guda, zai ba ku damar amfani da waɗannan abubuwan 16 sau more kafin kuskuren da ke sama.

1. Je zuwa shafin Fayiloli.



2. Na gaba, a cikin menu a tsaye hagu, danna kan abun Ajiye As.



3. Fara fayil ɗin ajiyewa yana farawa. Idan ana so, ana iya ajiye shi a wani wuri na daban, kuma ba a wurin da aka samo takaddun tushen ta hanyar zuwa wani directory na rumbun kwamfutarka ba. Hakanan a cikin filin "Sunan fayil" zaka iya canza sunanta. Amma waɗannan ba abubuwan da ake bukata bane. Za'a iya barin waɗannan saitunan azaman tsoho. Babban aikin shine a fagen Nau'in fayil canza darajar "Kundin littafi mai kyau 97-2003" a kunne Littafin aikin kwarai. Don waɗannan dalilai, danna kan wannan filin kuma zaɓi sunan da ya dace daga jerin waɗanda ke buɗe. Bayan yin aikin da aka ƙayyade, danna kan maɓallin Ajiye.

Yanzu za a adana takaddun tare da fadada XLSX, wanda zai ba da damar aiki tare da har zuwa sau 16 da yawa na tsari a lokaci guda kamar yadda yake a lokacin aiki tare da fayil tare da XLS fadada. A mafi yawan lokuta, wannan hanyar tana kawar da kuskuren da muke karantawa.

Hanyar 2: tsari mai tsabta a cikin layi mara layu

Amma har yanzu, akwai wasu lokuta lokacin da mai amfani yayi aiki tare da fadada XLSX, amma har yanzu ya sami wannan kuskuren. Wannan ya faru ne saboda gaskiyar cewa lokacin aiki tare da takaddar, mafi girman abubuwan da aka samar na 64,000 tsarin sun wuce. Bugu da ƙari, saboda wasu dalilai, yanayi yana yiwuwa yayin da kuke buƙatar adana fayil tare da haɓaka XLS maimakon XLSX, tun farkon, alal misali, na iya aiki tare da adadin manyan shirye-shirye na ɓangare na uku. A waɗannan yanayin, kuna buƙatar neman wata hanya ta fita daga wannan yanayin.

Sau da yawa, mutane da yawa masu amfani suna tsara wuri don tebur tare da gefe, saboda kada a ɓata lokaci a kan wannan hanyar idan akwai yuwuwar fadada. Amma wannan ba daidai bane. Saboda wannan, girman fayil ɗin yana ƙaruwa sosai, aiki tare da shi yana raguwa, kuma baicin, irin waɗannan ayyukan zasu iya haifar da kuskuren da muke tattauna a cikin wannan batun. Don haka, yakamata a zubar da irin wadannan abubuwan.

1. Da farko, muna buƙatar zaɓar yankin gaba ɗaya a ƙarƙashin tebur, fara daga layin farko, wanda babu bayanai. Don yin wannan, danna-hagu a kan lambar lambobi na wannan layin a cikin kwamitin daidaitawa na tsaye. An zabi layin gaba daya. Aiwatar da haɗakar maballin Ctrl + Shift + Girman Arrow. Dukkanin daftarin aiki an baiyana su a ƙasa tebur.



2. Sannan mun matsa zuwa shafin "Gida" kuma danna kan kintinkiri alamar "A share"located a cikin toshe kayan aiki "Gyara". Jerin yana buɗewa wanda muke zaɓi matsayi "A share fasali".



3. Bayan wannan matakin, za a share kewayon da aka zaɓa.

Hakanan, zaku iya tsabtace a cikin sel a hannun dama na tebur.

1. Danna sunan farko shafi wanda bai cika da bayanai ba a cikin kwamitin daidaitawa. An ba da alama ga ƙasa sosai. Sannan muna yin haɗakar maɓallan Ctrl + Shift + Arrow Dama. A wannan yanayin, an fifita duk kewayon daftarin da ke gefen dama na tebur.



2. To, kamar yadda ya gabata, danna kan gunkin "A share", kuma zaɓi zaɓi a cikin jerin zaɓi "A share fasali".



3. Bayan haka, za a yi tsabtatawa a cikin dukkanin sel zuwa dama na tebur.

Wata hanya iri ɗaya idan kuskure ta faru, wanda muke magana akai game da wannan darasi, bazai zama wuri ba koda kuwa da alama a farkon farawa cewa jigogin da ke ƙasa da hannun dama na tebur ɗin ba a tsara su bane. Gaskiyar ita ce za su iya ɗaukar nau'ikan "ɓoye". Misali, baza'a sami rubutu ko lambobi a cikin sel ba, amma an saita shi zuwa m, da dai sauransu. Saboda haka, kada ku kasance mai hankali, in akwai wani kuskure, ku aiwatar da wannan hanyar koda akan jigogin waje na waje. Hakanan, kar a manta game da yiwuwar ɓoyayyen ginshiƙai da layuka.

Hanyar 3: share tsare-tsare a cikin tebur

Idan zaɓin da ya gabata bai taimaka wajen magance matsalar ba, to ya kamata ku kula da tsara tsauraran matakan a cikin teburin da kanta. Wasu masu amfani suna yin tsari a cikin tebur ko da ba ta ɗaukar ƙarin bayani. Suna tunanin cewa sun sa teburin ya zama mafi kyau, amma a zahiri kusan sau da yawa daga waje, irin wannan ƙirar tana da daɗin ɗanɗano. Har ila yau, mafi muni, idan waɗannan abubuwan suna haifar da hana shirin ko kuma kuskuren da muka bayyana. A wannan yanayin, kawai ainihin ma'anar tsari ya kamata ya ragu a tebur.

1. A cikin waɗannan jeri waɗanda za a iya cire tsari gaba ɗaya, kuma wannan ba zai shafi abin da ke cikin teburin ba, muna aiwatar da tsari daidai da algorithm guda ɗaya da aka bayyana a cikin hanyar da ta gabata. Da farko, zaɓi kewayo a cikin teburin da za'a tsaftace. Idan teburin yana da girma sosai, to wannan hanyar za ta fi dacewa a yi ta amfani da haɗakar maballin Ctrl + Shift + Arrow Dama (zuwa hagu, sama, kasa) Idan a lokaci guda ka zaɓi sel a cikin tebur, sannan amfani da waɗannan maɓallan, zaɓin za a yi ne kawai a ciki, kuma ba ƙarshen ƙarshen takardar ba, kamar yadda yake a cikin hanyar da ta gabata.

   Danna maballin da muka riga muka sani "A share" a cikin shafin "Gida". A cikin jerin zaɓi, zaɓi zaɓi "A share fasali".



2. Yankin da aka zaɓa na teburin za'a share shi gaba daya.



3. Abinda kawai zai buƙatar aikatawa daga baya shine saita iyakoki a cikin ɓataccen yanki, idan suna cikin sauran tebur ɗin tsarawa.

Amma ga wasu yankuna na teburin, wannan zaɓin ba zai yi aiki ba. Misali, a cikin wani takamaiman kewayo, zaku iya cire cike, amma ya kamata ku bar tsarin kwanan wata, in ba haka ba za'a nuna bayanan daidai, iyakoki da wasu abubuwan. Irin wannan aikin da muka ambata a sama gaba ɗaya yana cire tsarin tsari.

Amma akwai wata hanyar fita kuma a wannan yanayin, duk da haka, yana da mafi yawan lokaci. A irin wannan yanayi, mai amfani zai zabi kowane ginin sel mai tsari kuma ya cire tsarin da za'a iya musayar shi da hannu.

Tabbas, wannan babban aiki ne mai ɗaukar hoto idan tebur ya yi yawa. Sabili da haka, ya fi kyau kada a zagi "ƙimar" da sauri yayin shirya takaddar, don haka daga baya ba za a sami matsala ba, mafita wanda zai dauki lokaci mai yawa.

Hanyar 4: cire Tsarin yanayi

Tsarin yanayi shine ingantacciyar kayan aiki don hango bayanai, amma amfani dashi fiye da kima na iya haifar da kuskuren da muke binciken. Sabili da haka, kuna buƙatar duba jerin ka'idojin tsara yanayin da ake amfani dasu akan wannan takarda kuma cire matsayin da zaku iya yi ba tare da su ba.

1. Ana zaune a cikin shafin "Gida"danna maballin Tsarin Yanayiwanda yake a cikin toshe Salo. A cikin menu wanda yake buɗe bayan wannan matakin, zaɓi Gudanar da Dokoki.



2. Bayan wannan, an ƙaddamar da taga gudanar da mulkin, wanda ya ƙunshi jerin abubuwan kirkirar abubuwa.



3. Ta hanyar tsohuwa, jeri ya ƙunshi abubuwa kawai na zaɓaɓɓun gutsuren. Domin nuna duk ka'idodi akan takarda, muna shirya sauyawa a fagen "Nuna ka'idodin tsara bayanai don" a matsayi "Wannan takarda". Bayan haka, duk dokokin ka'idojin na yanzu za a nuna su.



4. Sannan zaɓi mulkin da zaku iya yi ba tare da, ba danna maballin Share doka.



5. Ta wannan hanyar, muna share waɗancan ƙa'idodin waɗanda ba su taka muhimmiyar rawa ba a hangen nesa na bayanai. Bayan an gama bin hanyar, danna maballin "Ok" kasan taga Manajan mulki.

Idan kana buƙatar cire tsarin tsari koyaushe daga takamaiman kewayon, saiya sauƙaƙa shi.

1. Zaɓi kewayon sel waɗanda muke shirin cirewa.



2. Latsa maballin Tsarin Yanayi a toshe Salo a cikin shafin "Gida". A jeri wanda ya bayyana, zaɓi zaɓi Share dokoki. Na gaba, wani jerin suna buɗe. A ciki, zaɓi abu "Share dokoki daga cikin sel da aka zaba".



3. Bayan haka, za a share duk ƙa'idoji a cikin zaɓaɓɓen da aka zaɓa.

Idan kana son cire Tsarin yanayi, gaba ɗaya a jerin menu na ƙarshe da kake buƙatar zaɓar zaɓi "Cire ka'idoji daga dukkan takardar".

Hanyar 5: share salon al'ada

Bugu da kari, wannan matsalar na iya faruwa saboda amfani da adadi da yawa na al'ada. Haka kuma, suna iya bayyana sakamakon shigo da kofe daga wasu littattafai.

1. An warware wannan batun kamar haka. Je zuwa shafin "Gida". A kan kintinkiri a cikin akwatin kayan aiki Salo danna rukuni Siffofin Kwayar halitta.



2. Tsarin menu na buɗe yana buɗewa. An gabatar da nau'ikan zane iri daban-daban anan, wannan shine, a zahiri, tsayayyen haɗuwa da tsari mai yawa. A saman jerin abubuwan toshewa ne Kasuwanci. Kawai waɗannan salon ba'a fara asalin su zuwa Excel ba, amma samfuran ayyukan masu amfani ne. Idan wani kuskure ya faru cewa muna bincika, ana ba da shawarar ku share su.



3. Matsalar ita ce babu wani kayan aiki da aka gina don yawan cire salon, saboda haka dole ne ka share kowannensu daban. Tsaya kan takamaiman salon daga rukunin rukuni Kasuwanci. Mun danna shi tare da maɓallin linzamin kwamfuta na dama kuma zaɓi zaɓi a cikin menu na mahallin "Share ...".



4. Muna cire kowane salon daga toshe ta wannan hanyar. Kasuwancihar sai kawai jigogi masu kyau iri na Excel kasance.

Hanyar 6: share tsarin al'ada

Wata hanya mai kama ɗaya don share salon ita ce share tsarin al'ada. Wato, za mu goge waɗancan abubuwan da ba ginannu ba da ƙarko a cikin Excel, amma mai amfani ne ya shigar da shi, ko kuma an saka shi cikin takaddar ta wata hanyar.

1. Da farko, muna buƙatar buɗe taga hanyar tsara. Hanya mafi gama gari don yin wannan ita ce ta danna dama-dama ko ina cikin takaddar kuma zaɓi zaɓi daga menu na mahallin "Tsarin kwayar halitta ...".

   

   Hakanan zaka iya, kasancewa cikin shafin "Gida"danna maballin "Tsarin" a toshe "Kwayoyin" a kan tef. A menu na buɗe, zaɓi "Tsarin kwayar halitta ...".

   

   Wani zaɓi don kiran taga da muke buƙata shine saita gajerun hanyoyin keyboard Ctrl + 1 a kan keyboard.

2. Bayan aiwatar da kowane ɗayan ayyukan da aka bayyana a sama, taga tsara zai fara. Je zuwa shafin "Lambar". A cikin toshe na sigogi "Lambobin adadi" saita canzawa zuwa matsayi "(Dukkan tsare-tsare)". A ɓangaren dama na wannan taga akwai filin da ya ƙunshi jerin nau'ikan abubuwan da ake amfani da su a cikin wannan takaddar.

   Zaɓi kowannensu tare da siginan kwamfuta. Je zuwa abu na gaba ya fi dacewa da maɓallin "Na sauka" akan maballin cikin maballin kewayawa. Idan abu ya shiga cikin layi, to maballin Share a ƙarƙashin jerin za su kasance marasa aiki.



3. Da zarar an fifita abu na al'ada da aka ƙara, maɓallin Share zai zama mai aiki. Danna shi. Haka kuma, muna share duk tsare-tsaren tsare tsaren mai amfani a cikin jerin.



4. Bayan kammala aikin, tabbatar an danna maballin "Ok" a kasan taga.

Hanyar 7: share zanen gado mara amfani

Mun bayyana ayyuka don magance matsalar kawai a cikin takardar guda ɗaya. Amma kar a manta cewa daidai wannan takunkumin dole ne a yi tare da sauran sauran zanen gado na littafin cike da waɗannan bayanan.

Bugu da kari, zanen gado ko zanen gado inda ba kwafin bayani, zai fi kyau a goge. Wannan ana yin shi kawai.

1. Mun danna-dama akan alamar takardar da yakamata a cire, wanda yake saman sandar matsayin. Na gaba, a menu wanda ya bayyana, zaɓi "Share ...".



2. Wannan yana buɗe akwatin maganganu wanda ke buƙatar tabbatarwa don share gajerar hanya. Danna maballin a ciki. Share.



3. Bayan wannan, za a share alamar da aka zaɓa daga takaddar, kuma, sabili da haka, duk abubuwan kirkirar abubuwa a kai.

Idan kana bukatar share gajerun hanyoyin gajerun hanyoyin, to danna kan farkon su tare da maɓallin linzamin kwamfuta na hagu, sannan danna kan na ƙarshe, amma ka riƙe maɓallin kawai. Canji. Dukkanin gajerun hanyoyi tsakanin wadannan abubuwan za'a fadada su. Na gaba, ana cire hanyar cirewa daidai da wannan algorithm iri ɗaya kamar yadda aka bayyana a sama.

Amma akwai wasu zanen gado na ɓoye, kuma akan su za'a iya samun adadin adadi mai kyau na abubuwa daban da aka tsara. Don cire Tsarin da aka wuce kima akan waɗannan zanen gado ko ma cire su gaba ɗaya, kuna buƙatar nuna gajerun hanyoyin nan da nan.

1. Mun danna kowane gajerar hanya kuma zaɓi abu a cikin mahallin mahallin Nuna.



2. Lissafin ɓoyayyen zanen ya buɗe. Zaɓi sunan ɓoyayyen takardar kuma danna maɓallin "Ok". Bayan haka, za a nuna shi a kan kwamiti.

Muna yin irin wannan aiki tare da duk zanen ɓoye. Sannan mun ga abin da za mu yi da su: cire gaba ɗaya ko tsaftace su daga tsarukan da aka wuce kima, idan bayanan da ke kansu na da mahimmanci.

Amma ban da wannan, akwai kuma wasu magunan da ake kira super-ɓoyayyun zanen gado, wanda ba za ku samu cikin jerin ɓoyayyen zanen gado na yau da kullun ba. Ana iya ganin su kuma a nuna su a cikin kwamitin kawai ta hanyar editan VBA.

1. Don fara edita na VBA (editan macro), latsa haɗin hotkey Alt + F11. A toshe "Aikin" zaɓi sunan takardar. Yana nunawa kamar zanen gado na yau da kullun, don haka ɓoye da ɓoyayyen. A cikin ƙananan yanki "Bayanai" kalli darajar siga "Bayyane". Idan an saita shi "2-xlSheetVeryHidden", to, wannan takarda ne mai ɓoye-ɓoye.



2. Mun danna wannan sigogi kuma a cikin jerin da ke buɗe, zaɓi sunan "-1-xlSannanVa". Sannan danna maballin madaidaiciya don rufe taga.

Bayan wannan matakin, takaddar da aka zaɓa ba za ta ƙara zama ɓoye ba kuma za a nuna alamar ta a allon. Bugu da ari, zai yuwu a aiwatar da tsarin tsabtatawa ko cirewa.

Darasi: Abinda yakamata ayi idan an rasa zanen gado a cikin Excel

Kamar yadda kake gani, hanya mafi sauri kuma mafi inganci don kawar da kuskuren bincike da aka bincika a cikin wannan darasi shine don adana fayil ɗin tare da tsawo .xlsx. Amma idan wannan zaɓin bai yi aiki ba ko kuma saboda wasu dalilai ba sa aiki, to sauran hanyoyin magance matsalar za su buƙaci lokaci da ƙoƙari sosai daga mai amfani. Bugu da kari, dukansu dole ne a yi amfani dasu a hade. Sabili da haka, zai fi kyau kada ku zagi ƙarancin tsari a cikin ƙirƙirar takaddar, don haka daga baya ba lallai ne ku kashe kuzari don gyara kuskuren ba.