Ungayivula kanjani i-Excel entsha efasiteleni elihlukile

Kwake kwadingeka ukuthi ulinde imizuzu embalwa ukuze incwadi yakho yokusebenzela ye-Excel isebenze ngokukhulu, ubuyekeze Umbuzo Wamandla, noma ubale kabusha amafomula asindayo? Yebo, ungakwazi ukugcwalisa ukuphumula ngenkomishi yetiye nekhofi ngezizathu ezingokomthetho ngokuphelele, kodwa mhlawumbe ubunomunye umcabango: kungani ungavuli enye incwadi yokusebenzela ye-Excel eduze futhi usebenze nayo okwamanje?

Kodwa akulula kangako.

Uma uvula amafayela amaningi e-Excel ngendlela evamile (chofoza kabili ku-Explorer noma nge- Ifayela – Vula ku-Excel), zivula ngokuzenzakalelayo esimeni esifanayo se-Microsoft Excel. Ngakho-ke, uma usebenzisa ukubala kabusha noma i-macro kwelinye lalawa mafayela, uhlelo lonke luzoba matasa futhi zonke izincwadi ezivuliwe zizoba yiqhwa, ngoba zinenqubo evamile yesistimu ye-Excel.

Le nkinga ixazululwa kalula - udinga ukuqala i-Excel ngenqubo entsha ehlukile. Izozimele kweyokuqala futhi izokuvumela ukuthi usebenze kwamanye amafayela ngokuthula kuyilapho isibonelo sangaphambilini se-Excel senza umsebenzi osindayo ngokuhambisana. Kunezindlela ezimbalwa zokwenza lokhu, ezinye zazo ezingase zisebenze noma zingasebenzi kuye ngenguqulo yakho ye-Excel kanye nezibuyekezo ozifakile. Ngakho zama yonke into ngayinye ngayinye.

Indlela 1. Engaphambili

Inketho elula nesobala kakhulu ukukhetha kumenyu enkulu Qala - Izinhlelo - Excel (Qala - Izinhlelo - Excel). Ngeshwa, le ndlela yakudala isebenza kuphela ezinguqulweni ezindala ze-Excel.

Indlela 2: Inkinobho yegundane ephakathi noma i-Alt

Ungayivula kanjani i-Excel entsha efasiteleni elihlukile

  1. Chofoza okulungile ngokuchofoza isithonjana se-Excel kubha yomsebenzi - imenyu yokuqukethwe izovuleka nohlu lwamafayela akamuva.
  2. Phansi kwale menyu kuzoba nomugqa we-Excel - chofoza kuwo kwesokunxele inkinobho yegundane, ubambe ngenkathi ukhiye Alt.

Enye i-Excel kufanele iqale ngenqubo entsha. Futhi, esikhundleni sokuchofoza kwesokunxele nge Alt ungasebenzisa inkinobho yegundane ephakathi - uma igundane lakho linayo (noma isondo lokucindezela lidlala indima yalo).

Indlela 3. Umugqa womyalo

Khetha kumenyu enkulu Qala - Gijima (Qala - Gijima) noma cindezela isinqamuleli sekhibhodi Win+R. Enkanjini evelayo, faka umyalo:

Ungayivula kanjani i-Excel entsha efasiteleni elihlukile

Ngemuva kokuchofoza OK isibonelo esisha se-Excel kufanele siqale ngenqubo ehlukile.

Indlela 4. Macro

Le nketho iyinkimbinkimbi kakhulu kunangaphambili, kodwa isebenza kunoma iyiphi inguqulo ye-Excel ngokusho engikubonile:

  1. Ivula i-Visual Basic Editor ngethebhu Unjiniyela - I-Visual Basic (Unjiniyela — Isisekelo Esibonakalayo) noma isinqamuleli sekhibhodi Alt + F11. Uma amathebhu Unjiniyela ayibonakali, ungabonisa ngayo Ifayela – Izinketho – Ukusethwa kweRibhoni (Ifayela — Izinketho — Yenza Iribhoni Ngokwezifiso).
  2. Efasiteleni le-Visual Basic, faka imojuli entsha engenalutho yekhodi ngemenyu Faka – Imojula.
  3. Kopisha ikhodi elandelayo lapho:
Sub Run_New_Excel() Setha i-NewExcel = CreateObject("Excel.Application") NewExcel.Workbooks.Engeza i-NewExcel.Visible = Isihloko Sokuphela Kweqiniso

Uma usebenzisa i-macro edalwe manje nge Unjiniyela - Macros (Unjiniyela - Imakhro) noma isinqamuleli sekhibhodi Alt+F8, bese kwakhiwa isibonelo esihlukile se-Excel, njengoba besifuna.

Ukuze kube lula, ikhodi engenhla ingangezwa hhayi encwadini yamanje, kodwa ku-Personal Book of Macros futhi ufake inkinobho ehlukile yale nqubo kuphaneli yokufinyelela okusheshayo - khona-ke lesi sici sizohlala siseduze.

Indlela 5: Ifayela le-VBScript

Le ndlela iyafana neyangaphambili, kodwa isebenzisa i-VBScript, inguqulo eyenziwe lula kakhulu yolimi olubonakalayo oluyisisekelo, ukwenza izenzo ezilula khona kanye ku-Windows. Ukuze uyisebenzise yenza lokhu okulandelayo:

Okokuqala, vumela ukuboniswa kwezandiso zamafayela ku-Explorer ngokusebenzisa Buka – Izandiso zefayela (Buka - Izandiso zefayela):

Ungayivula kanjani i-Excel entsha efasiteleni elihlukile

Bese sakha ifayela lombhalo kunoma iyiphi ifolda noma kudeskithophu (ngokwesibonelo I-NewExcel.txt) bese ukopisha ikhodi elandelayo ye-VBScript lapho:

Setha i-NewExcel = CreateObject("I-Excel.Application") I-NewExcel.Izincwadi Zokusebenza.Engeza i-NewExcel.Visible = Isethi yeqiniso I-NewExcel = Akukho

Londoloza futhi uvale ifayela, bese ushintsha isandiso salo kusuka txt on ama-vbs. Ngemuva kokuqamba kabusha, kuzovela isixwayiso okufanele uvumelane naso, futhi isithonjana sefayela sizoshintsha:

Ungayivula kanjani i-Excel entsha efasiteleni elihlukile

Konke. Manje ngokuchofoza kabili inkinobho yegundane kwesokunxele kuleli fayela kuzoqalisa isibonelo esisha esizimele se-Excel uma usidinga.

PS

Khumbula ukuthi ngaphezu kobuhle, ukusebenzisa izimo eziningi ze-Excel kunobubi bakho futhi. lezi zinqubo zesistimu "aziboni" zodwa. Isibonelo, ngeke ukwazi ukwenza ukuxhumana okuqondile phakathi kwamaseli ebhuku lomsebenzi kuma-Excel ahlukene. Futhi, ukukopisha phakathi kwezimo ezihlukene zohlelo, njll. kuzoncishiswa kakhulu. Ezimweni eziningi, nokho, lokhu akulona inani elikhulu kangaka okufanele ulikhokhe ngokungachithi isikhathi sokulinda.

  • Indlela yokunciphisa usayizi wefayela futhi usheshise
  • Iyini i-Personal Macro Book nokuthi isetshenziswa kanjani

shiya impendulo