Kuwonjezera ndime yatsopano mu Excel

Aliyense amene ayamba kugwira ntchito ku Excel, choyamba, ayenera kuphunzira kuwonjezera zigawo zina patebulo losinthidwa. Popanda chidziwitso ichi, zidzakhala zovuta kwambiri kapena zosatheka kupitiriza kugwira ntchito ndi deta ya tabular ndikuwonjezera zatsopano m'buku.

Kuwonjezera gawo latsopano

Excel imapereka njira zingapo zoyikamo ndime yowonjezera pamalo ogwirira ntchito. Zambiri mwa njirazi sizidzabweretsa zovuta, koma woyambitsa amene atsegula pulogalamuyo kwa nthawi yoyamba ayenera kuthera nthawi yochepa kuti adziwe zonse. Choncho, tiyeni tione ndondomeko ya zochita pa njira iliyonse.

Njira 1. Kulowetsa ndime kudzera mu kapamwamba kogwirizanitsa

Njirayi imatengedwa kuti ndiyosavuta kwambiri kuwonjezera mzere watsopano ndi mzere patebulo. Izi ndi zomwe muyenera kuchita pa izi:

1. Pagawo loyang'anira loyang'ana, dinani dzina lagawo lomwe lili kumanzere komwe mukufuna kuwonjezera lina. Ngati atachita bwino, gawo lonse lidzasankhidwa pamodzi ndi mutu wake.
2. Tsopano dinani kumanja pa malo aliwonse omwe mwasankhidwa, menyu yankhani idzatsegulidwa, momwe timasankha lamulo "Ikani".
3. Izi ziwonjezera gawo latsopano lopanda kanthu kumanzere kwa lomwe tasankha pagawo loyamba.

Njira 2: Kuwonjeza Chigawo Pogwiritsa Ntchito Menyu Yankhani Yama cell

Apa mudzafunikanso kugwiritsa ntchito menyu yankhani, koma pakadali pano, osati gawo lonse losankhidwa, koma selo limodzi lokha.

1. Pitani ku selo (dinani pa izo kapena gwiritsani ntchito mivi pa kiyibodi), kumanzere komwe tikukonzekera kuyika ndime yatsopano.
2. Dinani kumanja pa selo ili, ndipo pa menyu yankhani yomwe imatsegulidwa, dinani lamulo “Ikani…”.
3. Iwindo laling'ono lothandizira lidzatsegulidwa, pomwe mudzafunika kusankha zomwe ziyenera kuyikidwa patebulo: maselo, mzere kapena mzere. Malinga ndi ntchito yathu, timayika chizindikiro patsogolo pa chinthucho "Chigawo" ndikutsimikizira zomwe zikuchitika ndikudina batani OK.
4. Chigawo chopanda kanthu chidzawonekera kumanzere kwa selo losankhidwa poyamba, ndipo tikhoza kuyamba kudzaza ndi deta yofunikira.

Njira 3: Matani pogwiritsa ntchito zida zomwe zili pa riboni

Pali batani lapadera pa riboni yayikulu ya Excel yomwe imakupatsani mwayi woyika ndime yowonjezera patebulo.

1. Monga njira yapitayi, sankhani cell yomwe mukufuna. Mzere watsopano mutatsatira njira zomwe zili pansipa zidzawonekera kumanzere kwake.
2. Dinani pa chithunzi ndi chithunzi cha makona atatu otembenuzidwa pafupi ndi batani "Ikani", kukhala mu tabu "Pofikira". Pamndandanda wotsitsa, dinani njirayo "Ikani mizati pa pepala".
3. Zonse zakonzeka. Mzere watsopano wawonjezedwa kumanzere kwa selo losankhidwa, ngati pakufunika.

Njira 4. Makiyi otentha oyika gawo latsopano

Njira ina yomwe ili yotchuka kwambiri, makamaka pakati pa ogwiritsa ntchito odziwa zambiri, ndikukanikiza ma hotkeys. Njirayi ili ndi ntchito ziwiri:

1. Dinani pa dzina la mzati pa gulu logwirizanitsa. Monga nthawi zonse, kumbukirani kuti gawo latsopanolo lidzalowetsedwa kumanzere kwa yosankhidwayo. Kenako, dinani njira yachidule ya kiyibodi Ctrl + "+". Pambuyo pake, ndime yatsopanoyo imawonjezedwa patebulo.
2. Timadina pa selo iliyonse, osaiwala kuti gawo latsopano lidzawonekera kumanzere kwake. Kenako dinani njira yachidule ya kiyibodi Ctrl + "+".Iwindo lodziwika bwino lidzawonekera pomwe muyenera kusankha mtundu woyika (selo, mzere kapena mzere). Monga njira yachiwiri, muyenera kusankha chinthucho "gawo" kenako tsimikizirani zomwe mwachita podina batani OK.

Kuyika mizati iwiri kapena kuposerapo

Ntchito yoyika mizati yambiri patebulo imayenera kusamalidwa mwapadera. Chifukwa cha magwiridwe antchito a Excel, palibe chifukwa chowonjezera mizati imodzi ndi imodzi, chifukwa apa pali njira yothandiza kwambiri:

1. Choyamba, timasankha maselo ambiri mozungulira (zilibe kanthu, patebulo lokha kapena pagawo logwirizanitsa), monga mizati yatsopano ikukonzekera kuikidwa.
2. Kutengera momwe tapangira kusankha, timachita njira zotsalira kuti tiwonjezere mizati, motsogozedwa ndi njira 1-4 zomwe tafotokozazi. Mwachitsanzo, kwa ife, tinasankha pa gulu logwirizanitsa, ndipo tsopano tikuwonjezera zipilala zatsopano kupyolera muzolemba zamkati mwa kusankha chinthu choyenera mmenemo.
3. Chifukwa cha zochita zathu, tinatha kuyika mizati ingapo patebulo kumanzere kwa mndandanda wapachiyambi umene tinasankha.

Ikani mzati kumapeto kwa tebulo

Chilichonse chomwe chafotokozedwa pamwambapa ndi choyenera kuwonjezera mzere watsopano kapena mizati ingapo kumayambiriro kapena pakati pa tebulo lalikulu. Inde, ngati mukufuna kuwonjezera ndime kuchokera kumapeto, mungagwiritse ntchito njira zomwezo ngati mukufuna. Koma ndiye muyenera kuthera nthawi yowonjezereka mukupanga zinthu zowonjezera.

Kuti muyike gawo latsopano ndikupewa kusanjikiza kwina, ndikofunikira kupanga tebulo "lanzeru" kuchokera patebulo lokhazikika. Nazi zomwe timachita pa izi:

1. Sankhani ma cell onse. Momwe mungachitire izi - werengani nkhani yathu "".
2. Sinthani ku tabu "Pofikira" ndi kukanikiza batani "Format as table", yomwe ili mu gawo la "Masitayelo".
3. Pamndandanda womwe ukuwonekera, sankhani kalembedwe koyenera kalembedwe ka "smart table" yamtsogolo ndikudina.
4. Iwindo laling'ono lidzawonekera momwe muyenera kukonzanso malire a malo osankhidwa. Ngati tasankha bwino tebulo mu sitepe yoyamba, palibe chomwe chiyenera kukhudzidwa apa (ngati kuli kofunikira, tikhoza kukonza deta). Onetsetsani kuti pali cholembera pafupi ndi chinthucho “Table yokhala ndi mitu” kanikizani batani OK.
5. Zotsatira zake, tebulo lathu loyambirira lasinthidwa kukhala "wanzeru".
6. Tsopano, kuti muwonjezere ndime yatsopano kumapeto kwa tebulo, ingodzazani selo iliyonse kumanja kwa malo a tebulo ndi deta yofunikira. Mzere wodzazidwa udzangokhala gawo la "smart table" ndipo masanjidwe asungidwa.

Kutsiliza

Microsoft Excel imapereka njira zambiri zomwe mungawonjezere mzere watsopano paliponse patebulo (kuyambira, pakati, kapena kumapeto). Pakati pawo, malo apadera amakhala ndi kupanga "tebulo lanzeru", lomwe limakulolani kuti muyike mizati yatsopano patebulo popanda kufunikira kowonjezeranso kuti muwabweretse ku mawonekedwe wamba, omwe angapulumutse nthawi ntchito zofunika kwambiri.