Momwe mungasinthire nkhani mu Excel 2016, 2013 kapena 2010

Ogwiritsa ntchito ambiri a Excel amakumana ndi zovuta chifukwa cholephera kusintha mwachangu nkhani yamalemba pamapepala. Pazifukwa zina, Microsoft idangowonjezera izi ku Mawu ndikusiya Excel popanda izo. Koma izi sizikutanthauza kuti muyenera kusintha pamanja mawu mu selo iliyonse - pali njira zazifupi zingapo. Atatu a iwo afotokozedwa pansipa.

Excel ntchito zapadera

Mu Excel, pali ntchito zomwe zimawonetsa zolemba mwanjira ina - LANGIZO (), WAPASI() и prop (). Woyamba amamasulira mawu onse kukhala zilembo zazikulu, wachiwiri - m'malembo ang'onoang'ono, wachitatu amangotembenuza zilembo zoyambirira kukhala zilembo zazikulu, zotsalazo zimangolemba zilembo zazing'ono. Onse amagwira ntchito pa mfundo imodzi, choncho, pogwiritsa ntchito chitsanzo chimodzi - chikhale LANGIZO () - mutha kuwona momwe mungagwiritsire ntchito onse atatu.

Lowetsani chilinganizo

1. Pangani ndime yatsopano pafupi ndi yomwe mukufuna kusintha, kapena ngati kuli koyenera, ingogwiritsani ntchito ndime yopanda kanthu pafupi ndi tebulo.

2. Lowetsani chizindikiro chofanana (=) chotsatiridwa ndi dzina lantchito (WOPEREKA) mu cell yazanja pafupi ndi ma cell apamwamba kwambiri osinthika.

M'mabulaketi pambuyo pa dzina lantchito, lembani dzina la cell yoyandikana ndi mawu (pazithunzi pansipa, iyi ndi selo C3). Fomula idzawoneka ngati =PROPISN(C3).

4. Gulani Lowani.

Cell B3 tsopano ili ndi mawu a cell C3 mu zilembo zazikulu.

Lembani fomula kumaselo omwe ali pansi pa mzerewu

Tsopano chilinganizo chomwecho chingagwiritsidwe ntchito ku maselo ena muzakudya.

5. Sankhani selo lomwe lili ndi fomula.
6. Sunthani cholozera kumalo ang'onoang'ono (chizindikiro chodzaza), chomwe chili pansi kumanja kwa selo - muvi wolozera uyenera kusandulika kukhala mtanda.

7. Kusunga batani la mbewa, kokerani cholozera pansi kuti mudzaze ma cell onse ofunikira - chilinganizocho chidzakopera mwa iwo.
8. Tulutsani batani la mbewa.

Ngati mukufuna kudzaza ma cell onse agawo mpaka pansi pa tebulo, ingoyang'anani pamwamba pa cholembera ndikudina kawiri.

Chotsani mzati wothandizira

Tsopano pali mizati iwiri yokhala ndi mawu ofanana m'maselo, koma mosiyana. Kuti musunge imodzi yokha, koperani zomwe zili mugawo la othandizira, ikani mugawo lomwe mukufuna, ndikuchotsa wothandizirayo.

1. Sankhani maselo omwe ali ndi fomula ndikudina Ctrl + C.

2. Dinani kumanja patsamba loyamba la ma cell omwe ali ndi mawu omwe mukufuna mugawo losinthika.
3. Pansi pa "Paste options" sankhani chizindikiro Makhalidwe mndandanda wazakudya.

4. Dinani kumanja pagawo lothandizira ndikusankha Chotsani.
5. M'bokosi la zokambirana lomwe likuwoneka, sankhani Chigawo Chonse. 

Tsopano zonse zachitika.

Mafotokozedwe ake angaoneke ngati ovuta. Koma ingotsatirani zomwe mwapatsidwa ndipo mudzawona kuti palibe chovuta mmenemo.

Kusintha mawu pogwiritsa ntchito Microsoft Word

Ngati simukufuna kusokoneza ndi mafomula mu Excel, mutha kugwiritsa ntchito lamulo kuti musinthe nkhani mu Mawu. Tiyeni tiwone momwe zimagwirira ntchito.

1. Sankhani ma cell omwe mukufuna kusintha.
2. Ntchito Ctrl + C kapena dinani kumanja pa malo osankhidwa ndikusankha Koperani mndandanda wazakudya.

3. Tsegulani chikalata chatsopano mu Word.
4. Press Ctrl + V kapena dinani kumanja pepala ndikusankha Ikani.

Tsopano kope la tebulo lanu lili mu chikalata cha Mawu.

5. Sankhani ma cell omwe mukufuna kusintha mawuwo.
6. Dinani chithunzi Register, yomwe ili m'gululi Zilembo mu tab Kunyumba.
7. Sankhani chimodzi mwazinthu zisanu zomwe mungasankhe kuchokera pamndandanda wotsitsa.

Mukhozanso kusankha malemba ndikugwiritsa ntchito Shift + F3 mpaka malembawo ali olondola. Mwanjira imeneyi, mutha kusankha njira zitatu zokha - zapamwamba, zotsika komanso zachiganizo (momwe chiganizo chilichonse chimayamba ndi zilembo zazikulu, zilembo zina zonse ndi zazing'ono).

Tsopano popeza mawu omwe ali patebulo ali mumpangidwe womwe mukufuna, mutha kungowakoperanso ku Excel.

Kugwiritsa ntchito VBA macros

Kwa Excel 2010 ndi 2013, pali njira ina yosinthira zolemba - VBA macros. Momwe mungayikitsire khodi ya VBA mu Excel ndikupangitsa kuti igwire ntchito ndi mutu wankhani ina. Apa, ma macro okonzeka okha omwe atha kuyikidwa ndi omwe awonetsedwa.

Mutha kugwiritsa ntchito macro otsatirawa kuti musinthe mawu kukhala zilembo zazikulu:

Kalembo kakang'ono ()

    Kwa Selo Lililonse Mukusankha

        Ngati Si Cell.HasFormula Ndiye

            Cell.Value = UCase(Cell.Value)

        Kutha Ngati

    Selo Yotsatira

mapeto Sub

Kwa zilembo zazing'ono, code iyi idzachita:

Zolemba Zing'onozing'ono ()

    Kwa Selo Lililonse Mukusankha

        Ngati Si Cell.HasFormula Ndiye

            Cell.Value = LCase(Cell.Value)

        Kutha Ngati

    Selo Yotsatira

mapeto Sub

Macro kuti liwu lililonse liyambe ndi zilembo zazikulu:

Katundu Wang'ono ()

    Kwa Selo Lililonse Mukusankha

        Ngati Si Cell.HasFormula Ndiye

            Cell.Value = _

            Ntchito _

            .WorksheetFunction _

            .Zoyenera(Cell.Value)

        Kutha Ngati

    Selo Yotsatira

mapeto Sub

Tsopano mukudziwa momwe mungasinthire vuto la zolemba mu Excel. Monga mukuonera, izi sizili zovuta, ndipo palibe njira imodzi yochitira - ndi njira iti yomwe ili pamwambayi yomwe ili yabwino kwa inu.