I-Excel: Impazamo xa uthumela isicelo somyalelo

Anonim

Impazamo yeMicrosoft Excel

Ngaphandle kwento yokuba, ngokubanzi, inkqubo yeMicrosoft Excel ibonakaliswa linqanaba eliphezulu lokuqina, kunye nesi sicelo, ngamanye amaxesha senzeka. Enye ingxaki enjalo yinkangeleko yomyalezo "Impazamo xa uthumela isicelo somyalelo". Ivela xa uzama ukugcina okanye ukuvula ifayile, kunye nokuchitha ezinye iintshukumo ngayo. Masihlangabene nezinto ezibangele le ngxaki, kwaye inokuthi ipheliswe njani.

Unobangela wempazamo

Zeziphi izizathu eziphambili ezibangela le mpazamo? Unokukhetha oku kulandelayo:
  • Ukonakaliswa kwenkolelo;
  • Ukuzama ukufikelela kwidatha yesicelo esebenzayo;
  • Iimpazamo kwirejista yenkqubo;
  • Umonakalo kwinkqubo ye-Excel.

Isisombululo

Iindlela zokuphelisa le mpazamo ixhomekeke kwisizathu sayo. Kodwa, kwiimeko ezininzi, kunzima ngakumbi ukumisela isizathu sokuphelisa, isisombululo sengqondo ngakumbi yindlela yesampulu yokuzama ukufumana indlela eyinyani yezenzo eziboniswe ngezantsi.

Indlela yoku-1: Khubaza i-DDE Ihoshe

Uninzi lwazo, ukuphelisa impazamo xa isikhokelo somyalelo sinokususwa ngokukhubaza i-Dde.

  1. Yiya kwi "Ifayile" yethebhu.
  2. Yiya kwi-theb yefayile kwi-Microsoft Excel

  3. Cofa kwi "Parameter".
  4. Tshintshela kwiiparamitha kwiMicrosoft Excel

  5. Kwifestile yeparamitha evula, yiya kwicandelwana "ehambisileyo".
  6. Yiya kwicandelo eliphezulu kwiMicrosoft Excel

  7. Sikhangela ibhloko "ngokubanzi". Susa uphawu malunga "nokugcina izicelo zeDDE kwezinye iinkqubo" zeparamitha ". Cofa kwiqhosha "Kulungile".

Khubaza i-DDE Ihoshe kwiMicrosoft Excel

Emva koko, kwinani elikhulu lamatyala, ingxaki iyashenxiswa.

Indlela 2: Khubaza indlela yokuhambelana

Elinye isizathu esinokwenzeka esichazwe ngaphezulu kwengxaki inokubandakanywa kwimodi yokuhambelana. Ukuze uyikhubazeke, kufuneka uzisebenzise ngoku ngokuthe ngqo.

  1. Yiya kwi-Windows Explorer, okanye nayiphi na imiphathi yefayile, kwi-Microsoft ye-Microsoftindows ye-Microsoftindows yeSoftware kwikhompyuter yakho. Indlela eya kuyo yile ilandelayo: c: \ iifayile zenkqubo ye-Microsoft \ office ~ Hayi. Inombolo yephakheji yeofisi. Umzekelo, ifolda apho iofisi ye-2007 igcinwe, iya kubizwa ngokuba iOfisi12, yeMicrosoft 2014, iOfisi yeOfisi yeMicrosoft, iOfisi yeMicrosoft 2013 - eOfisi15, njl.
  2. Indlela ye-Excel

  3. Kwincwadi yeOfisi sikhangela ifayile ye-Excel.exe. Ndicofa kuyo ngeqhosha le mouse lasekunene, kwaye kwimenyu yomxholo, khetha eyona nto "impahla".
  4. Inguqu kwipropathi kwiMicrosoft Excel

  5. Kwifestile ye-Excel Properties Window evula, yiya kwithebhu efanelekileyo.
  6. Inguqu kwithebhu yokuhambelana kwiMicrosoft Excel

  7. Ukuba ujonga iibhokisi phambi kwenkqubo "yokuqalisa kwimodi yokuhambelana", okanye "phumezile le nkqubo egameni lomlawuli", ke ubasuse. Cofa kwiqhosha "Kulungile".

Khubaza inkqubo yokuqalisa kweNdawo yeMicrosoft Excel

Ukuba iibhokisi zokutshekisha azifakwanga kwizinto ezifanelekileyo, emva koko qhubeka ujonge umthombo wengxaki kwenye indawo.

Indlela 3: Ukucoca irejista

Esona sizathu sokubangela impazamo xa sithumela umyalelo kwisicelo se-Excel, ziingxaki kwiRegistry. Ke ngoko, kuya kufuneka sicocwe. Ngaphambi kokuba uqhubeke kwezinye inyathelo, ukuze iqhubele phambili kwiziphumo ezinokubakho ezingathandekiyo zale nkqubo, sicebisa ngamandla ukudala indawo yokubuyisela inkqubo.

  1. Ukwenzela ukubongoza "Run" iwindows, sifaka i-win + r indibaniselwano yesitshixo kwikhibhodi. Kwifestile evulekileyo, faka umyalelo "wokurenta" ngaphandle kweekowuti. Cofa kwiqhosha "Kulungile".
  2. Tshintshela kumhleli weRegistry ngokusebenzisa iwindow esenziweyo

  3. Umhleli weRegistry uyavula. Kwicala lasekhohlo lomhleli kukho umthi wezalathiso. Sisiya ku lawulo CurrentVersion ngendlela elandelayo: HKEY_CURRENT_USER \ SOFTWARE \ Microsoft \ Windows \ CurrentVersion.
  4. Umhleli weRegistry Registry

  5. Sicima zonke iifolda ezikwi "Vareevisions". Ukwenza oku, cofa kwifolda nganye ngeqhosha lasekunene lemouse, kwaye ukhethe "Cima" kwimenyu yemeko.
  6. I-Revistry Recistry Cocaner

  7. Emva kokucima, qalisa kwakhona ikhompyuter kwaye ujonge ukusebenza kwenkqubo ye-Excel.

Indlela yesi-4: Ukucima isantya seHardware

Isisombululo sexeshana kwingxaki sinokukhubaza isantya se-hardware kwi-Excel.

  1. Yiya esele sisazi ukuba yindlela yokuqala yokusombulula icandelo lengxaki "kwiparamitha" kwi "Ifayile" yethebhu. Kwakhona, cofa kwinto ethi "Advanced".
  2. Kwi-Express ye-Explor Parameter Window evula, sikhangela ibhloko "yescreen". Faka i-tick malunga ne "khubaza ukukhawulezisa ukukhawulezisa ukwenziwa komfanekiso". Cofa kwiqhosha "Kulungile".

Khubaza i-Hardware Acpheleremere kwiMicrosoft Excel

Indlela ye-5: Ukucima i-onns

Njengoko kuchaziwe apha ngasentla, esinye sezizathu zele ngxaki sinokungasebenzi kakuhle kwabanye abantshutshiso. Ke ngoko, njengemilinganiselo yethutyana, ungasebenzisa i-Excel eyongezelelweyo.

  1. Kwakhona, yiya kwi "Ifayile" yethebhu, kwicandelo "leparamitha", kodwa ngeli xesha ndicofa kwi "Yongeza".
  2. Inguqu ukongeza kwiMicrosoft Excel

  3. Kwinxalenye engezantsi yefestile, kuluhlu "lolawulo", khetha into "yentsomi". Cofa kwi "Pay Potter".
  4. Inguqu ukugqibezela ukugqibelela kwi-Microsoft Excel

  5. Susa imikhawuli kuzo zonke ii-on ezidwelisiweyo ezidwelisiweyo. Cofa kwiqhosha "Kulungile".
  6. Ikhampasi yongezwa kwiMicrosoft Excel

  7. Ukuba emva koko, ingxaki inyamalala, emva koko sibuyela kwifestile yendlela enzima. Faka i-tick, kwaye cinezela iqhosha u "Kulungile". Sijonga ukuba ingxaki ayibuyanga. Ukuba yonke into ilungelelene, emva koko uye kwi-Supersts elandelayo, njl. Lo mbandela apho impazamo ibuyise khona, cima, kwaye ungasaguquki. Bonke abanye abantu benzonzobila banokubandakanywa.

Yenza ukongeza kwiMicrosoft Excel

Ukuba, emva kokucima zonke ii-on-on, ingxaki isekhona, oko kuthetha ukuba inkolelo inokuvulwa, kwaye impazamo kufuneka ipheliswe ngenye indlela.

Indlela yesi-6: Setha imephu yefayile

Ukusombulula ingxaki, ungazama kwakhona ukuseta kwakhona ifayile.

  1. Ngeqhosha "Qala", yiya kwiphaneli yokulawula.
  2. Tshintshela kwiphaneli yolawulo

  3. Kwiphaneli yokulawula, khetha icandelo "lenkqubo".
  4. Tshintshela kwicandelo lenkqubo kwiphaneli yokulawula

  5. Kwifestile evula, yiya kwicandelwana elizenzekelayo.
  6. Tshintshela kwicandelo lenkqubo engagqibekanga kwiphaneli yokulawula

  7. Kwinkqubo ye-windows engagqibekanga yenkqubo, khetha "Iintlobo zefayile zemephu kunye neeprothokholi zeenkqubo ezithile".
  8. Tshintshela kwicandelo lemephu yemephu yemephu kwiphaneli yokulawula

  9. Kuluhlu lweefayile, khetha ulwandiso lwe-XLLX. Cofa kwi "Inkqubo yoTshintsho".
  10. Utshintsho lokutshintsha kwenkqubo

  11. Kuluhlu lweenkqubo ezicetyiswayo ezivula, khetha iMicrosoft Excel. Senza iqhosha "Kulungile".
  12. Ukukhetha inkqubo

  13. Kwiinkqubo ze-Excel azikho kuluhlu lweenkqubo ezicetyiswayo, cofa kwi "Ushwankathelo ..." iqhosha. Yiya kwindlela esithetha ngayo, exoxa ngayo indlela yokusombulula ingxaki yokukhupha, kwaye ukhethe ifayile ye-Excel.exe.
  14. Utshintsho kwiNkqubo yokukhangela inkqubo

  15. Izenzo ezifanayo zenziwa kwaye zandise i-XLS.

Indlela yesi-7: Khuphela uHlaziyo lweWindows kunye nokubuyisela kwakhona kwakhona i-Ofisi ye-Ofisi ye-Microsoft ye-Microsoft

Hayi ubuncinci kwimpazamo yale mpazamo e-Excel inokuba kukunqongophala kohlaziyo lweWindows olubalulekileyo. Kuya kufuneka ujonge ukuba ngaba zonke uhlaziyo zikhutshelwa ngaphandle, kwaye ukuba kukho imfuneko, Khuphela ilahlekile.

  1. Vula ipaneli yolawulo kwakhona. Yiya kwicandelo "lenkqubo kunye nezokhuseleko".
  2. Tshintshela kwinkqubo kunye nephaneli yolawulo lokhuseleko

  3. Cofa kwi-Windows Hlaziya igatya.
  4. Tshintshela kwiZiko loHlaziyo lweWindows

  5. Ukuba iwindow evula, kukho umyalezo malunga nokufumaneka kohlaziyo, cofa kwiqhosha "Faka uhlaziyo".
  6. Tshintshela ekufakweni kohlaziyo lweWindows

  7. Silinde de kufike uhlaziyo, kwaye qalisa kwakhona ikhompyuter.

Ukuba akukho zithuba zidwelisiweyo zincedise ukusombulula ingxaki, ke inokuba sengqiqweni ukucinga ngokubuyisela kwakhona i-Ofisi yeSoftwe ye-Microsoft, kwaye malunga nokufaka inkqubo yokusebenza yeWindows ngokupheleleyo.

Njengoko ubona, uninzi lweendlela ezininzi ezinokubakho zokuphelisa impazamo xa uthumela umthetho kwi-Excel. Kodwa, njengommiselo, kwimeko nganye kukho isisombululo esinye kuphela. Ke ngoko, ukuze siyiphelise le ngxaki, kuya kufuneka basebenzise iindlela ezahlukeneyo zokusombulula impazamo, kude kufike ukhetho oluchanekileyo.

Funda ngokugqithisileyo