Matebulo okhala ndi mizere yopanda kanthu sawoneka okongola kwambiri. Kuphatikiza apo, chifukwa cha mizere yowonjezerayi, kuyenda pa iwo kumatha kukhala kovuta kwambiri, chifukwa muyenera kudutsa maselo akuluakulu kuti muchokere pa tebulo mpaka kumapeto. Tiyeni tiwone kuti ndi njira ziti zochotsera mzere mu Microsoft Excel, ndi momwe mungazichotsere mwachangu komanso zosavuta.
Kuchotsa wamba
Njira yodziwika kwambiri komanso yodziwika yochotsera mizere yopanda kanthu ndikugwiritsa ntchito menyu ya Excel pazosankha zomwe zili. Kuti muchotse mizere motere, sankhani maselo omwe mulibe deta, ndikudina kumanja. Pazosankha zomwe zikutsegulidwa, pitani ku "Fufutani ...". Simungathe kuyitanitsa mitu yanthawi yonse, koma lembani njira yachidule "Ctrl + -".
Windo laling'ono limawonekera momwe muyenera kufotokozera zomwe tikufuna kuchotsa. Tikuyika kusintha kwa "mzere" pamalo. Dinani pa "Chabwino" batani.
Pambuyo pake, mizere yonse yamtundu wosankhidwa idzachotsedwa.
Monga njira ina, mutha kusankha maselo mzere wolumikizana, ndipo mu "Home" tabu, dinani batani "Delete", lomwe lili "Zida" pazida. Pambuyo pake, kuchotsedwako kudzachitika pomwepo popanda mabokosi owonjezera.
Zachidziwikire, njirayi ndiyosavuta komanso yodziwika bwino. Koma kodi ndiyo yabwino koposa, yachangu kwambiri komanso yotetezeka?
Zosintha
Ngati mizere yopanda kanthu ili pamalo amodzi, ndiye kuti kuchotsedwa kwawo kudzakhala kosavuta. Koma, ngati amwazika patebulo, kusaka kwawo ndikuchotsa kungatenge nthawi yayitali. Potere, kusanja kuyenera kuthandiza.
Sankhani tebulo lonse. Timadina ndi batani loyenera la mbewa, ndikusankha "Sinthani" pazosankha. Pambuyo pake, menyu wina akuwonekera. Mmenemo muyenera kusankha chimodzi mwazinthu izi: "Sinthani kuchokera ku A mpaka Z", "Kuchokera pazochepa mpaka pazofunikira", kapena "Kuyambira watsopano mpaka wakale." Ndi ziti mwa zinthu zomwe zalembedwazo zomwe zizikhala mumndandanda wa malingana ndi mtundu wa deta womwe umayikidwa mu maselo a tebulo.
Akagwira ntchito pamwambapa, maselo onse opanda kanthu adzasunthidwa pansi penipeni pa tebulo. Tsopano, titha kuchotsa ma cell mu njira iliyonse yomwe idakambidwira gawo loyambirira la phunziroli.
Ngati dongosolo la kuyika masanjawo patebulo ndilofunikira, ndiye musanasankhe, ikani gawo lina pakati pa tebulo.
Maselo onse a chidachi awerengedwa mwadongosolo.
Kenako, sinthani ndi gawo lina lililonse, ndikumasula maselowo pansi, monga tafotokozera kale.
Pambuyo pake, kuti tibwezere mzere wofanana ndi womwe unali usanasungidwe, timasanja mzere wokhala ndi manambala "Kuyambira ochepera mpaka apamwamba".
Monga mukuwonera, mizereyo yapendekeka munjira yomweyo, kupatula zopanda kanthu zomwe zimachotsedwa. Tsopano, tiyenera kungochotsa mzere woonjezera ndi nambala za seri. Sankhani izi. Kenako dinani batani "" Fufutani "riboni. Pazosankha zomwe zimatsegulira, sankhani "Chotsani mzati kuchokera patsamba". Pambuyo pake, mzere womwe umafunikira udzachotsedwa.
Phunziro: Kutengera mu Microsoft Excel
Chosefera ntchito
Njira ina yobisa maselo opanda kanthu ndikugwiritsa ntchito fyuluta.
Sankhani malo onse patebulopo, ndipo, opezeka pa "Home" tabu, dinani batani la "Sort and Filter", lomwe lili "Sinthani" pazida. Pazosankha zomwe zikuwoneka, pitani ku "Zosefera".
Chithunzi chojambula chimawonekera m'maselo am'mutu wa tebulo. Dinani pachizindikiro ichi patsamba lililonse lomwe mungasankhe.
Pazosankha zomwe zikuwoneka, tsembani chinthu "chopanda". Dinani pa "Chabwino" batani.
Monga mukuwonera, zitatha izi, mizere yopanda kanthu idasowa, popeza idasefedwa.
Phunziro: Momwe mungagwiritsire ntchito autofilter mu Microsoft Excel
Wosankha Cell
Njira ina yochotsera imagwiritsa ntchito kusankha kwa maselo opanda kanthu. Kuti mugwiritse ntchito njirayi, sankhani kaye tebulo lonse. Kenako, kukhala mu "Home" tabu, dinani batani la "Pezani ndi Kusankha", lomwe lili kumbali ya gulu la zida "Kusintha". Pazosankha zomwe zimawonekera, dinani pazinthu "Sankhani gulu la maselo ...".
Windo limatseguka momwe timasinthira kusintha kwa "maselo opanda kanthu". Dinani pa "Chabwino" batani.
Monga mukuwonera, zitatha izi, mizere yonse yokhala ndi maselo opanda kanthu imawunikidwa. Tsopano dinani batani la "Fufutani", lomwe tidali nalo kale, lomwe limapezeka kumbali ya chida cha "Maselo".
Pambuyo pake, mizere yonse yopanda kanthu imachotsedwa patebulo.
Chidziwitso chofunikira! Njira yotsirizayi siyingagwiritsidwe ntchito pamatafura okhala ndi mizere yopingasa, komanso ndi maselo opanda kanthu omwe ali m'mizere komwe idatha imapezeka. Pankhaniyi, kusintha kwa khungu kumatha kuchitika ndipo tebulo lidzasweka.
Monga mukuwonera, pali njira zingapo zochotsera maselo opanda kanthu pagome. Ndi njira iti yomwe ndiyenera kugwiritsa ntchito kutengera zovuta za tebulo, komanso momwe mizere yopanda kanthu imamwaziridwira mozungulira (ili pabowo limodzi, kapena yosakanizidwa ndi mizere yodzadza ndi deta).
