Chotsani mizere yobisika. Imodzi ndi zonse nthawi imodzi

Mu Microsoft OflyCL Excel, mutha kuchotsa msanga chobisika, chopanda kanthu chopatulikacho. Momwe mungachitire izi zidzauzidwa m'nkhaniyi.

Momwe mungachotsere mizere yobisika

Pali njira zingapo zochitira ntchitoyo pogwiritsa ntchito zida zamalamulo. Kenako, zodziwika kwambiri za izo zidzatengedwa.

Njira 1. Momwe mungachotse mizere mu tebulo lomwe lili pa menyu

Kuthana ndi opaleshoni iyi, tikulimbikitsidwa kugwiritsa ntchito algorithm zotsatirazi:

1. Sankhani mzere womwe mukufuna pa tebulo la mabulosi.
2. Dinani pa malo aliwonse omwe adagawidwa.
3. Mu menyu wamba, dinani pamawu "chotsani ...".

Njira yopita pazenera la Deleation of Microsoft Office Excel

1. Pazenera lomwe limatsegula, yikani kusinthasintha kwa chidani pafupi ndi "chingwe" pagawo ndikudina chabwino.

Sankhani njira yoyenera kuchotsa mzere patebulo

1. Onani zotsatira zake. Chingwe chosankhidwa sichiyenera kukhala chopanda pake.
2. Chitani izi ndi zinthu zina za mbale.

Njira 2. Zingwe Zosasinthika Zosasintha kudzera mu tepi ya pulogalamuyi

Excel ali ndi zida wamba zochotsa ma cell a tebulo. Kuti mugwiritse ntchito kuti muchotse mizere, muyenera kuchita izi:

1. Sankhani khungu lililonse mu chingwe chomwe mukufuna kuchotsa.
2. Pitani ku "kunyumba" pagawo lapamwamba kwambiri.
3. Pezani batani lochotsa ndikutumiza njirayi podina ndi mkulu kumanja.
4. Sankhani Njira "Chotsani mizere kuchokera pa pepala".

Algorithm ya kuchotsedwa kwa mzere wosankhidwa kuchokera ku pepala logwira kudzera mu chida cha pulogalamuyi

1. Onetsetsani kuti kusokonekera komwe kusankhidwa kale sikunasatuluke.

Njira 3. Momwe mungachotsere mizere yonse yobisika nthawi yomweyo

Kutumizidwanso kumapangitsa kuti gulu lithe kuchotsa zinthu zomwe zasankhidwa za masitepe a tebulo. Njira iyi imakupatsani mwayi kuti muchotse mizere yopanda tanthauzo yobalalika m'malo osiyanasiyana. Mwambiri, njira yopanda yotsukira imagawidwa m'njira zotsatirazi:

1. Ndi chiwembu chofananira, sinthani ku tabu yakunyumba.
2. M'dera lomwe limatsegulidwa, kusintha "gawo la" Dinani "Pezani ndi kugawa".
3. Pambuyo pokonza zomwe zidachitika kale, menyu woterewa adzaonekera, momwe wosuta adzafunika dinani pamzere "Sankhani gulu la maselo ...".

Kugawidwa m'mizere yopanda kanthu m'malo mwa "kupeza ndi kugawa" njira mu Excel

1. Pawindo lowonetsedwa, muyenera kusankha zinthu kuti muwonetsetse. Pankhaniyi, muyenera kuyika kusinthasintha pafupi ndi gawo la "chopanda kanthu" ndikudina pa "Ok". Tsopano m'lingalo lazomwe zimayenera kunyalanyaza mizere yonse yopanda kanthu mosasamala malo awo.

Kusankhidwa kwa mizere yopanda kanthu pazenera losankhidwa la magulu

1. Manipator Wipen-Kecert Dinani pa chilichonse mwa mizere yosankhidwa.
2. Pa zenera la zenera, dinani pamawu "Chotsani ..." ndikusankha njira ya "chingwe". Pambuyo podina pa "Chabwino", zinthu zonse zobisika sizikuwoneka.

Gulu Lopanda Chinsinsi Chobisika

Mbale yokhala ndi mawonekedwe osweka mu njira yopambana 4 4. Kugwiritsa ntchito kukonza

Njira yeniyeni yomwe imachitidwa molingana ndi algorithm otsatirawa:

1. Sankhani chipewa chagome. Dera ili lomwe lidzasanjidwa.
2. Mu tabu yakunyumba, ikani mtundu ndi chowonjezera.
3. Pazenera lomwe limawonekera, sankhani njira yosinthira "yosinthira" podina ndi LKM.

Njira yopita ku zenera la mtundu

1. Muzakudya zosinthasintha, ikani chizindikiro cha cheke pamaso pa "data yanga" ndi mutu.
2. M'ndinzani, fotokozerani chilichonse chomwe mungasankhe: Kaya kuchokera ku Z "kapena" kwa ine kupita kwa ".
3. Kumapeto kwa kukhazikitsa, dinani "Chabwino" pansi pazenera. Pambuyo pake, zomwe zili mu tebulo la tebulo lidzasanjidwa ndi chitsimikizo chotchulidwa.

Zofunikira pazakudya zosinthasintha

1. Malinga ndi chiwembu chomwe takambirana m'gawo lakale la nkhaniyo, amagawa zingwe zonse zobisika ndikuzichotsa.

Kusintha Makhalidwe kumawalitsa mizere yopanda kanthu mpaka kumapeto kwa mbale.

Kusautsa mizere yopanda kanthu, yomwe imangoyikidwa kumapeto kwa tebulo pambuyo pa njira yosinthira 5. Ikani zosefera

Pamatebulo apamwamba, ndizotheka kusefa mndandandawo, ndikusiya chidziwitso chofunikira. Mwanjira imeneyi mutha kuchotsa chingwe chilichonse pagome. Ndikofunikira kuchita molingana ndi algorithm:

1. Chinsinsi cha Maniputor chikuwonetsa mutu.
2. Pitani ku gawo la "deta", lomwe lili pamwamba pa mndandanda waukulu wa pulogalamuyo.
3. Dinani batani la "Fyuluta". Pambuyo pake, mivi idzaonekera m'mutu wa mzere uliwonse wa mndandanda.

Kuyika fyuluta pa tebulo lodziwika bwino

1. Kanikizani LKM pa muvi uliwonse kuti mupereke mndandanda wazosefesera.
2. Chotsani macheke ochokera mu mizere yomwe mukufuna. Kuti muchotse chingwe chopanda kanthu, muyenera kutchula nambala yake yotsatizana pa tebulo.

Kuchotsa mizere yosafunikira mwa njira yosinthira

1. Onani zotsatira zake. Pambuyo podina pa "Chabwino", kusinthaku kuyenera kuchitidwa kukakamiza, ndipo zinthu zosankhidwa zidzachotsedwa.

Mapeto

Chifukwa chake, mu Microsoft Office Excel Chosatulutsa mizere yobisika patebulopo ndi yosavuta mokwanira. Izi sizoyenera kukhala wogwiritsa ntchito bwino kwambiri. Ndikukwanira kugwiritsa ntchito imodzi mwazomwe zili pamwambapa zomwe zimagwira ntchito palokha za pulogalamuyi.

Mauthenga ochotsa zingwe zobisika. Nthawi yonseyi ndipo nthawi yomweyo adawoneka woyamba paukadaulo wazidziwitso.