Momwe mungawonjezere ma cell mu Excel. Njira za 3 Zowonjezera Maselo ku Excel Spreadsheet

Ndizosakayikitsa kunena kuti ogwiritsa ntchito onse amadziwa kuyika cell yatsopano patebulo la Excel, koma si aliyense amene akudziwa zosankha zonse zoyenera kuchita ntchitoyi. Pazonse, njira 3 zosiyana zimadziwika, pogwiritsa ntchito zomwe zingatheke kuyika selo. Nthawi zambiri liwiro la kuthetsa mavuto limadalira njira yomwe imagwiritsidwa ntchito. Tiyeni tikambirane mwatsatanetsatane mothandizidwa ndi njira zomwe zingatheke kuwonjezera ma cell patebulo la Excel.

Kuwonjezera ma cell patebulo

Ogwiritsa ntchito ambiri amakhulupirira kuti powonjezera ma cell, chiwerengero chawo chonse chimawonjezeka pamene chinthu chatsopano chikuwonekera. Komabe, izi sizowona, chifukwa chiwerengero chawo chonse chidzakhala chofanana. M'malo mwake, uku ndiko kusamutsa chinthu kuchokera kumapeto kwa tebulo kupita kumalo ofunikira ndikuchotsa deta ya cell yosuntha. Poona zimenezi, munthu ayenera kusamala akamasamuka, chifukwa n’zotheka kutaya zina mwa zinthuzo.

Njira 1: Kugwiritsa Ntchito Ma cell Context Menu

Njira yomwe imaganiziridwa imagwiritsidwa ntchito nthawi zambiri kuposa ina, chifukwa imatengedwa kuti ndi yosavuta kugwiritsa ntchito. Kuti muwonjezere ma cell mwanjira yofananira, muyenera kutsatira ma algorithm awa:

1. Timayika cholozera cha mbewa mu gawo linalake la chikalata chomwe mukufuna kuwonjezera chinthu. Pambuyo pake, timayitana mndandanda wazinthu zomwe zasankhidwa ndikukanikiza RMB ndikusankha "Ikani ..." pamndandanda wazomwe zimatuluka.

1. Iwindo lokhala ndi zosankha lidzawonekera pa polojekiti. Tsopano muyenera kuyang'ana bokosi pafupi ndi mawu akuti "Maselo". Pali njira ziwiri zoyikapo - ndikusintha kumanja kapena pansi. Sankhani njira yomwe ikufunika munkhani yanu ndikudina OK.
2. Pambuyo pake, mutha kuwona kuti chinthu chatsopano chidzawonekera m'malo mwa choyambirira, chosinthidwa pamodzi ndi enawo.

Ndizotheka kuwonjezera ma cell angapo mofananamo:

1. Chiwerengero chofunidwa cha maselo chimasankhidwa. Menyu yankhaniyo imatchedwa ndikudina kumanja pamtundu womwe watchulidwa ndikusankha "Ikani ...".

2. Muzosankha zomwe zingatheke, sankhani zomwe mukufuna ndikudina "Chabwino".
3. Maselo atsopano adzawoneka m'malo mwa olembedwa, osinthidwa kumanja pamodzi ndi ena.

Njira 2: Kugwiritsa Ntchito Chida Chapadera mu Menyu Yaikulu

1. Monga momwe zinalili m'mbuyomu, muyenera kuyika cholozera cha mbewa pamalo pomwe cell yowonjezera idzapangidwira. Kenako, mu menyu, muyenera kusankha tabu "Home", kenako muyenera kutsegula gawo la "Maselo", pomwe mumadina "Ikani" zolemba.

2. Selo imawonjezedwa pamalo olembedwa. Koma ndi njira iyi yoyikapo, kusinthaku kumachitika pansi kokha, ndiko kuti, sikungatheke kuyika selo ndi kusuntha kumanja mwa njira yomwe ikufunsidwa.

Poyerekeza ndi njira yoyamba, pali mwayi wowonjezera ma cell angapo:

1. Sankhani ma cell omwe mukufuna mu mzere (mopingasa). Kenako, dinani "Ikani".

2. Pambuyo pake, ma cell owonjezera adzawonjezedwa ndi zinthu zomwe zasankhidwa zitatsitsidwa pansi pamodzi ndi zina zonse.

Kenako, ganizirani zomwe zimachitika ngati simusankha mzere wokhala ndi maselo, koma ndime:

1. Ndikofunikira kusankha ma cell a mzere woyima ndikudina "Ikani" pa tabu yayikulu.
2. Zikatero, ma cell adzawonjezedwa ndikusintha kumanja kwa mtundu wodziwika ndi zinthu zomwe zinali zoyamba kumanja kwake.

Ndikoyeneranso kuyang'ana momwe mungawonjezere ma cell angapo omwe ali ndi zinthu zingapo zoyima komanso zopingasa:

1. Mukasankha mtundu wofunikira, zochita zodziwika bwino zimachitika, ndiye kuti, pagawo la "Home", muyenera kudina "Ikani".
2. Tsopano mutha kuwona kuti zinthu zomwe zawonjezeredwa zimatsitsidwa pansi.

Mukawonjezera ma cell angapo, kuchuluka kwa mizere ndi mizere yomwe ili nayo kumagwira ntchito yofunika kwambiri:

• Gulu likakhala ndi mizere yowongoka kuposa mizere yopingasa, ma cell ena amatsitsidwa mukawonjezedwa.
• Ngati mizere ili ndi mizere yopingasa yochulukirapo kuposa yoyima, ma cell amasamutsidwa kumanja akawonjezedwa.

Mukafuna kufotokozeratu momwe selo imayikidwira, ziyenera kuchitidwa motere:

1. Malo omwe selo (kapena angapo) adzalowetsedwa amawunikira. Ndiye muyenera kusankha "Maselo" gawo ndi kumadula inverted makona atatu mafano pafupi "Matani". Pazosankha za pop-up, dinani "Ikani ma cell ...".
2. Kenako, zenera lokhala ndi zosankha limawonekera. Tsopano muyenera kusankha njira yoyenera ndikudina "Chabwino".

Njira 3: Matani Maselo Pogwiritsa Ntchito Mahotkeys

Ogwiritsa ntchito apamwamba kwambiri amapulogalamu osiyanasiyana amakhathamiritsa njirayi pogwiritsa ntchito makiyi ophatikizira opangira izi. В Excel ilinso ndi njira zazifupi za kiyibodi zomwe zimakulolani kuti mugwire ntchito zambiri kapena kugwiritsa ntchito zida zosiyanasiyana. Mndandandawu ulinso ndi njira yachidule ya kiyibodi yoyika ma cell owonjezera.

1. Choyamba muyenera kupita kumalo omwe mukukonzekera kuyika selo (range). Kenako, dinani mabatani "Ctrl + Shift + =" nthawi yomweyo.

2. Zenera lodziwika bwino limawonekera ndi zosankha. Kenako, muyenera kusankha ankafuna njira. Pambuyo pake, zimangokhala kuti dinani "Chabwino" kuti ma cell ena awonekere.

Kutsiliza

Nkhaniyi idakambirana za mitundu yonse ya njira zoyikamo ma cell ena mu Excel spreadsheet. Iliyonse mwa izi ndi yofanana ndi enawo potengera njira yogwiritsidwira ntchito komanso zotsatira zake, koma ndi njira ziti zomwe zingagwiritsidwe ntchito zomwe ziyenera kusankhidwa malinga ndi momwe zilili. Njira yabwino kwambiri ndi yomwe imaphatikizapo kugwiritsa ntchito njira yachidule ya kiyibodi yomwe ikufuna kuyika, komabe, zenizeni, ogwiritsa ntchito ambiri amagwiritsa ntchito menyu yankhaniyo.