Momwe mungasunthire mizere mu Excel. Manga mizere mu Excel - 3 njira

Nthawi ndi nthawi, pogwira ntchito ndi spreadsheets, zimakhala zofunikira kusintha malo a mizere ingapo yokhudzana ndi wina ndi mzake. Mwachitsanzo, panali nthawi yomwe deta yotchulidwa ndi wogwiritsa ntchito inalowetsedwa mwangozi mu selo yolakwika, ndipo ndondomeko yoyenera ya mizere iyenera kubwezeretsedwa. Palibe chifukwa cholowetsanso chidziwitsochi, mumangofunika kusinthana mizere. Lero tisanthula njira zitatu zochitira izi, ndikufotokozeranso zabwino ndi zoyipa zawo zonse.

Momwe Mungakulire Mizere mu Tabu la Excel

Kodi njira zamatsengazi ndi ziti? Pali njira zitatu zazikulu zosinthira mizere mu chikalata cha Excel:

1. Pogwiritsa ntchito chida chokhazikika cha copy-paste.
2. Kugwiritsa ntchito mbewa kukulunga mizere.

Tigawa njira yoyamba kukhala iwiri, chifukwa aliyense wa iwo ali ndi zake zenizeni.

Njira 1. Kugwiritsa ntchito mbewa

Iyi ndi imodzi mwa njira zodziwika bwino. Ubwino wake waukulu ndi liwiro la izi. Zomwe muyenera kukhala nazo kuti mumangire mizere ndi mbewa ndi kiyibodi. Tiyeni tiwone mwatsatanetsatane zomwe ziyenera kuchitidwa:

1. Sunthani cholozera ku kapamwamba kogwirizanitsa. Pamenepo timadina mbewa yakumanzere pamzere womwe tikuyenera kusuntha.
2. Pambuyo pake, sunthani cholozera kumalire akumtunda kwa maselo aliwonse omwe ali mbali ya mzerewu. Chidziwitso chofunikira: musanagwire ntchito ina, muyenera kuwonetsetsa kuti cholozera chatenga mawonekedwe a muvi wokhala ndi zolozera mbali zinayi.
3. Pambuyo pake, dinani batani la Shift pa kiyibodi ndikuyigwira. Pambuyo pake, timasuntha mzerewu kupita kumalo oyenera. Batani la mbewa liyeneranso kusungidwa panthawiyi. Kiyi ya Shift ndiyofunikira kuti pasakhale m'malo mwa data. Ngati musuntha mzere ndi mbewa yokha, osagwiritsa ntchito kiyibodi, ndiye kuti deta idzasinthidwa, ndipo mudzayenera kubweza chirichonse kuti musataye chidziwitso.

Tikuwona kuti njirayi ndi yosavuta komanso yosavuta. Chinthu chachikulu ndikukumbukira kuti muyenera kusuntha mzere mukugwira batani la Shift.

Njira 2. Kupyolera mu kuyikapo

Poyerekeza ndi njira yotsatirayi, yomwe tidzafotokozera, njirayi ili ndi ubwino wambiri. Zimakuthandizani kuti musinthe makonzedwe a mizere ndi nthawi yochepa komanso khama. Tiyeni tipereke chitsanzo chenicheni cha momwe tingagwiritsire ntchito njirayi.

1. Pezani nambala ya mzere womwe tikufunikira kuti tisunthire pa bar coordinate ndikudina. Pambuyo pake, mzere wonsewo unasankhidwa. Kenako, timayang'ana chipika cha "Clipboard" mu riboni, momwe timayang'ana batani la "Dulani". Chotchinga chokhacho chili pomwepo kumanzere kwa tepiyo. Kuphatikiza apo, njira yabwino ndiyo kugwiritsa ntchito menyu. Kuti muchite izi, dinani kumanja pamzere wofananira ndikupeza chinthu cha "Dulani". Mukhozanso kugwiritsa ntchito njira yachidule ya kiyibodi Ctrl + X.
2. Kenako, muyenera dinani kumanja pamzere womwe uli pansi pa malo omwe mukufuna kuyikapo mzere wodulidwa. Pambuyo pake, mumenyu yomwe ikuwoneka, sankhani chinthu "Ikani maselo odulidwa".
3. Mukamaliza masitepe awa, mzerewo udzasunthira pamalo oyenera. Pa nthawi yomweyi, palibe kusintha kwa mndandanda wa mizere ina yomwe imawonedwa.

Njirayi imathandizira kukulunga mizere munjira zitatu zokha. PKomabe, njirayi ndi yocheperapo kuposa yapitayi, chifukwa ndikofunikira kuyambitsa menyu yankhaniyo, fufuzani zida zofananira mmenemo, komanso pa riboni. Koma poyerekeza ndi njira yotsatirayi, iyi ndiyofulumira kwambiri. Tiyeni tipitirire ku njira yomwe imatenga nthawi yambiri, koma iyenera kudziwikabe kwa katswiri wogwiritsa ntchito Excel.

Njira 3. Pokopera

Njirayi ndi yofanana ndi yapitayi, koma imafuna wosuta kuchita zina zowonjezera. Njirayi ikutanthauza kufunikira kopanga mzere wowonjezera popanda chidziwitso chilichonse, kenako kukopera deta kuchokera pamzere woyambirira kulowamo, ndikuchotsa zobwereza. Tiyeni tiwone momwe izi zimachitikira.

1. Ndikofunikira kusankha selo pamzere pansi pomwe tikufuna kuyika deta. Dinani kumanja ndipo menyu yankhani imawonekera. Mmenemo, sankhani chinthu cha "Insert".
2. Pambuyo pake, zenera laling'ono lidzatulukira pomwe muyenera kusankha chinthu "mzere". Timatsimikizira zochita zathu.
3. Pambuyo pake, mzere wowonjezera udzawonekera, womwe tsopano tifunika kusankha mzere womwe tikuyenera kusamutsira ku chatsopanocho.
4. Dinani kumanja pa izo ndi kukopera. Mutha kugwiritsanso ntchito chida chofananira pa riboni kapena dinani makiyi a Ctrl + C. Wogwiritsa ntchito amatha kusankha njira yomwe ili yabwino kwambiri kwa iye.
5. Pambuyo pake, dinani pa selo yoyamba pamzere wongopangidwa kumene ndikudina "Ikani" kapena mutha kugwiritsanso ntchito kiyi Ctrl + V.
6. Chotsatira ndikuchotsa zobwereza. Kuti muchite izi, dinani kumanja kwa selo kuchokera pamzere woyambirira ndikusankha chinthucho "Chotsani" pamndandanda wazinthu zomwe zikuwonekera. Momwemonso, zenera lidzawoneka momwe tiyenera kusankha chinthu cha "mzere" ndikutsimikizira zochita zathu.

Zotsatira zake, mzere wathu wasunthidwa kuchokera kumalo amodzi kupita ku ena. Monga mukuonera, chinthu ichi chimafuna zambiri zowonjezera. Siloyenera kusuntha mizere yambiri. Zolakwa zimathekanso, chifukwa pochita ndizosavuta kuyiwala kuchotsa mzere wakale.

Pamene mungafunike kukulunga mizere mu Excel

Pali zochitika zambiri zomwe mungafunikire kukulunga mizere mu Excel. Mwachitsanzo, dongosolo limene katundu amaikidwa limagwira ntchito. Kapena wosuta akufuna kuika patsogolo zina. Mwachitsanzo, anthu ambiri amalemba ndondomeko zawo za tsiku ndi tsiku ku Excel ndikukonza zinthu motere, kutumiza zoyamba pamwamba, ndi zomwe zingathe kuyembekezera pansi. Ziribe kanthu chimene chifukwa chofuna kuphunzira mzere kuzimata ndi kwa inu, inu tsopano mukudziwa kale momwe izo. Maphunziro pang'ono, ndipo mutha kugwiritsa ntchito chidziwitso chanu. Zabwino zonse.