Amafomethi eseli ahlukene kakhulu

Kungenzeka nakuwe.

Lapho usebenza nencwadi yokusebenzela enkulu ku-Excel, ngesinye isikhathi akusona neze esimangalisayo wenza into engenabungozi ngokuphelele (ukwengeza umugqa noma ukufaka ucezu olukhulu lwamaseli, ngokwesibonelo) futhi kungazelelwe uthola iwindi elinephutha “Amaseli amaningi kakhulu ahlukene. amafomu":

Ngezinye izikhathi le nkinga ivela ngendlela engathandeki nakakhulu. Izolo ebusuku, njengenjwayelo, ulondoloze futhi wavala umbiko wakho ku-Excel, futhi namuhla ekuseni awukwazi ukuwuvula - umlayezo ofanayo uyaboniswa kanye nesiphakamiso sokususa konke ukufometha kufayela. Injabulo ayanele, uyavuma? Ake sibheke izimbangela nezindlela zokulungisa lesi simo.

Kungani lokhu kwenzeka

Leli phutha lenzeka lapho incwadi yokusebenza yeqa inani eliphakeme lamafomethi i-Excel engawagcina:

  • ku-Excel 2003 nangaphezulu - lawa amafomethi angama-4000
  • ku-Excel 2007 nangaphezulu, lawa amafomethi angu-64000

Ngaphezu kwalokho, ifomethi kuleli cala isho noma iyiphi inhlanganisela eyingqayizivele yezinketho zokufometha:

  • ifonti
  • ukugcwaliswa
  • uhlaka lweseli
  • ifomethi yezinombolo
  • ukufometha okunemibandela

Ngakho-ke, isibonelo, uma wenze isiqeshana seshidi isitayela kanje:

… bese i-Excel izokhumbula amafomethi amaseli ahlukene ayi-9 encwadini yokusebenzela, hhayi ama-2, njengoba kubonakala ekuqaleni, ngoba umugqa owugqinsi ozungeza umjikelezo uzodala, empeleni, izinketho zokufometha eziyi-8 ezihlukene. Engeza kuleyo midanso yomklami enamafonti nokugcwaliswa, futhi ukulangazelela ubuhle embikweni omkhulu kuzoholela kumakhulu nezinkulungwane zenhlanganisela efanayo okufanele i-Excel izikhumbule. Usayizi wefayela osuka kuwo, ngokwawo, nawo awunciphi.

Inkinga efanayo ivame ukwenzeka lapho ukopisha kaningi izingcezwana zamanye amafayela uwafake encwadini yakho yokusebenzela (isibonelo, lapho uhlanganisa amashidi nge-macro noma ngesandla). Uma ukunamathisela okukhethekile kwamanani kuphela kungasetshenziswa, khona-ke amafomethi obubanzi obukopishiwe nawo afakwa encwadini, okuholela ngokushesha ekweqeni umkhawulo.

Indlela yokubhekana nayo

Kunezikhombisi-ndlela ezimbalwa lapha:

  1. Uma unefayela lefomethi endala (xls), bese uligcina kabusha kwelisha (xlsx noma xlsm). Lokhu kuzophakamisa ngokushesha ibha kusuka ku-4000 kuya ku-64000 amafomethi ahlukene.
  2. Susa ukufometha kweseli okungafuneki kanye “nezinto ezinhle” ezengeziwe ngomyalo Ikhaya — Sula — Sula amafomethi (Ekhaya — Sula — Sula Ukufometha). Hlola ukuthi ayikho yini imigqa noma amakholomu emakhasini afomethwe ngokuphelele (okungukuthi, kuze kube sekupheleni kweshidi). Ungakhohlwa mayelana nemigqa namakholomu okungenzeka afihliwe.
  3. Hlola incwadi ukuze uthole amashidi afihliwe futhi acashe kakhulu - ngezinye izikhathi "imisebenzi yobuciko" ifihliwe kuwo.
  4. Susa ukufometha okunemibandela okungafuneki kuthebhu Ikhaya — Ukufometha Okunemibandela — Phatha Imithetho — Bonisa Imithetho Yokufometha Yeshidi Lonke (Ikhaya — Ukufometha Okunemibandela — Bonisa imithetho yaleli phepha lokusebenzela).
  5. Hlola ukuthi uqoqe inani eleqile lezitayela ezingadingekile ngemva kokukopisha idatha kwezinye izincwadi zokusebenza. Uma kuthebhu Ikhaya (Ikhaya) Ohlwini izitayela (Izitayela) inani elikhulu "lodoti":

    … khona-ke ungayisusa nge-macro encane. Chofoza I-Alt + F11 noma inkinobho Visual Basic ithebhu Unjiniyela (Unjiniyela), faka imojuli entsha ngemenyu Faka – Imojula bese ukopisha ikhodi enkulu lapho:

I-Sub Reset_Styles() 'susa zonke izitayela ezingadingekile Ku-objStyle Ngayinye Ku-ActiveWorkbook.Izitayela Zephutha Ziqala Kabusha Uma Kungekona objStyle.BuiltIn Bese objStyle.Susa Ngephutha GoTo 0 Next objStyle 'kopisha isethi ejwayelekile yezitayela encwadini entsha yomsebenzi = I-ActiveWorkbook Setha i-wbOkusha = Izincwadi Zokusebenzela.Engeza i-wbMy.Styles.Hlanganisa i-wbOkusha

Ungayethula ngesinqamuleli sekhibhodi. I-Alt + F8 noma ngenkinobho amamakhro (Amakhrosi) ithebhu Unjiniyela (Unjiniyela). I-macro izosusa zonke izitayela ezingasetshenzisiwe, ishiye kuphela isethi ejwayelekile:

  • Ungagqamisa Kanjani Ngokuzenzakalelayo Amaseli Ngokufometha Okunemibandela ku-Excel
  • Ayini ama-macros, kuphi futhi kanjani ukukopisha ikhodi ye-macro ku-Visual Basic, ukuthi isetshenziswa kanjani
  • Incwadi yokusebenzela ye-Excel isinzima kakhulu futhi ihamba kancane - ingalungiswa kanjani?

shiya impendulo