Momwe Mungapezere Zobwereza Zobwereza mu Excel Table Column

Gome lokhala ndi mfundo zofanana ndi vuto lalikulu kwa ogwiritsa ntchito ambiri a Microsoft Excel. Zambiri zobwerezabwereza zitha kuchotsedwa pogwiritsa ntchito zida zomwe zidapangidwa mu pulogalamuyi, kubweretsa tebulo kukhala mawonekedwe apadera. Momwe mungachitire molondola tidzakambirana m'nkhaniyi.

Njira 1 Momwe mungayang'anire zobwerezedwa ndikuzichotsa pogwiritsa ntchito Conditional Formatting chida

Kuti chidziwitso chomwecho chisabwerezedwe kangapo, chiyenera kupezeka ndikuchotsedwa pa tebulo, ndikusiya njira imodzi yokha. Kuti muchite izi, muyenera kuchita zotsatirazi:

1. Gwiritsani ntchito batani lakumanzere la mbewa kuti musankhe magulu osiyanasiyana omwe mukufuna kuwona kuti apezanso zambiri. Ngati ndi kotheka, mukhoza kusankha tebulo lonse.
2. Pamwamba pa zenera, dinani "Home" tabu. Tsopano, pansi pazida, malo omwe ali ndi ntchito za gawoli ayenera kuwonetsedwa.
3. Mugawo la "Masitayelo", dinani kumanzere pa batani la "Conditional Formatting" kuti muwone kuthekera kwa ntchitoyi.
4. Pazosankha zomwe zikuwoneka, pezani mzere "Pangani lamulo ..." ndikudina ndi LMB.

5. Pamndandanda wotsatira, mugawo la "Sankhani mtundu wa lamulo", muyenera kusankha mzere "Gwiritsani ntchito fomula kuti mudziwe ma cell opangidwa."
6. Tsopano, pamzere wolowetsa pansipa ndimeyi, muyenera kulowetsa pamanja fomula kuchokera pa kiyibodi “=COUNTIF($B$2:$B$9; B2)>1”. Zilembo zomwe zili m'makoloko zimasonyeza kuchuluka kwa maselo omwe kupanga masanjidwe ndi kufufuza kobwereza kudzachitidwa. M'mabulaketi, ndikofunikira kulembera mndandanda wazinthu zatebulo ndikupachika zikwangwani zamadola pamaselo kuti chilinganizocho "chisachoke" panthawi yokonza.

7. Ngati mungafune, pamenyu ya "Pangani lamulo la masanjidwe", wogwiritsa ntchito adina batani la "Format" kuti afotokoze mtundu womwe udzagwiritsidwe ntchito kuwunikira zobwereza pazenera lotsatira. Izi ndizosavuta, chifukwa zikhalidwe zobwerezedwa nthawi yomweyo zimakopa chidwi.

Tcherani khutu! Mutha kupeza zobwereza mu Excel spreadsheet pamanja, ndi diso, poyang'ana selo lililonse. Komabe, izi zidzatengera wogwiritsa ntchito nthawi yambiri, makamaka ngati tebulo lalikulu likuyang'aniridwa.

Njira 2: Pezani ndikuchotsa zobwerezabwereza pogwiritsa ntchito batani la Chotsani Zobwereza

Microsoft Office Excel ili ndi mawonekedwe apadera omwe amakupatsani mwayi wochotsa ma cell omwe ali ndi chidziwitso chobwereza patebulo. Njirayi imayatsidwa motere:

1. Mofananamo, onetsani tebulo kapena magulu enaake mu Excel worksheet.
2. Pamndandanda wa zida zomwe zili pamwamba pa mndandanda waukulu wa pulogalamuyi, dinani mawu akuti "Data" kamodzi ndi batani lakumanzere.
3. Pakagawo "Kugwira ntchito ndi data", dinani batani la "Chotsani zobwereza".

4. Pazosankha zomwe zikuyenera kuwonekera mutatha kuchita zomwe zili pamwambapa, fufuzani bokosi pafupi ndi mzere "My Data" lili ndi mitu. Mu gawo la "Columns", mayina amizere yonse ya mbale adzalembedwa, muyeneranso kuyang'ana bokosi lomwe lili pafupi ndi iwo, ndiyeno dinani "Chabwino" pansi pawindo.

5. Chidziwitso cha zobwereza zomwe zapezeka chidzawonekera pazenera. Iwo adzachotsedwa basi.

Zofunika! Pambuyo pochotsa zobwereza, mbaleyo iyenera kubweretsedwa ku mawonekedwe "oyenera" pamanja kapena pogwiritsa ntchito njira yosinthira, chifukwa mizere ina ndi mizere imatha kutuluka.

Njira 3: Kugwiritsa ntchito fyuluta yapamwamba

Njira yochotsera zobwereza ili ndi kukhazikitsa kosavuta. Kuti mumalize, mudzafunika:

1. Mu gawo la "Data", pafupi ndi batani la "Sefa", dinani mawu akuti "Zapamwamba". Zenera la Advanced Filter limatsegulidwa.

2. Ikani chosinthira pafupi ndi mzere "Koperani zotsatira kumalo ena" ndikudina chizindikiro chomwe chili pafupi ndi gawo la "Initial range".
3. Sankhani ndi mbewa magulu osiyanasiyana omwe mukufuna kupeza obwereza. Zenera la kusankha lidzatseka basi.
4. Kenako, mumzere "Ikani zotsatira mumtundu", muyeneranso kudina LMB pachithunzichi kumapeto ndikusankha selo iliyonse kunja kwa tebulo. Ichi chidzakhala chiyambi pomwe chizindikiro chosinthidwa chidzayikidwa.

5. Chongani bokosi "Only unique records" ndikudina "Chabwino". Zotsatira zake, tebulo losinthidwa popanda zobwereza liziwoneka pafupi ndi gulu loyambirira.

Zina Zowonjezera! Maselo akale akhoza kuchotsedwa, kusiya chizindikiro chokonzedwa.

Njira 4: Gwiritsani ntchito PivotTables

Njirayi imatengera kutsata ndondomeko ya tsatane-tsatane:

1. Onjezani gawo lothandizira patebulo loyambirira ndikuwerengera kuyambira 1 mpaka N. N ndi nambala ya mzere womaliza pamndandanda.

2. Pitani ku gawo la "Insert" ndikudina batani la "Pivot Table".

3. Pazenera lotsatira, ikani chosinthira pamzere "Kutsamba lomwe lilipo", mugawo la "Table or range", tchulani ma cell angapo.
4. Mu mzere wa "Range", tchulani selo loyambirira lomwe mndandanda wa tebulo lokonzedwa lidzawonjezedwa ndikudina "Chabwino".

5. Pazenera kumanzere kwa tsamba logwirira ntchito, chongani mabokosi omwe ali pafupi ndi mayina azazakudya.

6. Onani zotsatira.

Kutsiliza

Chifukwa chake, pali njira zingapo zochotsera zobwereza mu Excel. Njira zawo zonse zitha kutchedwa zosavuta komanso zothandiza. Kuti mumvetsetse mutuwo, muyenera kuwerenga mosamala zomwe zili pamwambapa.