Monga lamulo, kwa ambiri ogwiritsa ntchito, kuwonjezera maselo pamene akugwira ntchito ku Excel sikuimira ntchito yovuta. Koma, mwatsoka, si aliyense amene amadziwa njira zonse zomwe zingathekere. Koma nthawi zina, kugwiritsa ntchito njira inayake kungakuthandizeni kuchepetsa nthawi yomwe mumagwiritsa ntchito. Tiyeni tiwone zomwe mungasankhe pakuwonjezera maselo atsopano ku Excel.
Onaninso: Kodi mungatani kuti muwonjezere mzere watsopano mu tebulo la Excel
Momwe mungayikitsire mzere mu Excel
Njira yowonjezeramo magulu
Nthawi yomweyo, timayang'anitsitsa momwe ndondomeko yowonjezeramo maselo imagwiritsidwa ntchito kuchokera ku luso lamakono. Mwachidziwikire, zomwe timatcha "kuwonjezera" ndi, makamaka, kuyenda. Ndiko kuti, maselo amangosunthira pansi ndi kumanja. Makhalidwe omwe ali kumapeto kwa pepala amachotsedwa pamene maselo atsopano awonjezeredwa. Choncho, m'pofunika kutsata ndondomekoyi pamene pepala ili ndi deta ndiposa 50%. Ngakhale, popeza kuti mu Excel zamakono, pali mizere 1 miliyoni ndi timapepala pa pepala, pakuchita zosowa zimenezi zimabwera kawirikawiri.
Kuphatikiza apo, ngati muwonjezera ndendende maselo, osati mzere ndi mizere yonse, ndiye kuti muyenera kuganizira kuti patebulo pomwe mukuchita ntchitoyi, deta idzasinthidwa, ndipo chikhalidwe sichingafanane ndi mizere kapena mizere yomwe ikufanana kale.
Kotero, ife tsopano tayang'ana njira zenizeni zowonjezera zinthu pa pepala.
Njira 1: Menyu Yokambirana
Njira imodzi yowonjezera maselo mu Excel ndiyo kugwiritsa ntchito mndandanda wa masewera.
- Sankhani chinthu cha pepala chomwe tikufuna kuyika selo yatsopano. Timangosinthanitsa ndi batani lamanja la mouse. Yayambitsa mndandanda wamakono. Sankhani malo mmenemo "Sakani ...".
- Pambuyo pake, kanyumba kakang'ono kotsegula katsegula. Popeza tikufuna kuika maselo, osati mzere kapena mizere yonse, zinthuzo "Mzere" ndi "Column" timanyalanyaza. Sankhani pakati pa mfundo "Maselo, ndi kusintha kosuntha" ndi "Maselo, ndi kusintha", mogwirizana ndi mapulani awo a gulu la gome. Mutatha kusankha, dinani pa batani. "Chabwino".
- Ngati wogwiritsa ntchito asankha "Maselo, ndi kusintha kosuntha", ndiye kusintha kudzatenga mawonekedwe monga momwe tawonera m'munsimu.
Ngati njirayi idasankhidwa ndi "Maselo, ndi kusintha", tebulo idzasintha motere.
Mofananamo, mukhoza kuwonjezera magulu onse a maselo, koma pazimenezi muyenera kusankha nambala yoyenera ya mapepala pa pepala musanapite ku menyu.
Pambuyo pake, zinthuzo zidzawonjezeredwa ndi ndondomeko yomweyo yomwe tafotokozera pamwambapa, koma ndi gulu lonse.
Njira 2: Chotsani pa tepi
Mukhozanso kuwonjezera zinthu pa pepala la Excel kupyolera mu batani pa Riboni. Tiyeni tiwone momwe tingachitire izo.
- Sankhani chinthucho pa malo a pepala kumene tikukonzekera kuwonjezera selo. Pitani ku tabu "Kunyumba"ngati muli pakali pano. Kenaka dinani pa batani. Sakanizani mu chigawo cha zipangizo "Maselo" pa tepi.
- Pambuyo pake, chinthucho chidzawonjezeredwa ku pepala. Ndipo, mulimonsemo, iyo idzawonjezeredwa ndi kuchotsedwa pansi. Kotero njira iyi imakhala yosasinthasintha kusiyana ndi yoyamba.
Pogwiritsa ntchito njira yomweyi, mukhoza kuwonjezera magulu a maselo.
- Sankhani gulu losakanikirana la zinthu zowonjezera ndipo dinani pazithunzi zomwe mumazidziwa Sakanizani mu tab "Kunyumba".
- Pambuyo pake, gulu la mapepala lidzalowetsedwa, monga limodzi lowonjezera, ndi kusintha.
Koma posankha kagulu ka maselo, timapeza zotsatira zosiyana.
- Sankhani gulu lolunjika la zinthu ndipo dinani pa batani. Sakanizani.
- Monga mukuonera, mosiyana ndi zomwe mwasankha kale, pakadali pano gulu la zinthu zinawonjezeredwa ndi kusintha kosanja.
Kodi chidzachitike ndi chiyani ngati tikuwonjezera zinthu zambiri zomwe zimakhala zozungulira komanso zowongoka mofanana?
- Sankhani zinthu zofanana ndikusinthasintha pa batani omwe tawadziŵa kale. Sakanizani.
- Monga mukuonera, zinthu zomwe zili ndi kusintha kosayenera zidzalowetsedwa kumalo osankhidwa.
Ngati mukufuna kufotokoza momveka bwino momwe zinthu ziyenera kusunthira, ndipo, mwachitsanzo, powonjezera gulu mukufuna kuti kusintha kusinthe, muyenera kutsatira malangizo otsatirawa.
- Sankhani chinthu kapena gulu la zinthu mmalo omwe tikufuna kuika. Sitimangodutsa pa batani omwe amawadziwa bwino Sakanizani, ndi katatu, zomwe zikuwonetsedwa kumanja kwake. Mndandanda wa zochitika zimatsegulidwa. Sankhani chinthu mmenemo "Yesani maselo ...".
- Pambuyo pake, mawindo olowawo amadziwika kale ndi njira yoyamba. Sankhani zowonjezera njira. Ngati ife, monga tatchulidwa pamwambapa, tikufuna kuti tithe kuchitapo kanthu ndikusunthira pansi, ndiye ikani kusintha "Maselo, ndi kusintha". Pambuyo pake, dinani pa batani "Chabwino".
- Monga momwe mukuonera, zinthuzo zinawonjezeredwa pa pepala ndi kusintha, ndiko kuti, momwe timakhalira.
Njira 3: Hotkeys
Njira yowonjezera yowonjezerapo zinthu zowonjezera mu Excel ndi kugwiritsa ntchito kuphatikiza kwa hotkey.
- Sankhani zinthu zomwe tikufuna kuziyika. Pambuyo pake, lembani njira yomasulira pa keyboard Ctrl + Shift + =.
- Pambuyo pa izi, tsamba laling'ono la kuika zinthu zomwe tidziwa kale zidzatsegulidwa. Mmenemo, muyenera kuyika zoikidwiratu kumanja kapena pansi ndikusindikiza batani "Chabwino" mofananamo monga momwe tachitira izi kangapo kamodzi njira zammbuyomu.
- Pambuyo pake, zinthu zomwe zili pa pepala zidzaikidwa, malinga ndi zoyambirira zomwe zidapangidwa m'ndime yapitayi ya bukuli.
PHUNZIRO: Ma Keys Otentha ku Excel
Monga momwe mukuonera, pali njira zitatu zowonjezera maselo mu tebulo: pogwiritsa ntchito menyu yachidule, makatani pa riboni ndi mafungu otentha. Mchitidwe wa njira izi ndi chimodzimodzi, kotero posankha, choyamba, mosavuta kwa wogwiritsa ntchito amalingalira. Ngakhale, ndithudi, njira yofulumira kwambiri ndi kugwiritsa ntchito hotkeys. Koma, mwatsoka, si ogwiritsira ntchito onse akuzoloŵera kusakanikirana komwe kulipo kwa Excel kusuta kwawo kukumbukira. Choncho, njira yofulumira imeneyi sikukhala yabwino kwa aliyense.
