Momwe mungadzazire ma cell opanda kanthu okhala ndi zinthu zapamwamba mu Excel

Mukadzaza tebulo la Excel ndi zinthu zina (nthawi zambiri mukawonjezera zambiri), nthawi zambiri pamakhala malo opanda kanthu. Iwo sangasokoneze kulingalira kwa fayilo yomwe ikugwira ntchito yokha, komabe, idzasokoneza ntchito za kusanja, kuwerengera deta, kusefa manambala ena, mafomu, ndi ntchito. Kuti pulogalamuyo igwire ntchito popanda zovuta, ndikofunikira kuphunzira kudzaza ma voids ndi ma cell oyandikana nawo.

Momwe mungawunikire ma cell opanda kanthu patsamba lantchito

Musanayambe kuganizira momwe mungadzazire ma cell opanda kanthu patsamba la Excel, muyenera kuphunzira momwe mungasankhire. Izi ndizosavuta kuchita ngati tebulo lili laling'ono. Komabe, ngati chikalatacho chili ndi ma cell ambiri, malo opanda kanthu atha kukhala m'malo osasintha. Kusankha pamanja kwa maselo amodzi kudzatenga nthawi yayitali, pomwe malo ena opanda kanthu amatha kudumpha. Kuti tisunge nthawi, tikulimbikitsidwa kuti tichite izi pogwiritsa ntchito zida zomangidwira pulogalamuyi:

1. Choyamba, muyenera kuyika ma cell onse a pepalalo. Kuti muchite izi, mutha kugwiritsa ntchito mbewa yokha kapena kuwonjezera makiyi a SHIFT, CTRL kuti musankhe.
2. Pambuyo pake, yesani kuphatikiza kiyi pa kiyibodi CTRL + G (njira ina ndi F5).
3. Zenera laling'ono lotchedwa Go To liyenera kuwonekera pazenera.
4. Dinani pa "Sankhani" batani.

Kuti mulembe ma cell patebulo, pazida zazikulu, muyenera kupeza ntchito ya "Pezani ndi Sankhani". Pambuyo pake, menyu yankhani idzawoneka, yomwe muyenera kusankha zosankha zina - mafomu, maselo, zokhazikika, zolemba, maselo aulere. Sankhani ntchito "Sankhani gulu la ma cell. Kenako, zenera la zoikamo lidzatsegulidwa momwe muyenera kuyang'ana bokosi pafupi ndi gawo la "Empty cell". Kuti musunge zoikamo, muyenera dinani batani "Chabwino".

Momwe mungadzazire ma cell opanda kanthu pamanja

Njira yosavuta yodzaza ma cell opanda kanthu patsamba lokhala ndi zikhalidwe zochokera m'maselo apamwamba ndi kudzera pa "Lembani ma cell opanda kanthu", omwe ali pagawo la XLTools. Kachitidwe:

1. Dinani batani kuti mutsegule "Lembani ma cell opanda kanthu".
2. Zenera la zoikamo liyenera kutsegulidwa. Pambuyo pake, m'pofunika kulemba mndandanda wa maselo omwe m'pofunika kudzaza malo opanda kanthu.
3. Sankhani njira yodzaza - kuchokera pazomwe zilipo zomwe muyenera kusankha: kumanzere, kumanja, mmwamba, pansi.
4. Chongani bokosi pafupi ndi "Onjezani Maselo".

Zimatsalira kukanikiza batani la "Chabwino" kuti ma cell opanda kanthu adzaze ndi chidziwitso chofunikira.

Zofunika! Chimodzi mwazinthu zothandiza pa ntchitoyi ndikusunga ma values. Chifukwa cha izi, zidzatheka kubwereza zomwezo ndi mndandanda wotsatira wa maselo popanda kukonzanso ntchitoyo.

Makhalidwe omwe alipo odzaza ma cell opanda kanthu

Pali zosankha zingapo zodzaza ma cell opanda kanthu patsamba la Excel:

1. Lembani kumanzere. Pambuyo poyambitsa ntchitoyi, maselo opanda kanthu adzadzazidwa ndi deta kuchokera ku maselo omwe ali kumanja.
2. Lembani kumanja. Mukadina pamtengowu, ma cell opanda kanthu adzadzazidwa ndi chidziwitso kuchokera kumaselo akumanzere.
3. Lembani. Maselo pamwamba adzadzazidwa ndi deta kuchokera ku maselo pansi.
4. Kudzaza pansi. Njira yotchuka kwambiri yodzaza ma cell opanda kanthu. Zambiri kuchokera m'maselo omwe ali pamwambawa amasamutsidwa ku maselo a tebulo ili m'munsimu.

Ntchito ya "Dzazani ma cell opanda kanthu" imakopera ziwerengero (mawerengero, zilembo) zomwe zili m'maselo odzazidwa. Komabe, pali zina pano:

1. Ngakhale pobisala kapena kutsekereza cell yodzaza, zambiri kuchokera pamenepo zimasamutsidwa ku cell yaulere mutatha kuyambitsa ntchitoyi.
2. Nthawi zambiri zimachitika kuti mtengo wosinthira ndi ntchito, chilinganizo, ulalo wamaselo ena patsamba lantchito. Pankhaniyi, selo lopanda kanthu lidzadzazidwa ndi mtengo wosankhidwa popanda kusintha.

Zofunika! Musanayambe ntchito ya "Dzazani maselo opanda kanthu", muyenera kupita ku zoikamo zamasamba, muwone ngati pali chitetezo. Ngati yayatsidwa, chidziwitsocho sichidzasamutsidwa.

Kudzaza ma cell opanda kanthu ndi fomula

Njira yosavuta komanso yachangu yodzaza ma cell mu tebulo la data kuchokera ku maselo oyandikana nawo ndikugwiritsa ntchito njira yapadera. Kachitidwe:

1. Chongani ma cell opanda kanthu momwe tafotokozera pamwambapa.
2. Sankhani mzere wolowetsa ma formula a LMB kapena dinani batani F
3. Lowetsani chizindikiro "="".

4. Pambuyo pake, sankhani cell yomwe ili pamwambapa. Fomula iyenera kuwonetsa selo lomwe uthengawo udzakopera ku cell yaulere.

Chomaliza ndikusindikiza makiyi ophatikizira "CTRL + Enter" kuti fomulayo igwire ntchito pama cell onse aulere.

Zofunika! Sitiyenera kuiwala kuti mutagwiritsa ntchito njirayi, maselo onse omwe anali opanda ufulu adzadzazidwa ndi mafomu. Kuti musunge dongosolo mu tebulo, tikulimbikitsidwa kuti muwasinthe ndi chiwerengero cha chiwerengero.

Kudzaza ma cell opanda kanthu ndi macro

Mukakhala kuti mukuyenera kudzaza ma cell opanda kanthu m'mapepala ogwirira ntchito, tikulimbikitsidwa kuti muwonjezere macro ku pulogalamuyo, mugwiritse ntchito pambuyo pake kuti musinthe njira yosankha, kudzaza ma cell opanda kanthu. Lembani code ya macro:

Sub Fill_Blanks()

    Kwa selo Lililonse Mukusankha

        Ngati IsEmpty(cell) Ndiye cell.Value = cell.Offset(-1, 0).Value

    Ena selo

TSIRIZA Sub

Kuti muwonjezere macro, muyenera kuchita zingapo:

1. Dinani kuphatikiza kiyi ALT+F
2. Izi zidzatsegula mkonzi wa VBA. Matani kachidindo pamwambapa pa zenera laulere.

Ingotsala kutseka zenera la zoikamo, kuwonetsa chithunzi cha macro mugawo lofikira mwachangu.

Kutsiliza

Mwa njira zomwe tafotokozazi, muyenera kusankha imodzi yomwe ikuyenerana ndi vuto linalake. Njira yamanja yowonjezerera deta kumalo aulere a tsamba lothandizira ndiyoyenera kudziwa zambiri, kugwiritsa ntchito nthawi imodzi. M'tsogolomu, tikulimbikitsidwa kuti tidziwe bwino fomula kapena kulembetsa macro (ngati njira yomweyo imachitika nthawi zambiri).