Chotsani mizere yobisika mu Excel. Mmodzi ndi mmodzi ndi zonse mwakamodzi

Mu Microsoft Office Excel, mutha kuchotsa mwachangu mizere yobisika, yopanda kanthu yomwe imawononga mawonekedwe a tebulo. Mmene tingachitire zimenezi tidzakambirana m’nkhani ino.

Momwe mungachotsere mizere yobisika mu Excel

Pali njira zingapo zochitira ntchitoyi, zomwe zimagwiritsidwa ntchito pogwiritsa ntchito zida zokhazikika. Ambiri mwa iwo adzakambidwa pansipa.

Njira 1. Momwe mungachotsere mizere patebulo imodzi ndi imodzi kudzera pazosankha

Kuti muthane ndi ntchitoyi, tikulimbikitsidwa kugwiritsa ntchito algorithm iyi:

1. Sankhani mzere womwe mukufuna wa gulu la LMB tabular.
2. Dinani paliponse pagawo losankhidwa ndi batani lakumanja la mbewa.
3. Mu menyu yachidule, dinani "Chotsani ...".

4. Pazenera lomwe limatsegulidwa, ikani chosinthira pafupi ndi gawo la "String" ndikudina "Chabwino".

5. Onani zotsatira. Mzere wosankhidwa uyenera kuchotsedwa.
6. Chitaninso chimodzimodzi ndi zigawo zonse za mbale.

Tcherani khutu! Njira yoganiziridwayo imathanso kuchotsa mizati yobisika.

Njira 2. Single Uninstallation mizere kudzera njira mu riboni pulogalamu

Excel ili ndi zida zodziwika bwino zochotsera ma cell amitundu yosiyanasiyana. Kuti mugwiritse ntchito kuchotsa mizere, muyenera kuchita motere:

1. Sankhani selo lililonse pamzere womwe mukufuna kuchotsa.
2. Pitani ku tabu ya "Home" pagawo lapamwamba la Excel.
3. Pezani batani la "Chotsani" ndikukulitsa njirayi podina muvi womwe uli kumanja.
4. Sankhani "Chotsani mizere pa pepala" njira.

5. Onetsetsani kuti mzere wosankhidwa kale wachotsedwa.

Njira 3. Momwe mungachotsere mizere yonse yobisika nthawi imodzi

Excel imagwiritsanso ntchito mwayi wochotsa gulu pazinthu zomwe zasankhidwa pagulu lamagulu. Izi zimakupatsani mwayi wochotsa mizere yopanda kanthu yomwe imamwazika mbali zosiyanasiyana za mbale. Mwambiri, njira yochotsera imagawidwa m'magawo awa:

1. Momwemonso, sinthani ku tabu ya "Home".
2. Pagawo lomwe limatsegulidwa, pagawo la "Sinthani", dinani batani la "Pezani ndikusankha".
3. Pambuyo pochita zomwe zachitika kale, menyu yankhani idzawonekera pomwe wogwiritsa ntchito adzafunika dinani pamzere "Sankhani gulu la ma cell ...".

4. Pazenera lomwe likuwoneka, muyenera kusankha zinthu zomwe mukufuna kuziwonetsa. Izi zikachitika, ikani chosinthira pafupi ndi gawo la "Empty cell" ndikudina "Chabwino". Tsopano mizere yonse yopanda kanthu iyenera kusankhidwa nthawi imodzi mu tebulo la magwero, mosasamala kanthu za malo awo.

5. Dinani kumanja pamzere uliwonse womwe wasankhidwa.
6. Pazenera lamtunduwu, dinani "Chotsani ..." ndikusankha "String". Mukadina "Chabwino" zinthu zonse zobisika zimachotsedwa.

Zofunika! Njira yochotsera gulu yomwe takambirana pamwambapa ingagwiritsidwe ntchito pamizere yopanda kanthu. Zisayenera kukhala ndi chidziwitso chilichonse, apo ayi kugwiritsa ntchito njirayo kungayambitse kuphwanya kapangidwe ka tebulo.

Njira 4: Ikani masanjidwe

Njira yeniyeni, yomwe imachitidwa motsatira ndondomeko yotsatirayi:

1. Sankhani mutu wa tebulo. Awa ndi malo omwe deta idzasankhidwe.
2. Mu tabu ya "Kunyumba", onjezerani kagawo ka "Sort and Selter".
3. Pazenera lomwe likuwoneka, sankhani kusankha "Kusankha Mwamakonda" podina ndi LMB.

4. Muzosankha zosanja, chongani bokosi pafupi ndi "Deta yanga ili ndi mitu".
5. Mugawo la Order, tchulani zosankha zilizonse: kaya "A mpaka Z" kapena "Z mpaka A".
6. Mukamaliza kusanja, dinani "Chabwino" pansi pa zenera. Pambuyo pake, deta yomwe ili patebulo idzasankhidwa motsatira ndondomeko yomwe yatchulidwa.

7. Malingana ndi ndondomeko yomwe takambirana m'gawo lapitalo la nkhaniyi, sankhani mizere yonse yobisika ndikuyichotsa.

Kusankha zinthu kumangoyika mizere yopanda kanthu kumapeto kwa tebulo.

Zina Zowonjezera! Pambuyo posankha zomwe zili mugululi, zinthu zobisika zimatha kuchotsedwa posankha zonse ndikudina chinthucho "Chotsani" pazosankha.

Njira 5. Kugwiritsa ntchito kusefa

Mu Excel spreadsheets, ndizotheka kusefa gulu lomwe laperekedwa, ndikusiya zofunikira zokha momwemo. Mwanjira iyi mutha kuchotsa mzere uliwonse patebulo. Ndikofunikira kuchita motsatira algorithm:

1. Gwiritsani ntchito batani lakumanzere kuti musankhe mutu wa tebulo.
2. Pitani ku gawo la "Data" lomwe lili pamwamba pa menyu yayikulu ya pulogalamuyi.
3. Dinani pa batani "Sefa". Pambuyo pake, mivi idzawonekera pamutu wa gawo lililonse la gululo.

4. Dinani LMB pa muvi uliwonse kuti mukulitse mndandanda wazosefera zomwe zilipo.
5. Chotsani zolembera pamizere yofunikira. Kuti muchotse mzere wopanda kanthu, muyenera kufotokoza nambala yake ya serial mu gulu la tebulo.

6. Onani zotsatira. Mukadina "Chabwino", zosintha ziyenera kuchitika, ndipo zinthu zomwe zasankhidwa ziyenera kuchotsedwa.

Tcherani khutu! Zomwe zili mumagulu ophatikizidwa amatha kusefedwa mwachangu ndi njira zosiyanasiyana. Mwachitsanzo, potengera mtundu wa selo, potengera deti, mayina a magawo, ndi zina zotero. Zambirizi zafotokozedwa m'bokosi losankhira fyuluta.

Kutsiliza

Chifukwa chake, mu Microsoft Office Excel, kuchotsa mizere yobisika patebulo ndikosavuta. Simufunikanso kukhala wosuta wapamwamba wa Excel kuti muchite izi. Ndikokwanira kugwiritsa ntchito imodzi mwa njira zomwe zili pamwambazi, zomwe zimagwira ntchito mosasamala kanthu za pulogalamu ya mapulogalamu.