Momwe mungasinthire ma cell mu Excel

Pamene mukugwira ntchito ku Excel, nthawi zambiri zimakhala zofunikira kusintha dongosolo la maselo, mwachitsanzo, muyenera kusintha ena mwa iwo. Momwe mungachitire izi m'njira zosiyanasiyana, tikambirana m'nkhaniyi.

Njira yosunthira ma cell

Palibe ntchito ina yomwe imakupatsani mwayi wochita izi mu Excel. Ndipo mukamagwiritsa ntchito zida zokhazikika, ma cell ena onse amasuntha, zomwe ziyenera kubwezeredwa m'malo awo, zomwe zimabweretsa zina. Komabe, pali njira zokwaniritsira ntchitoyi, ndipo zidzakambidwa pansipa.

Njira 1: Koperani

Iyi mwina ndiyo njira yophweka, yomwe imaphatikizapo kukopera zinthu kumalo ena ndikusintha deta yoyamba. Ndondomekoyi ili motere:

1. Timadzuka mu selo loyamba (kusankha), lomwe tikukonzekera kusuntha. Pa tabu yayikulu ya pulogalamuyo, dinani batani "Koperani" (gulu la zida "Clipboard"). Mukhozanso kungosindikiza makiyi osakaniza Ctrl + C.
2. Pitani ku selo iliyonse yaulere pa pepala ndikusindikiza batani "Ikani" mu tabu yomweyi ndi gulu la zida. Kapena mutha kugwiritsanso ntchito ma hotkeys - Ctrl + V.
3. Tsopano sankhani selo lachiwiri lomwe tikufuna kusinthana nalo loyamba, ndikutengeranso.
4. Timayimirira mu selo loyamba ndikusindikiza batani "Ikani" (kapena Ctrl + V).
5. Tsopano sankhani selo momwe mtengo wochokera ku selo yoyamba inakopera ndikuyikopera.
6. Pitani ku selo yachiwiri komwe mukufuna kuyika deta, ndikusindikiza batani lolingana pa riboni.
7. Zinthu zomwe zasankhidwa zasinthidwa bwino. Selo yomwe idasunga kwakanthawi zomwe zakopedwa sikufunikanso. Dinani kumanja pa izo ndikusankha lamulo kuchokera pamenyu yomwe imatsegula "Chotsani".
8. Kutengera ngati pali zinthu zodzazidwa pafupi ndi selo ili kumanja / pansi kapena ayi, sankhani njira yoyenera yochotsa ndikudina batani. OK.
9. Ndizo zonse zomwe zimayenera kuchitika kuti musinthe ma cell.

Ngakhale kuti kugwiritsa ntchito njirayi, muyenera kuchita zambiri zowonjezera, komabe, zimagwiritsidwa ntchito ndi ogwiritsa ntchito ambiri.

Njira 2: kukokera ndi kuponya

Njirayi imagwiritsidwanso ntchito posinthanitsa ma cell, komabe, pakadali pano, maselo adzasinthidwa. Kenako, timachita zotsatirazi:

1. Sankhani selo lomwe tikukonzekera kupita kumalo atsopano. Timasuntha cholozera cha mbewa pamalire ake, ndipo ikangosintha mawonekedwe kukhala cholozera wamba (ndi mivi 4 mbali zosiyanasiyana kumapeto), kukanikiza ndi kugwira fungulo. kosangalatsa, sunthani selo kupita kumalo atsopano ndikusindikiza batani lakumanzere.
2. Nthawi zambiri, njirayi imagwiritsidwa ntchito kusinthanitsa maselo oyandikana nawo, chifukwa kusuntha kwa zinthu pankhaniyi sikuphwanya kapangidwe ka tebulo.
3. Ngati tiganiza zosuntha selo kudzera m'malo ena angapo, izi zisintha malo a zinthu zina zonse.
4. Pambuyo pake, muyenera kubwezeretsa dongosolo.

Njira 3: Kugwiritsa Ntchito Macros

Tidanena koyambirira kwa nkhaniyi kuti ku Excel, tsoka, palibe chida chapadera chomwe chimakulolani kuti musinthe "kusinthana" maselo m'malo (kupatula njira yomwe ili pamwambapa, yomwe imagwira ntchito pazinthu zoyandikana). Komabe, izi zitha kuchitika pogwiritsa ntchito ma macros:

1. Choyamba muyenera kuwonetsetsa kuti zomwe zimatchedwa "madivelopa" zimayatsidwa mu pulogalamuyi (yozimitsa mwachisawawa). Za ichi:
   • kupita ku menyu "Fayilo" ndi kusankha pa mndandanda kumanzere "Parameters".
   • muzosankha za pulogalamu, dinani kachigawo "Sinthani Riboni", kumanja, ikani chizindikiro kutsogolo kwa chinthucho "Developer" ndipo dinani OK.
2. Sinthani ku tabu "Developer", pomwe dinani chizindikirocho "Visual Basic" (gulu la zida "kodi").
3. Mu mkonzi, podina batani "Onani Kodi", ikani kachidindo pansipa pawindo lomwe likuwoneka:

   Sub ПеремещениеЯчеек()

   Dim ra As Range: Khazikitsani ra = Kusankhidwa

   msg1 = "Chotsani mawu achinsinsi pakompyuta yanu"

   msg2 = "Pangani zosintha zaposachedwa za ИДЕНТИЧНОГО размера"

   Ngati ra.Areas.Count <> 2 Ndiye MsgBox msg1, vbCritical, "Проблема": Tulukani Pansi

   Ngati ra.Areas(1).Kuwerengera <> ra.Areas(2).Werengani Ndiye MsgBox msg2, vbCritical, "Проблема": Tulukani Pansi

   Application.ScreenUpdating = Zabodza

   arr2 = ra.Madera(2).Value

   ra.Madera(2).Mtengo = ra.Madera(1).Mtengo

   ra.Madera(1).Value = arr2

   mapeto Sub

4. Tsekani zenera la mkonzi podina batani lomwe mwachizolowezi mu mawonekedwe a mtanda pakona yakumanja yakumanja.
5. Kugwira kiyi Ctrl pa kiyibodi, sankhani ma cell awiri kapena magawo awiri omwe ali ndi zinthu zomwe tikukonzekera kusinthana. Kenako dinani batani "Macro" (tab "Developer", Gulu "kodi").
6. Iwindo lidzawoneka momwe tikuwona macro omwe adapangidwa kale. Sankhani izo ndi kumadula "Thamanga".
7. Chifukwa cha ntchitoyi, macro adzasintha zomwe zili m'maselo osankhidwa.

Zindikirani: chikalatacho chikatsekedwa, macro adzachotsedwa, kotero nthawi ina idzafunika kupangidwanso (ngati kuli kofunikira). Koma, ngati mukuyembekeza kuti mtsogolomu mudzayenera kuchita izi, fayiloyo imatha kupulumutsidwa ndi chithandizo cha macro.

Kutsiliza

Kugwira ntchito ndi ma cell omwe ali patebulo la Excel sikungolowetsa, kusintha kapena kuchotsa deta. Nthawi zina mumayenera kusuntha kapena kusinthanitsa ma cell omwe ali ndi zinthu zina. Ngakhale kuti palibe chida chosiyana mu Excel magwiridwe antchito, zitha kuchitika pokopera ndikuyika mfundo, kusuntha selo, kapena kugwiritsa ntchito macros.