Momwe mungachotsere maselo opanda kanthu mu Excel

Mukamachita ntchito zambiri, mungafunike kuchotsa maselo opanda kanthu. Nthawi zambiri amakhala osafunikira ndipo amangowonjezera kuchuluka komwe wogwiritsa ntchito amasokonezeka. Timalongosola momwe mungachotsere mwachangu zinthu zopanda pake.

Chotsani Algorithms

Choyamba, muyenera kudziwa, ndipo ndizotheka kuchotsa maselo opanda kanthu mu katemera kapena patebulo. Njirayi imatsogolera ku kusamutsidwa kwa deta, ndipo izi sizovomerezeka. Mwanjira, zinthu zitha kungochotsedwa mu milandu iwiri:

• Ngati chingwe (mzere) ndi wopanda kanthu (m'matebulo);
• Ngati maselo mu zingwe ndi mzere sakhala wolumikizidwa wina ndi mnzake (ku Array).

Ngati pali maselo ochepa opanda kanthu, amatha kuchotsedwa kwathunthu pogwiritsa ntchito njira yochotsera buku. Koma, ngati pali zinthu zambiri zopanda kanthu, ndiye kuti njirayi, njirayi iyenera kungokhala.

Njira 1: Kusankhidwa kwa magulu a maselo

Njira yosavuta yochotsera zinthu zopanda pake ndikugwiritsa ntchito chida polekanitsa magulu a maselo.

1. Tikuwonetsa tsatanetsatane pa pepalalo lomwe lidzatsogolera ntchito yofufuza ndikuchotsa zinthu zopanda kanthu. Dinani pa kiyi ya ntchito pa kiyibodi f5.



2. Windo laling'ono layambitsidwa, lomwe limatchedwa "kusintha". Tidadina mmenemo "zowunikira ..." batani.



3. Windo lotsatirali likutsegulira - "magawo a magulu a maselo". Ikani switch ku "maselo opanda kanthu" mkati mwake. Chitani batani pa batani la "Ok".



4. Monga mukuwonera, zinthu zonse zopanda kanthu za mtundu womwe watchulidwa zidawunikiridwa. Dinani pa batani lililonse la mbewa. Munkhani yankhani yomwe ikuyenda bwino, dinani pa "Chotsani ..." chinthu.



5. Windo laling'ono limatsegulidwa lomwe muyenera kusankha zomwe muyenera kufufuta. Siyani makonda osinthika - "maselo, mosintha." Dinani pa batani la "OK".

Pambuyo pa izi zopopera izi, zinthu zonse zopanda kanthu mkati mwake zidzachotsedwa.

Njira 2: Kupanga mawonekedwe ndi kusefa

Chotsani ma cell osowa amathanso kugwiritsidwa ntchito pogwiritsa ntchito mawonekedwe azomwe mumalemba komanso osaneneka. Njirayi ndiyovuta kwambiri ndi yomwe yapitayo, koma, komabe, ogwiritsa ntchito ena amakonda. Kuphatikiza apo, ndikofunikira kusungitsa nthawi yomweyo kuti njirayi ndi yoyenera pokhapokha ngati mfundozo zili mgulu lomweli ndipo mulibe ma forlas.

1. Tikuwonetsa kuchuluka komwe kukuchitika. Pokhala mnyumba tabu, dinani pa chithunzi cha "mawonekedwe a Maphunziro", omwe, nawonso amapezeka mu "masitayilo". Pitani ku chinthu chomwe chatsegula mndandanda "mabungwe a magawidwe a maselo". Mu mndandanda wazomwe zikuwoneka, sankhani malo akuti "zochulukirapo ...".



2. Zenera lolemba malembedwe limatseguka. M'munda wamanzere kulowa nambala "0". M'munda woyenera, sankhani mtundu uliwonse, koma mutha kusiya makonda. Dinani pa batani la "OK".



3. Monga tikuwonera, maselo onse amtundu womwe umafotokozedwawo womwe umafotokozedwa mu mtundu wosankhidwa, ndipo opanda kanthu adakhala oyera. Kwezani gawo lathu. Mu tabu yomweyo, "kunyumba" dinani batani la "Mtundu ndi Fyulumu" yomwe ili m'gulu losintha. Mumenyu zomwe zimatsegulidwa, dinani batani la "Fyuluta".



4. Pambuyo pa zochita izi, monga tikuwona, fanizo losonyeza zafayilo limawonekera mu gawo lapamwamba la mzati. Dinani pa Iwo. Pa mndandanda womwe umatseguka, pitani ku "mtundu wa mtundu". Kenako, mgululi "mtundu wa utoto", sankhani utoto womwe wasankhidwa chifukwa cha mawonekedwe.

   

   Muthanso kuchita pang'ono. Dinani pa Chizindikiro cha Flojekiti. Mumenyu yomwe imawoneka, chotsani bokosi lochokera "lopanda kanthu". Pambuyo pake, dinani batani la "OK".



5. Mu aliyense mwa omwe atchulidwa m'mbuyomu, zinthu zopanda pake zibisika. Tikuwonetsa kuchuluka kwa maselo otsala. Pa tobu yanyumba, mu makonda a clipboard block, pangani dinani pa batani la "Copy".



6. Kenako tikuwonetsa kuti paliponse kapena pa pepala lina. Chitani batani la mbewa kumanja. Pankhani yazochita zomwe zimapezeka mu gawo la kulowetsa, sankhani "mtengo".



7. Monga mukuwonera, kuyika kwa data popanda kusungidwa. Tsopano mutha kuchotsa malo oyamba, ndikuyikanso imodzi yomwe tidalandira munthawi yomwe tafotokoza pamwambapa, ndipo mutha kupitiliza kugwira ntchito ndi zomwe zili pamalo atsopano. Zonse zimatengera ntchitozo komanso zomwe zimachitika.

Phunziro: Mawonekedwe oyenera ku Excel

Phunziro: Kusanja ndi kusefa deta kuti ikwaniritsidwe

Njira 3: Kugwiritsa ntchito njira yovuta

Kuphatikiza apo, ndizotheka kuchotsa maselo opanda kanthu kuchokera pakugwiritsa ntchito njira yovuta yogwiritsira ntchito njira zingapo.

1. Choyamba, tifunika kupereka dzina ku mitundu yomwe ikusintha. Tikutsindika malowa, timadina kumanja. Pa menyu oyambitsidwa, sankhani "dzina" ... "chinthu.



2. Tchulani zithunzi zophatikizira. Mu "Dzinalo" timapereka dzina lina losavuta. Mkhalidwe waukulu - suyenera kukhala ndi mipata. Mwachitsanzo, tinapatsa dzina "C_past" dzina. Palibenso kusintha pazenera zimenezo simukufuna. Dinani pa batani la "OK".



3. Timatsindika kulikonse papepala chimodzimodzi mawonekedwe ofanana ndi maselo opanda kanthu. Momwemonso, podina batani la mbewa lamanja ndipo, poyitanitsa menyu, pitani pa "Dzinalo ..." chinthu.



4. Pazenera lomwe limatseguka, monga kale, ikani dzina lililonse la malowa. Tinaganiza zoti dzinalo "lopanda kanthu".



5. Tikuwonetsa batani loyambirira la mbewa yakumanzere, selo loyamba la "lopanda kanthu" (mutha kutembenukira mosiyana). Ikani fomu yotsatirayi:

   = Ngati (chingwe () - chingwe (imelo) +1> Essay (ndi_posts) - ring (ndi_Padi () + () Ndi_posts))); mzere () - chingwe (imelo) +1); ndi_ndipo);

   Popeza uwu ndi njira yolumikizirana, ndikofunikira kukanikiza Ctrl + Shift + kulowa kiyi kuti muchotsere pazenera, m'malo mowerengera batani la Lower.



6. Koma, monga tikuwona, khungu limodzi lokha ndi lomwe linadzaza. Pofuna kudzazidwa ndi enawo, muyenera kukopera njira yotsala yamitundu yonse. Izi zitha kuchitika pogwiritsa ntchito cholembera. Ikani chotemberedwe kumunsi kwa chipinda chomwe chili ndi ntchito yokwanira. Cursor ayenera kusintha pamtanda. Dinani batani lakumanzere ndikukweza mpaka kumapeto kwa "imelo".



7. Monga mukuwonera, zitachitika izi, tili ndi mitundu yomwe maselo odzaza amakhala motsatana. Koma sitingathe kuchita zinthu zosiyanasiyana ndi izi, chifukwa zimagwirizanitsidwa ndi njira yatsamba. Timagawa mitundu yonse ya "imelo". Dinani pa batani la "Copy", lomwe limatumizidwa mu "Home" ku "Zosinthana ndi Chida cha Buffer".



8. Pambuyo pake, timagawa malo oyamba a data. Dinani batani lamanja. Mu mndandanda womwe umatsegulira mu magawo a magawo, dinani pa "mtengo".



9. Pambuyo pa zochita izi, zomwe zalembedwazo zidzaikidwa m'dera loyambirira la komwe lili ndi zolimba popanda maselo opanda kanthu. Ngati mukufuna, gulu lomwe lili ndi njirayi tsopano lingatheke.

Phunziro: Momwe Mungapangire dzina lam'manja

Pali njira zingapo zochotsera zinthu zopanda pake ku Microsoft Excel. Njira yotulutsa magulu am'malo ndiophweka komanso osafulumira. Koma pali zochitika zosiyanasiyana. Chifukwa chake, monga njira zowonjezera, mutha kugwiritsa ntchito zosankha ndi kusefa komanso kugwiritsa ntchito njira yovuta.