2 Njira Zosaphatikiza Maselo mu Excel Table

Mbali yogawanitsa ma cell ikufunika pakati pa ogwiritsa ntchito omwe nthawi zonse amayenera kugwira ntchito ndi matebulo. Angagwiritse ntchito mitundu yosiyanasiyana ya masanjidwe kuti agwire ma cell ambiri, omwe amaphatikizidwanso kuti apange madera wamba a chidziwitso. Ngati mbale yotereyi imapangidwa ndi wogwiritsa ntchito mwiniwake, ndiye kuti sipadzakhala mavuto ndi kuchotsedwa. Chovuta kwambiri ndi momwe wogwiritsa ntchito amayenera kugwira ntchito ndi tebulo lopangidwa kale.

Koma musathamangire kukwiya, m'nkhani ino tikambirana njira ziwiri zomwe zilipo. Imodzi imayang'ana pakugwiritsa ntchito mosavuta ntchito za pulogalamuyo, ina idapangidwa kuti igwiritse ntchito gulu lomwe lili ndi zida zazikulu.

Mawonekedwe a kupatukana kwa ma cell

Popeza kuti ndondomekoyi ndi yotsutsana ndi njira yolumikizira, kuti achite, ndikwanira kuthetsa mndandanda wa zochita zomwe zinachitidwa pamene zidaphatikizidwa.

Tcherani khutu! Kuthekera kumeneku kulipo kokha kwa selo lomwe lili ndi zinthu zingapo zomwe zidaphatikizidwa kale.

Njira 1: Zosankha pazenera lokonzekera

Ogwiritsa ntchito ambiri anenapo kuti amakonda kugwiritsa ntchito Ma cell a Format kuphatikiza ma cell. Komabe, ndi mndandanda uwu kuti n'zotheka kuwachotsa popanda vuto lililonse, ndi zokwanira kutsatira malangizo awa:

  1. Gawo loyamba ndikusankha selo lomwe lidalumikizidwa. Kenako dinani pomwepa kuti mubweretse menyu yankhaniyo, nthawi yomweyo kupita kugawo la "Format Cells". Njira yofananira yoyitanitsa menyu yowonjezera ndikugwiritsa ntchito njira yachidule ya kiyibodi "Ctrl + 1".
2 Njira Zosaphatikiza Maselo mu Excel Table
Kusankha Cell ndi Kugwiritsa Ntchito Context Menu
  1. Pazenera lomwe likuwoneka, muyenera kupita kugawo la "Malumikizidwe", kulabadira gawo la "Display". Mmenemo mukhoza kuwona chizindikiro chotsutsana ndi chinthu "Phatikizani maselo". Zimangotsala kuchotsa chilembacho ndikuwunika zotsatira.
2 Njira Zosaphatikiza Maselo mu Excel Table
Njira muwindo la ntchito "Format Cells"
  1. Mukamaliza masitepewo, mutha kuwona kuti selo labweza mawonekedwe oyamba, ndipo tsopano yagawika m'maselo angapo. Maselo ophatikizidwa amtundu uliwonse amatha kulumikizidwa motere.
2 Njira Zosaphatikiza Maselo mu Excel Table
Zotsatira za kugawanika maselo

Zofunika! Chinsinsi cha masanjidwe awa ndikuyang'ana zomwe zafotokozedwa mu selo lophatikizidwa. Mwachikhazikitso, deta yonse idzasunthidwa kupita kumtunda wakumanzere, mosasamala kanthu za kuchuluka kwa malemba kapena zina zomwe zatchulidwamo.

Njira 2: Zida za Riboni

Tsopano muyenera kulabadira njira zambiri zachikhalidwe zolekanitsa ma cell. Kuti muchite izi, zidzakhala zokwanira kuyambitsa pulogalamu ya Excel, tsegulani tebulo lofunikira ndikuchita izi:

  1. Gawo loyamba ndikusankha selo lomwe laphatikizidwa. Kenako pitani ku gawo la "Home" pazida zazikulu, pomwe muyenera kugwiritsa ntchito chizindikiro chapadera mu "Alignment", yomwe ndi selo yokhala ndi mivi iwiri.
2 Njira Zosaphatikiza Maselo mu Excel Table
Malo achizindikiro chamtengo wapatali chochotsa ma cell
  1. Chifukwa cha zomwe zachitidwa, zidzatheka kulekanitsa maselo ndikuwona kuti zotsatira zake zimakhala zofanana ndi zomwe zapezedwa mutatha kugwiritsa ntchito njira yoyamba.
2 Njira Zosaphatikiza Maselo mu Excel Table
Zotsatira zakugawanitsa ma cell pogwiritsa ntchito Njira 2

Chenjerani! Poyang'ana koyamba, zingawoneke kuti njirazo ndi zofanana, koma pali kusiyana kwakukulu komwe kuyenera kutsindika. Mwachitsanzo, ngati mwaganiza zogwiritsa ntchito njira yoyamba, ndiye kuti mawu omwe asungidwa mu selo yakumanzere yakumanzere azikhala ndi njira yolunjika komanso yopingasa. Ndipo ngati mugwiritsa ntchito njira yachiwiri, ndiye kuti kuwongolera malemba kudzakhala kongowoneka.

Kutsiliza

Tsopano muli ndi njira zonse zochotsera ma cell. Chonde dziwani kuti njira 2 ndiyofunika kwambiri komanso ikufunika, koma m'mitundu yatsopano ya Excel. Chowonadi ndi chakuti m'mitundu yatsopano ya pulogalamuyi, gawo la "Home" limatsegulidwa mwachisawawa. Ndipo mutha kugwiritsa ntchito chithunzi chofananira nthawi yomweyo osagwiritsa ntchito zina zilizonse.

Siyani Mumakonda