Kutsegula chikalata cha Microsoft Excel m'mawindo osiyanasiyana

Pogwira ntchito mu Microsoft Excel, zingakhale zofunikira kuti mutsegule zolemba zingapo kapena fayilo yomweyo m'mawindo angapo. M'mitundu yakale komanso m'mitundu kuyambira Excel 2013, izi sizovuta. Ingotsegulirani mafayilo mwanjira yoyenera, ndipo iliyonse mwa iyo idzayamba pawindo latsopano. Koma mumitundu 2007 - 2010, chikalata chatsopano chimatsegulidwa mwachidule pawindo la kholo. Njirayi imapulumutsa zida zamakompyuta, koma nthawi yomweyo zimayambitsa zovuta zingapo. Mwachitsanzo, ngati wogwiritsa ntchito akufuna kufananizira zolemba ziwiri poika mawindo pazenera pambali pake, ndiye kuti ndi zoikika zokhazokha izi sizigwira ntchito. Ganizirani momwe izi zingachitikire m'njira zonse zomwe zikupezeka.

Kutsegula mawindo angapo

Ngati muli kale ndi chikalata chotsegulidwa mu Excel 2007-2010, koma ngati mukuyesera kuyendetsa fayilo ina, idzatsegulidwa pawindo lomwelo la kholo, ndikungoyambitsa zomwe zalembedwa ndikulemba ndi zomwe zatsopano. Nthawi zonse pamakhala mwayi wosinthira fayilo yoyamba. Kuti muchite izi, ikani cholozera pazithunzi cha Excel mu bar. Mawindo ang'onoang'ono amawonekera kuwunikira mafayilo onse omwe akuyendetsa. Mutha kupita ku chikalata china pakadina pawindo loterolo. Koma uku kungosintha, osati kutsegulira kwathunthu kwa mawindo angapo, chifukwa nthawi yomweyo wosuta sangathe kuwawonetsa motere.

Koma pali maukadaulo angapo omwe mungawonetse zikalata zingapo ku Excel 2007 - 2010 pazenera nthawi yomweyo.

Njira imodzi yachangu yothanirana ndi vuto lotsegula windows angapo ku Excel kamodzi ndikukhazikitsa MicrosoftEasyFix50801.msi patch. Koma mwatsoka, Microsoft yasiya kuthandizira mayankho onse a Easy Fix, kuphatikiza malonda omwe atchulidwa pamwambapa. Chifukwa chake, simungathe kutsitsa patsamba lawebusayiti tsopano. Ngati mungafune, mutha kutsitsa ndikukhazikitsa chigamba kuchokera pazinthu zina za pa intaneti pachiwopsezo chanu, koma kumbukirani kuti ndi izi mutha kuyika pangozi dongosolo lanu.

Njira 1: ntchito

Njira imodzi yosavuta yotsegulira windows yambiri ndikuchita izi pogwiritsa ntchito menyu wazizindikiro pa Taskbar.

1. Chikalata chimodzi cha Excel chitakhazikitsidwa kale, timasuntha pazithunzi za pulogalamu zomwe zili pa Taskbar. Timadulira pomwepo ndi batani la mbewa. Zosintha zamakambirano zayambitsidwa. Mmenemo, sankhani, kutengera mtundu wa pulogalamuyo, chinthucho "Microsoft Excel 2007" kapena "Microsoft Excel 2010".

   M'malo mwake, mutha kudina chizindikiro cha Excel pazogwira ntchito ndi batani lakumanzere pomwe mukugwira batani Shift. Njira ina ndikungoyenda pamwamba pa chithunzi, ndikudina gudumu la mbewa. Muzochitika zonse, zotsatira zake zikhala zofanana, koma simufunikira kuyambitsa mitu yankhaniyo.

2. Pepala lopanda kanthu lotseguka limatseguka pazenera lina. Kuti mutsegule chikalata china, pitani tabu Fayilo zenera latsopano ndikudina pa chinthucho "Tsegulani".



3. Pazenera lomwe limatsegulira, tsegulani fayilo, pitani ku chikwatu chomwe chikupezeka, sankhani ndikudina batani "Tsegulani".

Pambuyo pake mutha kugwira ntchito ndi zikalata m'mawindo awiri nthawi imodzi. Momwemonso, ngati kuli koyenera, mutha kuthamangitsa chiwerengero chokulirapo.

Njira 2: Wongoletsani Zenera

Njira yachiwiri imaphatikizapo zochita kudzera pazenera Thamanga.

1. Kulemba njira yaying'ono Kupambana + r.
2. Zenera limayatsidwa Thamanga. Timayimira lamulo m'munda wake "pambana".

Pambuyo pake, idzatsegulidwa zenera latsopano, ndipo kuti titsegule fayilo yomwe tikufunamo, timachita zomwezo monga momwe tidachita kale.

Njira 3: Yambitsani Menyu

Njira yotsatirayi ndi yoyenera kwa ogwiritsa ntchito Windows 7 kapena mitundu yoyambirira yamakina oyendetsera.

1. Dinani batani Yambani Windows OS Pitani ku chinthucho "Mapulogalamu onse".
2. Pamndandanda wamapulogalamu omwe amatsegula, pitani ku chikwatu "Microsoft Office". Kenako, dinani kumanzere njira yachidule "Microsoft Excel".

Pambuyo pa izi, zenera la pulogalamu yatsopano iyamba, pomwe fayilo imatha kutsegulidwa mwanjira yokhazikika.

Njira 4: Njira Yochepetsera

Kuyambitsa Excel pawindo latsopano, dinani kawiri pa njira yachidule pa desktop. Ngati sichoncho, pankhaniyi njira yochepetsetsa iyenera kupangidwa.

1. Tsegulani Windows Explorer ndipo ngati mwayika Excel 2010, ndiye pitani ku adilesi:

   C: Files Fayilo Microsoft Office Office14

   Ngati Excel 2007 yakhazikitsidwa, ndiye kuti pomwepo adilesiyo ikhale motere:

   C: Files Fayilo Microsoft Office Office12



2. Kamodzi pazosindikiza za pulogalamuyi, timapeza fayilo yotchedwa "EXCEL.EXE". Ngati mulibe chiwonetsero chowonjezera chomwe chikuthandizira mu opareting'i sisitimu, chidzangotchedwa CHITSANZO. Timadulira izi ndi batani loyenera la mbewa. Pazosankha zomwe zakhazikitsidwa, sankhani Pangani Chidule.



3. Bokosi la zokambirana limawoneka lomwe likuti simungapangitse njira yachidule mufodayi, koma mutha kuyika pa desktop yanu. Gwirizanani podina batani Inde.

Tsopano zitheka kukhazikitsa windows yatsopano pogwiritsa ntchito njira yachidule pa desktop.

Njira 5: kutsegula kudzera pa menyu

Njira zonse zomwe zidafotokozedwa pamwambapa zimayamba kuyambitsa zenera latsopano la Excel, ndipo pokhapokha kudzera pa tabo Fayilo kutsegula chikalata chatsopano, chomwe ndi njira yovuta. Koma pali mwayi wothandiza kwambiri kutsegulidwa kwa zikalata pogwiritsa ntchito menyu yankhaniyo.

1. Timapanga tatifupi ya Excel pa desktop malinga ndi algorithm yomwe tafotokozazi.
2. Timadulira njira yachidule ndi batani la mbewa yoyenera. Pazosankha, siyani kusankha pazomwe zili Copy kapena Dulani kutengera kuti wogwiritsa ntchito akufuna njira yocheperako kuti apitirize kuyikidwa pa desktop kapena ayi.



3. Kenako, tsegulani Explorer, kenako nkusinthira ku adilesi iyi:

   C: Ogwiritsa Username AppData Oyendayenda Microsoft Windows SendTo

   M'malo mopindulitsa "Zogwiritsa ntchito" sinthani dzina la akaunti yanu ya Windows, ndiye kuti, chikwatu cha ogwiritsa ntchito.

   Vutoli limapezekanso chifukwa chakuti mwanjira iyi chikwatu chikusungidwa. Chifukwa chake, muyenera kuthandizira chiwonetsero chobisika.



4. Mu foda yotsegulidwa, dinani malo aliwonse opanda kanthu ndi batani la mbewa yoyenera. Pazosankha zomwe zimayambira, siyani kusankha pazomwe zili Ikani. Zitangochitika izi, njira yochezera idzawonjezedwa ku directory iyi.



5. Kenako tsegulani chikwatu chomwe fayilo yomwe ikuyendetsedwera ili. Timadulira pomwepo ndi batani la mbewa. Pazosankha, werengani zinthuzo "Tumizani" ndi Excel.

Chikalatachi chimayamba pawindo latsopano.

Mukamaliza kuchita opareshoni ndikuwonjezera njira yachidule mufoda "Sendto", Tidakhala ndi mwayi wotsegulira mafayilo onse a Excel pawindo latsopano kudzera pazosankha zofanizira.

Njira 6: kaundula amasinthira

Koma mutha kupanga kutsegula mafayilo a Excel m'mawindo angapo ngakhale kosavuta. Pambuyo pa njirayi, yomwe idzafotokozeredwe pansipa, zolemba zonse zomwe zatsegulidwa mwanjira zonse, ndiko kuti, ndikudina kawiri, zidzayambitsidwa chimodzimodzi. Zowona, njirayi imaphatikizira kuwongolera kaundula. Izi zikutanthauza kuti muyenera kudzidalira musanayambe, chifukwa chilichonse cholakwika chitha kuvulaza dongosolo lonse. Kuti muthane ndi vuto lanu pamavuto, konzani dongosolo musanayambe manambala.

1. Kukhazikitsa zenera Thamangakanikizani kuphatikiza kiyi Kupambana + r. M'munda womwe umatsegulira, ikani lamulo "RegEdit.exe" ndipo dinani batani "Zabwino".



2. Mkonzi wa Registry ukuyamba. Tipita ku adilesi iyi:

   HKEY_CLASSES_ROOT Excel.Sheet.8 shell Open command

   Gawo lamanja la zenera, dinani pamalowo "Zosintha".



3. Windo loti lisinthidwe limatsegulidwa. Pamzere "Mtengo" kusintha "/ dde" pa "/ e"% 1 "". Mzere wina wonse watsala monga uli. Dinani batani "Zabwino".



4. Pokhala m'gawo lomweli, dinani kumanja pazinthu zina "kulamula". Pazosankha zomwe zatsegulidwa, pitani Tchulani. Timasinthiratu chinthuchi.
5. Dinani kumanja pa dzina la "ddeexec" gawo. Pazosankha zofanizira, sankhani Tchulani komanso kusankhanso chinthucho mosaganizira.

   Chifukwa chake, tidapangitsa kuti tithe kutsegula mafayilo mwanjira yatsopano ndi kuwonjezera ma xls mwanjira yofananira.

6. Kuti mugwire ntchito iyi pamafayilo omwe ali ndi chiwonetsero cha xlsx, mu Registry Editor, pitani:

   HKEY_CLASSES_ROOT Excel.Sheet.12 chipolopolo Open command

   Timachitanso chimodzimodzi ndi zinthu zomwe zimayenderana ndi nthambi iyi. Ndiye kuti, timasintha magawo a chinthucho "Zosintha"tumitsanso chinthucho "kulamula" ndi nthambi "ddeexec".

Mukamaliza njirayi, mafayilo amtundu wa xlsx adzatsegulanso pawindo latsopano.

Njira 7: Njira zosankha

Kutsegula mafayilo angapo m'mawindo atsopano amathanso kukonzedwa kudzera mu zosankha za Excel.

1. Ndili pa tabu Fayilo dinani pachinthucho "Zosankha".



2. Izi zikuyamba zenera. Pitani ku gawo "Zotsogola". Mu gawo loyenera la zenera tikuyang'ana gulu la zida "General". Chongani bokosi pafupi ndi chinthucho "Pewani zopempha za DDE kuchokera ku mapulogalamu ena". Dinani batani "Zabwino".

Pambuyo pake, mafayilo atsopano omwe atsegulidwa adzatsegulidwa m'mawindo osiyana. Nthawi yomweyo, musanamalize ntchito ku Excel, ndikofunikira kuti simumayimitsa zinthuzo "Pewani zopempha za DDE kuchokera ku mapulogalamu ena", popeza kumbali ina, nthawi ina mukadzayamba pulogalamu, mutha kukumana ndi mavuto kutsegula mafayilo.

Chifukwa chake, motere, njira iyi ndiyosavuta poyerekeza ndi yapita.

Njira 8: tsegulani fayilo imodzi kangapo

Monga mukudziwa, nthawi zambiri Excel sakulolani kuti mutsegule fayilo yomweyo m'mawindo awiri. Komabe, izi zitha kuchitika.

1. Yendetsani fayilo. Pitani ku tabu "Onani". Mu bokosi la zida "Window" pa tepi dinani batani "Windo latsopano".



2. Pambuyo pa izi, fayilo iyi idzatsegulanso nthawi ina. Mu Excel 2013 ndi 2016, iyamba nthawi yomweyo pawindo latsopano. Kuti chikalatacho chitsegule fayilo yosiyana mu 2007 ndi 2010, osati pamawebusayiti atsopano, muyenera kugwiritsa ntchito kaundula, zomwe takambirana pamwambapa.

Monga mukuwonera, ngakhale osasankhidwa mu Excel 2007 ndi 2010, mukayamba mafayilo angapo adzatseguka pazenera lomwelo, pali njira zambiri zowayambira m'mawindo osiyanasiyana. Wogwiritsa ntchito amatha kusankha njira yosavuta yomwe ikukwaniritsa zosowa zake.