Mukamagwira ntchito ku Excel, mungafunike kuchotsa maselo opanda kanthu. Nthawi zambiri zimakhala zopanda pake ndipo zimangowonjezera zosankha zonse zomwe zimasokoneza wosuta. Tifotokoza njira zochotsera zinthu zopanda pake mwachangu.
Kuchotsa Algorithms
Choyambirira, muyenera kuzindikira, kodi ndizotheka kuzimitsa maselo opanda kanthu mumtundu winawake kapena patebulo? Njirayi imabweretsa kukondera kwa deta, ndipo izi ndizosavomerezeka nthawi zonse. M'malo mwake, zinthu zitha kuchotsedwa pawiri:
- Ngati mzere (mzati) ulibe kanthu (m'matafura);
- Ngati maselo mumizere ndi mzere saalumikizana bwino (munthawi zonse).
Ngati pali ma cell ochepa, ndiye kuti amatha kuchotsedwa kwathunthu pogwiritsa ntchito njira yochotsera. Koma, ngati pali chiwerengero chachikulu cha zinthu zosakwaniritsidwa, ndiye pamenepa, njirayi imayenera kusinthidwa.
Njira 1: sankhani ma cell
Njira yosavuta yochotsera zopanda kanthu ndikugwiritsa ntchito chida cha maselo a gulu.
- Timasankha zolemba pamapepala zomwe tidzagwire ntchito posaka ndi kuchotsa zinthu zopanda kanthu. Dinani pa batani la ntchito pa kiyibodi F5.
- Windo laling'ono lotchedwa Kusintha. Dinani batani mmenemo "Sankhani ...".
- Tsamba lotsatirali likutsegulira - "Kusankha magulu am'melo". Khazikitsani kusinthaku Maselo opanda kanthu. Dinani batani. "Zabwino".
- Monga mukuwonera, zinthu zonse zopanda pake za mtundu womwe zidasankhidwa zasankhidwa. Timadulira aliyense waiwo ndi batani loyenera la mbewa. Pazosankha zomwe zikuyamba, dinani chinthucho Chotsani ... ".
- Iwindo laling'ono limatseguka pomwe muyenera kusankha zomwe zimayenera kuchotsedwa. Siyani makonda - "Maselo osunthira mmwamba". Dinani batani "Zabwino".
Pambuyo pamanyengowa, zinthu zonse zopanda kanthu zomwe zili mumtunduwo zichotsedwa.
Njira 2: kusanja mawonekedwe ndi kusefa
Mutha kuzimitsanso maselo opanda kanthu pogwiritsa ntchito mitundu yojambulidwa ndi kusefa kwazotsatira. Njirayi ndiyovuta kwambiri kuposa yoyamba, koma, ena amagwiritsa ntchito. Kuphatikiza apo, muyenera kupanga kasitomala kuti njira iyi ndioyenera kokha ngati mfundozo zili mgulu lomweli ndipo mulibe fomula.
- Sankhani mtundu womwe tikukonza. Kukhala mu tabu "Pofikira"dinani pachizindikiro Njira Zakukonzerani, yomwe, ili m'bokosi la chida Masitaelo. Pitani ku chinthucho mndandanda womwe umatseguka. Malamulo Osankha Maselo. Pamndandanda wazinthu zomwe zimawoneka, sankhani malo "Zambiri ...".
- Windo lophatikiza zikhalidwe limatseguka. Lowetsani manambala kumunda wamanzere "0". M'munda woyenera, sankhani mtundu uliwonse, koma mutha kusiya zosintha. Dinani batani "Zabwino".
- Monga mukuwonera, maselo onse omwe ali mumtundu womwe zimakhazikitsidwa zomwe amaziwonetsa mumtundu wosankhidwa, ndipo zopanda kanthuzo zimakhalabe zoyera. Ndiponso, sonyezani malingaliro athu. Pa tabu yemweyo "Pofikira" dinani batani Sanjani ndi Fyulutaili m'gululi "Kusintha". Pazosankha zomwe zimatsegulira, dinani batani "Zosefera".
- Pambuyo pa izi, monga momwe tikuonera, chithunzi choyimira zosefera chidawonekera kumtunda kwa mzati. Dinani pa izo. Pamndandanda womwe umatseguka, pitani "Sinizani ndi utoto". Komanso m'gululo "Sinizani ndi mtundu wa khungu" sankhani mtundu womwe masankhidwewo adachitika chifukwa cha mawonekedwe.
Mutha kuchita zina mosiyana. Dinani pa chithunzi. Pazosankha zomwe zikuwoneka, sanayankhe "Zachabe". Pambuyo pake, dinani batani "Zabwino".
- Mwa zilizonse zomwe zasonyezedwa m'ndime yapitayi, zinthu zopanda pake zitha kubisika. Sankhani maselo osiyanasiyana omwe atsalira. Tab "Pofikira" mumazisungidwe Clipboard dinani batani Copy.
- Kenako sankhani malo opanda kanthu patsamba lomwelo kapena pepala lina. Dinani kumanja. Pa mndandanda wazinthu zomwe zikuwoneka, pazosankha zofunikira, sankhani "Makhalidwe".
- Monga mukuwonera, detayo idayikidwa popanda kujambulidwa. Tsopano mutha kufufuta lonse, ndipo m'malo mwake ikani imodzi yomwe tidalandira pamwambapa, kapena mutha kupitiliza kugwira ntchito ndi malo m'malo atsopano. Zonse zimatengera ntchito komanso ntchito zomwe wogwiritsa ntchito amakhala nazo.
Phunziro: Zowongolera mu Excel
Phunziro: Sanjani ndi kusefa deta mu Excel
Njira 3: kutsatira njira yovuta
Kuphatikiza apo, mutha kuchotsa maselo opanda kanthu pamtunduwu pogwiritsa ntchito njira yovuta yophatikizira zingapo.
- Choyamba, tifunika kupereka dzina ku magulu omwe akusintha. Sankhani malowa, dinani kumanja. Pazosankha zomwe mwazichita, sankhani "Patsani dzina ...".
- Zenera lomwe amatchulalo limatsegulidwa. M'munda "Dzinalo" perekani dzina lililonse labwino. Chikhalidwe chachikulu ndikuti sipayenera kukhala malo. Mwachitsanzo, tidatipatsa dzina pamulingo. "C_empty". Palibenso zinthu zina zofunika pa windo limenelo. Dinani batani "Zabwino".
- Sankhani kulikonse pepala ndendende kukula kwa maselo opanda kanthu. Momwemonso, timadina pomwe ndikutchula menyu wankhani, pitani ku chinthucho "Patsani dzina ...".
- Pazenera lomwe limatseguka, ngati kale, timapereka dzina lililonse kuderali. Tinaganiza zomupatsa dzina "Osati_opanda".
- Dinani kawiri batani lakumanzere patsamba loyamba la zofunikira "Osati_opanda" (ikhoza kukhala ndi dzina losiyana ndi inu). Timalowetsa mmenemo mtundu wotsatira:
= IF (LINE () - LINE (Bila_empty) +1> STRING (With_empty) -Count VOIDs (Ndi_empty); ""; (~Popeza iyi ndi makonzedwe angapo, kuwonetsa kuwerengera pazenera, muyenera kukanikiza kuphatikiza kiyi Ctrl + Shift + Lowani, m'malo mwa batani wamba Lowani.
- Koma, monga tikuonera, khungu limodzi lokha ndi lomwe linadzaza. Pofuna kudzaza zina zonse, muyenera kukopera fomuloli kwa ena onse. Izi zitha kuchitika pogwiritsa ntchito cholemba. Timayika cholowera ngodya yotsika kumanja kwa cell yomwe ili ndi ntchito yovuta. Temberero liyenera kusinthidwa kukhala mtanda. Gwirani batani lakumanzere ndikulikoka mpaka kumapeto kwa mtunduwo "Osati_opanda".
- Monga mukuwonera, zitatha izi tili ndi mndandanda womwe maselo odzazidwa amapezeka mzere. Koma sitingachite zinthu zingapo ndi izi, chifukwa ndizogwirizana ndi mndandanda wazomwe zidasankhidwa. Sankhani mtundu wonse. "Osati_opanda". Dinani batani Copyyomwe imayikidwa mu tabu "Pofikira" mu bokosi la zida Clipboard.
- Pambuyo pake timasankha mndandanda woyambira woyamba. Timadina batani loyendetsera mbewa. Pamndandanda womwe umatseguka m'gululo Ikani Zosankha dinani pachizindikiro "Makhalidwe".
- Pambuyo pa izi, idatha imayikidwa m'dera loyambirira la malo ake ndi gulu lolimba lopanda maselo opanda kanthu. Ngati mungafune, mndandanda womwe uli ndi formula tsopano ungathe kuchotsedwa.
Phunziro: Momwe mungatchulire dzina la foni mu Excel
Pali njira zingapo zochotsera zopanda kanthu mu Microsoft Excel. Njira yosankha maselo ndi yosavuta komanso yachangu kwambiri. Koma zinthu sizinasinthe. Chifukwa chake, ngati njira zowonjezera, ndikotheka kugwiritsa ntchito zosankha ndi kusefa komanso kugwiritsa ntchito njira yovuta.
