Momwe mungapangire ma cell kukhala ofanana mu Excel

Nthawi zambiri mukamagwira ntchito ndi ma spreadsheets a Excel, pamafunika kusintha kukula kwa ma cell. Ndikofunikira kuchita izi kuti mugwirizane ndi zonse zofunika pamenepo. Koma chifukwa cha kusintha koteroko, maonekedwe a tebulo amawonongeka kwambiri. Pofuna kuthetsa vutoli, m'pofunika kupanga selo lililonse kukhala lofanana ndi ena onse. Tsopano tiphunzira mwatsatanetsatane zomwe ziyenera kuchitika kuti tikwaniritse cholingachi.

Kukhazikitsa mayunitsi a muyeso

Pali magawo awiri akuluakulu okhudzana ndi ma cell ndikuwonetsa kukula kwawo:

1. M'lifupi mwake. Mwachikhazikitso, zikhalidwe zimatha kuyambira 0 mpaka 255. Mtengo wokhazikika ndi 8,43.
2. Kutalika kwa mzere. Makhalidwe amatha kuyambira 0 mpaka 409. Zosasintha ndi 15.

Mfundo iliyonse ndi yofanana ndi 0,35 mm.

Panthawi imodzimodziyo, ndizotheka kusintha mayunitsi a muyeso momwe m'lifupi ndi kutalika kwa maselo zidzatsimikiziridwa. Kuti muchite izi, tsatirani malangizo:

1. Pezani menyu "Fayilo" ndikutsegula. Padzakhala chinthu "Zikhazikiko". Iye ayenera kusankhidwa.
   

   

2. Kenako, zenera adzaoneka, kumanzere kumene mndandanda waperekedwa. Muyenera kupeza gawo "Zowonjezera" ndikudina pa izo. Kumanja kwa zenera ili, tikuyang'ana gulu la magawo otchedwa "Onetsani". Pankhani yamitundu yakale ya Excel, idzatchedwa "Screen". Pali mwayi "Mayunitsi pa mzere", muyenera dinani pamtengo womwe wakhazikitsidwa kuti mutsegule mndandanda wa miyeso yonse yomwe ilipo. Excel imathandizira zotsatirazi - mainchesi, masentimita, mamilimita.
   

   

3. Mukasankha zomwe mukufuna, dinani "CHABWINO".
   

   

Kotero, ndiye mutha kusankha gawo la muyeso lomwe liri loyenera kwambiri pazochitika zinazake. Magawo ena adzakhazikitsidwa molingana ndi izo.

Kuyanjanitsa Magawo a Maselo - Njira 1

Njira iyi imakupatsani mwayi wogwirizanitsa kukula kwa maselo mumtundu womwe wasankhidwa:

1. Sankhani mtundu wa maselo ofunikira.
   

   

2. Tsegulani tabu "Pofikira"gulu lili kuti "Maselo". Pansi pake pali batani. "Mtundu". Mukadina, mndandanda udzatsegulidwa, pomwe pamzere wapamwamba kwambiri padzakhala mwayi "mzere kutalika". Muyenera alemba pa izo.
   

   

3. Kenako, zenera lokhala ndi nthawi yosankha kutalika kwa nthawi lidzawonekera. Zosintha zidzapangidwa ku magawo onse a malo osankhidwa. Zonse zikachitika, muyenera dinani "CHABWINO".
   

   

4. Pambuyo pazochitika zonsezi, zinali zotheka kusintha kutalika kwa maselo onse. Koma zimatsalira kuti zisinthe kukula kwa mizati. Kuti muchite izi, muyenera kusankhanso mtundu womwewo (ngati pazifukwa zina kusankha kudachotsedwa) ndikutsegula menyu womwewo, koma tsopano tikufuna kusankha. "Column width". Ndi lachitatu kuchokera pamwamba.
   

   

5. Kenako, ikani mtengo wofunikira. Pambuyo pake, timatsimikizira zochita zathu mwa kukanikiza batani "CHABWINO".
   

   

6. Hooray, zonse zatha tsopano. Pambuyo pochita zowongolera zomwe zafotokozedwa pamwambapa, magawo onse amtundu wa cell amafanana mumtundu wonsewo.
   

   

Koma iyi si njira yokhayo yotsimikizira kuti maselo onse ali ndi kukula kofanana. Kuti muchite izi, mutha kuyisintha pagawo la coordinates:

1. Kuti muyike kutalika kofunikira kwa ma cell, sunthani cholozera ku gulu lowongolera, pomwe sankhani manambala amizere yonse ndikuyitanitsa menyu yankhaniyo ndikudina kumanja pa selo iliyonse ya gulu logwirizanitsa. Padzakhala njira "mzere kutalika", pomwe muyenera dinani kale ndi batani lakumanzere.
   

   

2. Ndiye zenera lomwelo adzakhala tumphuka monga m'mbuyomu chitsanzo. Tiyenera kusankha kutalika koyenera ndikudina "CHABWINO".
   

   

3. Kutalika kwa mizati kumayikidwa mofanana. Kuti muchite izi, m'pofunika kusankha mtundu wofunikira pagawo loyang'ana loyang'ana ndikutsegula menyu, komwe mungasankhe. "Column width".
   

   

4. Kenako, tchulani mtengo womwe mukufuna ndikudina "CHABWINO".

Kuyanjanitsa pepala lonse - Njira 2

Nthawi zina, m'pofunika kugwirizanitsa osati osiyanasiyana, koma zinthu zonse. 

1. Mwachibadwa, palibe chifukwa chakuti maselo onse azisankhidwa payekha. M'pofunika kupeza ting'onoting'ono rectangle ili pa mphambano ya ofukula ndi yopingasa coordinate mipiringidzo. Kapena njira ina ndi njira yachidule ya kiyibodi Ctrl + A.
   

   

2. Umu ndi momwe mungawunikire ma cell sheet mukuyenda kumodzi kokongola. Tsopano mutha kugwiritsa ntchito njira 1 kukhazikitsa magawo a cell.
   

   

Kudzikonzekera - njira 3

Pankhaniyi, muyenera kugwira ntchito ndi malire a cell mwachindunji. Kuti mugwiritse ntchito njira iyi, muyenera:

1. Sankhani malo amodzi kapena ma cell onse a pepala linalake. Pambuyo pake, tiyenera kusuntha cholozera ku malire aliwonse agawo mkati mwa dera lomwe lasankhidwa. Kupitilira apo, cholozeracho chidzakhala chizindikiro chaching'ono chophatikiza ndi mivi yopita mbali zosiyanasiyana. Izi zikachitika, mutha kugwiritsa ntchito batani lakumanzere kuti musinthe malire. Popeza malo osiyana adasankhidwa mu chitsanzo chomwe tikufotokoza, zosinthazo zimagwiritsidwa ntchito.
   

   

2. Ndizo zonse, tsopano maselo onse mumtundu wina amakhala ndi m'lifupi mwake. Mission inatha, monga akunena.
   

   

3. Koma titha kuwona mu chithunzi pamwambapa kuti kutalika kukadali kosiyana. Kuti mukonze cholakwika ichi, muyenera kusintha kukula kwa mizere chimodzimodzi. Ndikofunikira kusankha mizere yofananira pagawo lowongolera (kapena pepala lonse) ndikusintha malo amalire a aliyense wa iwo. 17.png
4. Tsopano zachitikadi. Tinatha kuonetsetsa kuti maselo onse ndi ofanana.

Njirayi ili ndi drawback imodzi - ndizosatheka kuwongolera m'lifupi ndi kutalika kwake. Koma ngati kulondola kwakukulu sikofunikira, ndikosavuta kwambiri kuposa njira yoyamba.

Zofunika! Ngati mukufuna kuonetsetsa kuti maselo onse a pepala ali ndi kukula kofanana, muyenera kusankha aliyense wa iwo pogwiritsa ntchito bokosi pamwamba kumanzere ngodya kapena kugwiritsa ntchito kuphatikiza. Ctrl + A, ndikukhazikitsa zikhalidwe zolondola mwanjira yomweyo.

Momwe mungalumikizire mizere mutayika tebulo - Njira 4

Nthawi zambiri zimachitika kuti munthu akamayesa kuyika tebulo kuchokera pa clipboard, amawona kuti m'maselo omwe adayikidwa, kukula kwake sikufanana ndi oyambirirawo. Ndiko kuti, maselo a matebulo oyambirira ndi oikidwapo amakhala ndi kutalika kwake ndi m'lifupi mwake. Ngati mukufuna kufanana nawo, mutha kugwiritsa ntchito njira iyi:

1. Choyamba muyenera kutsegula tebulo kuti tiyenera kukopera ndi kusankha izo. Pambuyo pake pezani gulu la zida "Clipboard" tsamba "Pofikira"pomwe batani "Koperani". Muyenera alemba pa izo. Kuphatikiza apo, makiyi otentha angagwiritsidwe ntchito Ctrl + Ckukopera mitundu yomwe mukufuna ya ma cell pa clipboard.
   

   

2. Kenako, muyenera kudina pa cell yomwe chidutswa chomwe mwakopera chidzayikidwa. Ndi iye amene adzakhala ngodya yakumanzere kwa tebulo lamtsogolo. Kuti muyike chidutswa chomwe mukufuna, muyenera dinani pomwepa. Mu pop-up menyu, muyenera kupeza kusankha "Matani Special". Koma musadina muvi womwe uli pafupi ndi chinthuchi, chifukwa chidzatsegula zina zowonjezera, ndipo sizikufunika pakadali pano.
   

   

3. Ndiye kukambirana bokosi tumphuka, muyenera kupeza gulu "Ikani"komwe kuli chinthucho "Column Width", ndipo dinani batani la wailesi pafupi ndi iyo. Pambuyo kusankha izo, mukhoza kutsimikizira zochita zanu mwa kukanikiza "CHABWINO".
   

   

4. Kenako magawo a kukula kwa selo amasinthidwa kuti mtengo wake ukhale wofanana ndi womwe uli patebulo loyambirira.
   

   

5. Ndi momwemo, tsopano ndizotheka kuyika izi mu chikalata china kapena pepala kuti kukula kwa maselo ake kufanane ndi chikalata choyambirira. Chotsatirachi chingapezeke m'njira zingapo. Mutha kudina kumanja pa cell yomwe idzakhala cell yoyamba patebulo - yomwe idakopedwa kuchokera kugwero lina. Kenako menyu yankhani idzawonekera, ndipo pamenepo muyenera kupeza chinthucho "Ikani". Pali batani lofanana pa tabu "Pofikira". Koma njira yosavuta ndiyo kukanikiza kuphatikiza kiyi Ctrl + V. Ngakhale ndizovuta kukumbukira kuposa kugwiritsa ntchito njira ziwiri zam'mbuyomu, koma zikaloweza pamtima, mutha kusunga nthawi yambiri.
   

   

Ndikofunikira kwambiri kuti muphunzire malamulo odziwika kwambiri a Excel hotkey. Sekondi iliyonse yantchito singowonjezera nthawi yopulumutsidwa, komanso mwayi wokhala osatopa.

Ndi zimenezotu, tsopano makulidwe a cell a matebulo awiriwa adzakhala ofanana.

Kugwiritsa Ntchito Macro Kusintha M'lifupi ndi Kutalika

Ngati nthawi zambiri mumayenera kuwonetsetsa kuti m'lifupi ndi kutalika kwa maselo ndizofanana, ndi bwino kulemba macro yaying'ono. Kuti muchite izi, muyenera kusintha makonda anu pogwiritsa ntchito chilankhulo cha VBA. RowHeight и ColumnWidth.

Ngati tikulankhula za chiphunzitso, ndiye kuti kusintha kutalika ndi m'lifupi mwa selo, muyenera kulamulira mzere ndi magawo magawo.

Macro imakulolani kuti musinthe kutalika kwa mfundo zokha, komanso m'lifupi mwa zilembo. Sizingatheke kukhazikitsa mayunitsi a muyeso omwe mukufunikira.

Kuti musinthe kutalika kwa mzere, gwiritsani ntchito katunduyo RowHeight chinthu -. Mwachitsanzo, inde.

ActiveCell.RowHeight = 10

Apa, kutalika kwa mzere womwe selo yogwira imapezeka kudzakhala mfundo 10. 

Ngati mulowetsa mzere woterewu mu macro editor, kutalika kwa mzere wachitatu kudzasintha, komwe kwa ife kudzakhala mfundo 30.

Mizere(3).RowHeight = 30

Malinga ndi mutu wathu, umu ndi momwe mungasinthire kutalika kwa maselo onse ophatikizidwa mumtundu wina:

Range(«A1:D6»).RowHeight = 20

Ndipo monga izi - ndime yonse:

Mizati(5).RowHeight = 15

Nambala ya mzati imaperekedwa m'makolo. Ndizofanana ndi zingwe - chiwerengero cha chingwe chimaperekedwa m'mabokosi, chomwe chili chofanana ndi chilembo cha zilembo zomwe zimagwirizana ndi chiwerengero.

Kuti musinthe m'lifupi mwake, gwiritsani ntchito katunduyo ColumnWidth chinthu -. Ma syntax ndi ofanana. Ndiye kuti, kwa ife, muyenera kusankha pamitundu yomwe mukufuna kusintha. Ikhale A1:D6. Kenako lembani mzere wotsatira wa code:

Range(«A1:D6»).ColumnWidth = 25

Zotsatira zake, selo lililonse mkati mwamtunduwu limakhala ndi zilembo 25 m'lifupi.

Njira yoti musankhe?

Choyamba, muyenera kuyang'ana kwambiri ntchito zomwe wogwiritsa ntchito ayenera kumaliza. Nthawi zambiri, ndizotheka kusintha m'lifupi ndi kutalika kwa selo iliyonse pogwiritsa ntchito kusintha kwamanja mpaka pixel. Njirayi ndi yabwino chifukwa ndizotheka kusintha chiŵerengero chenicheni cha m'lifupi ndi kutalika kwa selo lililonse. Choyipa chake ndikuti zimatenga nthawi yambiri. Kupatula apo, muyenera kusuntha cholozera cha mbewa pa riboni, kenako lowetsani kutalika mosiyana ndi kiyibodi, mosiyana m'lifupi, dinani batani "Chabwino". Zonsezi zimatenga nthawi.

Momwemonso, njira yachiwiri yosinthira pamanja mwachindunji kuchokera pagulu lolumikizira ndiyosavuta kwambiri. Mutha kudina kawiri mbewa kupanga masinthidwe oyenera a ma cell onse a pepala kapena chidutswa china cha chikalata.

Macro, kumbali ina, ndi njira yokhayo yomwe imakupatsani mwayi wosintha magawo a cell ndikudina pang'ono. Koma pamafunika luso lopanga mapulogalamu, ngakhale sizovuta kuzidziwa bwino zikafika pamapulogalamu osavuta.

Mawuwo

Choncho, pali njira zingapo zosinthira kukula ndi kutalika kwa maselo, omwe ali oyenera ntchito zina. Chotsatira chake, tebulo likhoza kukhala losangalatsa kwambiri kuyang'ana ndi kumasuka kuwerenga. Kwenikweni, zonsezi zimachitidwa chifukwa cha izi. Pofotokoza mwachidule zomwe tapeza, timapeza njira zotsatirazi:

1. Kusintha m'lifupi ndi kutalika kwa ma cell osiyanasiyana kudzera pagulu "Maselo", yomwe imapezeka pa tabu "Pofikira".
2. Kusintha magawo a cell a chikalata chonse. Kuti muchite izi, muyenera dinani kuphatikiza Ctrl + A kapena pa selo pa mphambano ya chipilala chokhala ndi manambala a mizere ndi mzere wokhala ndi mayina a magawo a zilembo.
3. Kusintha kwapamanja kwa kukula kwa ma cell pogwiritsa ntchito gulu la coordinate. 
4. Kusintha kwa ma cell kuti agwirizane ndi kachidutswa komwe kanakopera. Apa amapangidwa kukula kofanana ndi tebulo lomwe linakopera kuchokera ku pepala lina kapena bukhu la ntchito.

Kawirikawiri, palibe chovuta pa izi. Njira zonse zomwe zafotokozedwazo zimamveka pamlingo wachilengedwe. Ndikokwanira kuzigwiritsa ntchito kangapo kuti musamangogwiritsa ntchito nokha, komanso kuphunzitsa wina mofanana.