Gwirizanitsani maselo ofanana mu Microsoft Excel

Nthawi zambiri, mukamagwira ntchito ndi matebulo a Excel, muyenera kusintha maselo. Likukhalira kuti pa pepalali pali zinthu zazosiyanasiyana. Inde, sikuti izi nthawi zonse zimakhala zolungamitsidwa ndi zolinga zofunikira komanso nthawi zambiri sizikhutiritsa wogwiritsa ntchito. Chifukwa chake, funso limabuka momwe amapangira maselo ofanana kukula. Tiyeni tiwone momwe angagwirizanirane ndi Excel.

Kukula kwakukulu

Kuti mugwirizanitse kukula kwa maselo papepala, muyenera kuchita njira ziwiri: kusintha kukula kwa mizati ndi mizere.

Kutalika kwa mzere kumatha kukhala kwa magawo 0 mpaka 255 (mfundo za 8.43 zimayikidwa mwachisawawa), kutalika kwa mzere kumatha kukhala kuchokera ku 0 mpaka 409 mfundo (mayunitsi 12.75 mwa kusakhalitsa). Mtengo umodzi wa kutalika ndi pafupifupi 0.035 sentimita.

Ngati mukufuna, magawo a kutalika ndi kutalika akhoza kusintha ndi zosankha zina.

1. Kukhala mu tabu Fayilodinani pachinthucho "Zosankha".



2. Pa zenera lotsegula la Excel Options, pitani "Zotsogola". Pakati penipeni pazenera timapeza chipinda chotsekera Screen. Fukula mndandanda pafupi ndi paramayo "Mgwirizano pamzere" ndikusankha imodzi mwazotheka kusankha:
   • Masentimita
   • Ma inchesi
   • Mamilimita
   • Mauniti (akhazikitsidwa ndi kusakhazikika).

   Mukasankha mtengo wake, dinani batani "Zabwino".

Chifukwa chake, ndizotheka kukhazikitsa muyeso womwe wogwiritsa ntchito amayang'ana. Ndilo gawo ili lomwe liziwongoleredwa mtsogolomo posonyeza kutalika kwa mizere ndi m'lifupi mwake pazipilalazo.

Njira 1: sinthanitsani maselo mumtundu wosankhidwa

Choyamba, tiona momwe angagwirizanitsire maselo mumtundu wina, mwachitsanzo, tebulo.

1. Sankhani mtundu womwe uli papepala momwe timapangira kukula kwa maselo ofanana.



2. Kukhala mu tabu "Pofikira"dinani pa riboni pa icon "Fomu"yomwe ili mgululi "Maselo". Mndandanda wamndandanda umatsegulidwa. Mu block "Kukula kwa khungu" sankhani "Kutalika kwa mzere ...".



3. Windo laling'ono limatseguka Kutalika kwa mzere. Timalowa mgawo lokhalo lomwe lili nalo, kukula kwake m'magawo, kufunikira kuti likhazikike pamizere yonse yamtundu wosankhidwa. Kenako dinani batani "Zabwino".



4. Monga mukuwonera, kukula kwa maselo osiyanasiyana osankhidwa mwapamwamba kwakhala kofanana. Tsopano tifunikira kuudula mulifupi. Kuti tichite izi, popanda kuchotsa kusankha, timayitananso menyu kudzera pa batani "Fomu" pa tepi. Ino pano mu buluji "Kukula kwa khungu" sankhani "M'lifupi mwake".



5. Zenera limayamba chimodzimodzi monga momwe lidalili popereka kutalika kwa mzere. Lowetsani m'lifupi mugawo lanu m'magawo, omwe adzagwiritsidwe ntchito pamitundu yosankhidwa. Dinani batani "Zabwino".

Monga mukuwonera, mutatha kugwiritsa ntchito ma cell, ma cell amalo omwe adasankhidwa adakhala ofanana kwathunthu kukula.

Pali njira ina yanjira iyi. Mutha kusankha pagawo lolinganiza lolumikizana lomwe mzere womwe mulifupi mufuna kupanga womwewo. Kenako timadina patsambali ndi batani loyenera la mbewa. Pazosankha zomwe zimatsegulira, sankhani "M'lifupi mwake". Zitatha izi, zenera limatseguka kuti mulowe m'lifupi mwazidutswa zomwe tinasankha, zomwe timakambirana zazitali.

Momwemonso, sankhani mizere ya mtundu womwe tikufuna kulumikizana pamtondo wokhazikika pazogwirizanitsa. Timadina bwino pagawo, mumenyu omwe amatsegula, sankhani chinthucho "Kutalika kwa mzere ...". Pambuyo pake, zenera limatseguka momwe gawo lalitali liyenera kulowamo.

Njira 2: gwirizanitsani maselo mu pepala lonse

Koma pali nthawi zina pamene muyenera kusanjanitsa maselo osati mtundu womwe mukufuna, koma pepala lonse lonse. Kusankha onsewa pamanja ndi ntchito yayitali kwambiri, koma ndizotheka kusankha iwo ndikungodina kamodzi.

1. Dinani pa rectangle yomwe ili pakati pa mapanelo komanso opingasa. Monga mukuwonera, zitatha izi pepala lonse lomwe lasankhidwa kwathunthu. Pali njira ina yosankhira pepala lonse. Kuti muchite izi, lembani njira yaying'ono pa kiyibodi Ctrl + A.



2. Pambuyo poti dera lonse la pepalali lasankhidwa, timasintha m'lifupi mwake pazitali ndi kutalika kwa mizereyo kuti ikhale yayikulu malinga ndi algorithm yomweyi yomwe inafotokozedwa mukamaphunzira njira yoyamba.

Njira 3: kokerani pamalire

Kuphatikiza apo, mutha kugwirizanitsa kukula kwa maselo pokoka pamanja malire.

1. Timasankha pepala lonse kapena maselo osiyanasiyana pamakona olinganiza mwanjira zomwe tafotokozazi. Khazikitsani cholowera pamalire a zipilala m'ndondomeko yolinganiza yolumikizana. Nthawi yomweyo, m'malo mwa chikumbukiro, pamayenera kuwonekera mtanda, pomwe pali mivi iwiri yolowera mbali zosiyanasiyana. Gwirani pansi batani lakumanzere ndikusunthira malire kudzanja lamanzere kapena lamanzere, kutengera ngati tikufunika kukulitsa kapena kufupikitsa. Izi zimasintha kukula osati kwa khungu limodzi ndi malire omwe mukugwiritsa ntchito, komanso maselo ena onse amtundu wosankhidwa.

   

   Mukamaliza kukoka ndi kumasula batani la mbewa, maselo omwe ali osankhidwa m'lifupi adzakhala ndi miyeso imodzimodzi, kuphatikiza kwathunthu m'lifupi la omwe adaphatikizidwawo.



2. Ngati simunasankhe pepala lonse, ndiye kuti sankhani maselo pagawo lofananira. Momwemonso monga m'ndime yapita, kokerani malire amodzi mwa mizere yomwe ili ndi batani la mbewa lomwe limakhala pansi mpaka maselo omwe ali mzerewu afikira kutalika komwe amakukwanitsani. Ndiye kumasula batani la mbewa.

   

   Pambuyo pa izi, zinthu zonse za magulu osankhidwa zidzakhala ndi kutalika kofanana ndi khungu lomwe mudalakwitsa.

Njira 4: ikani tebulo

Ngati muyika tebulo lomwe mwakoloza pa pepala mwachizolowezi, ndiye kuti nthawi zambiri mzati wa mtundu wakalewo umakhala ndi zazikulu zazikulu. Koma pali njira yomwe ingapewe izi.

1. Sankhani tebulo lomwe mukufuna kukopera. Dinani pachizindikiro Copy, yomwe imayikidwa pachifuwa "Pofikira" mu bokosi la zida Clipboard. Mutha kuthanso m'malo mwa izi, mutatha kuwunikira, lembani njira yaying'ono pazenera Ctrl + C.



2. Sankhani khungu pa pepala limodzi, pepala lina kapena buku lina. Selo ili lidzakhala gawo lamanzere patebulo. Dinani kumanja pazinthu zomwe zasankhidwa. Zosintha zamakina zikuwoneka. Mmenemo timapitilira ndime "Ikani mwapadera ...". Pazosankha zowonjezera zomwe zikuwoneka pambuyo pake, dinani, kachiwiri, pa chinthucho ndi dzina lomwelo.



3. Windo lolowetsa lapadera limatseguka. Mu makatani Ikani sinthani kusintha ”Zipilala Zam'mbali. Dinani batani "Zabwino".



4. Zitatha izi, maselo ofanana ndi omwe ali patebulo woyambayo adzaikidwa pa pepala latsamba.

Monga mukuwonera, ku Excel pali njira zingapo zofananira kukhazikitsa kukula kwamaselo amodzi, monga mtundu kapena tebulo linalake, ndi pepala lonse. Chofunikira kwambiri pochita njirayi ndikusankha molondola mtundu womwe ukulu wake womwe mukufuna kusintha ndikupanga phindu limodzi. Kuyika kwa kutalika ndi m'lifupi mwake maselo atha kugawidwa m'magawo awiri: kuyika mtengo wake m'magawo omwe akufotokozedwa manambala ndikukokera m'malire. Wogwiritsa ntchitoyo amasankha njira yabwino yochitira, mu ma algorithm omwe amawongoleredwa bwino.