Kuti muchite zinthu zosiyanasiyana ndi zomwe zili m'maselo a Excel, muyenera kusankha kaye. Pazifukwa izi, pulogalamuyi ili ndi zida zingapo. Choyamba, kusiyanaku kumachitika chifukwa choti pakufunika kuwunikira magulu osiyanasiyana a ma cell (mzere, mizere, mizati), komanso kufunika kolemba zinthu zomwe zimagwirizana ndi chinthu china. Tiyeni tiwone momwe tingachitire njirayi m'njira zosiyanasiyana.
Njira yosankhira
Mukasankha, mutha kugwiritsa ntchito mbewa ndi kiyibodi. Palinso njira zina zomwe zida izi zimathandizira ndikuphatikizira.
Njira 1: Selo Limodzi
Kuti musankhe khungu limodzi, ingolumikizani ndikudina-kumanzere. Komanso, kusankha koteroko kutha kuchitika pogwiritsa ntchito mabatani omwe ali pabatani batani loyenda "Pansi", Pamwamba, Kulondola, Kumanzere.
Njira 2: sankhani mzati
Kuti mulembe chizindikiro pagome, gwiritsani batani lakumanzere ndikudula kuchokera kumtunda wapamwamba kwambiri mpaka pansi, pomwe batani limayenera kumasulidwa.
Pali njira inanso yothanirana ndi vutoli. Gwira batani Shift pa kiyibodi ndikudina patsamba lapamwamba la chipilalacho. Kenako, osamasula batani, dinani pansi. Mutha kuchita zinthu munjira yotsatira.
Kuphatikiza apo, ma algorithm otsatirawa amatha kugwiritsidwa ntchito kuwunikira mzati mumatafura. Sankhani khungu loyambirira la mzati, kumasula mbewa ndikusindikiza kuphatikiza kiyi Ctrl + Shift + Down Arrow. Pankhaniyi, mzere wonse umasankhidwa kukhala gawo lomaliza momwe idatha. Chofunikira pakuchita izi ndi kusapezeka kwa maselo opanda kanthu m'ndime iyi ya tebulo. Kupanda kutero, malo okhaokha asanachitike chizindikiro
Ngati mukufuna kusankha gawo limodzi lokhala ndi tebulo, koma gawo lonse la pepalalo, ndiye kuti mukuyenera kungodinanso kumanzere komwe kumalumikizana ndi gulu lozungulira, pomwe zilembo za zilembo zimafotokoza mayina a zipilala.
Ngati kuli kofunikira kusankha mizati ingapo ya pepala, ndiye kuti kokerani mbewa ndi batani lakumanzere lomwe limakanikizidwa pamagawo ofananira a gulu logwirizanitsa.
Pali yankho linanso. Gwira batani Shift ndipo ikani mzere woyamba m'ndondomeko yowunikiridwa. Kenako, popanda kumasula batani, dinani gawo lomaliza la gulu logwirizanitsa motsatira mzati.
Ngati mukufuna kusankha mizati yomwazikana ndi pepalalo, ndiye kuti musani batani Ctrl ,, osachimasula, timadula gawo lomwe lili mgawo lililonse lolumikizidwa kuti lisungidwe.
Njira 3: sonyezani mzere
Momwemonso, mizere ku Excel imagawidwa.
Kuti musankhe mzere umodzi patebulopo, ingolowetsani chowatembezera ndi batani la mbewa lomwe lakhala pansi.
Ngati tebulo ndilokulirapo, ndikosavuta kugwirizira batani Shift ndikudina ndendende gawo loyamba ndi lomaliza la mzere.
Komanso mizere muma tebulo imatha kuzindikirika chimodzimodzi ndi mizati. Dinani pazinthu zoyambirira mu mzere, kenako lembani njira yaying'ono Ctrl + Shift + Arrow Right. Mzerewu ukuvekedwa mpaka kumapeto kwa tebulo. Koma kachiwiri, chofunikira pamilandu iyi ndikupezeka kwa maselo onse am'mizere.
Kuti musankhe mzere wonse wa pepalalo, dinani pagawo lolingana la gulu lolumikizana, komwe manambala amawonetsedwa.
Ngati kuli kofunikira kusankha mizere yoyandikana motere, ndiye kokerani batani lakumanzere pagulu lolingana la magawo ogwirizanitsa ndi mbewa.
Mutha kugwiritsanso batani Shift ndikudina gawo loyamba ndi lomaliza mumgwirizano wogwirizanitsa wa mizere yomwe ikuyenera kusankhidwa.
Ngati mukufuna kusankha mizere yopatukana, dinani gawo lililonse pazenera zokhazikika kuti batani likanikizidwe Ctrl.
Njira 4: sankhani pepala lonse
Pali zinthu ziwiri zomwe mungachite pa pepala lonse. Yoyamba ndikudina batani la makona anayi lomwe lili pamphepete mwa magwirizano opingasa. Pambuyo pa izi, mwamtheradi maselo onse papepala adzasankhidwa.
Kukanikiza kopanira kumabweretsa zotsatira zomwezo. Ctrl + A. Komabe, ngati pakadali pano chidziwitso chili m'ndandanda wazosawerengeka, mwachitsanzo, patebulo, ndiye dera lokhalo lomwe lingasankhidwe koyambirira. Pambuyo pokhapokha kukanikiza kuphatikiza kachiwiri ndizotheka kusankha pepala lonse.
Njira 5: Kukula Kwambiri
Tsopano tiyeni tiwone momwe mungasankhire maselo amtundu uliwonse wamaselo papepala. Kuti muchite izi, ndikokwanira kuzungunulira bokosi ndikudina kumanzere pamalo ena papepala.
Mitundu imatha kusankhidwa pogwira batani Shift pa kiyibodi ndipo dinani kumanzere kumtunda kumanzere kumanzere kumanzere akumalo osankhidwa. Kapenanso pochita opaleshoniyo: dinani kumanzere kumanzere kumanzere kwakumanzere kwa gulu la anthu. Mtundu pakati pazinthuzi udziwonetsedwa.
Palinso kuthekera kowunikira maselo osiyana kapena masanjidwe. Kuti muchite izi, mwa njira iliyonse pamwambapa, muyenera kusankha gawo lirilonse lomwe wogwiritsa ntchito akufuna kusankha, koma batani liyenera kuphatikizidwa Ctrl.
Njira 6: ikani ma cookie
Mutha kusankha malo omwe mukugwiritsa ntchito mafungulo otentha:
- Ctrl + Panyumba - kusankha kwa khungu loyamba lokhala ndi deta;
- Ctrl + Mapeto - kusankha kwa foni yomaliza ndi deta;
- Ctrl + Shift + Mapeto - kusankha maselo mpaka ogwiritsira ntchito komaliza;
- Ctrl + Shift + Panyumba - Kusankhidwa kwa maselo mpaka kumayambiriro kwa pepala.
Zosankha izi zimatha kupulumutsa nthawi pakugwira ntchito.
Phunziro: Ogula otentha
Monga mukuwonera, pali mitundu yayikulu yosankha maselo ndi magulu awo osiyanasiyana pogwiritsa ntchito kiyibodi kapena mbewa, komanso kugwiritsa ntchito zinthu ziwiri izi. Wogwiritsa aliyense amatha kusankha mtundu wosankha womwe ungakhale wofunikira kwa iye munthawi inayake, chifukwa ndikosavuta kusankha khungu limodzi kapena zingapo m'njira imodzi, ndikusankha mzere wonse kapena pepala lonse m'njira inanso.
