Painter Format - Hotkeys mu Excel

Microsoft Office Excel ili ndi ntchito yomwe imayika masanjidwe ofanana a zidutswa zingapo za tebulo nthawi imodzi. Nkhaniyi ifotokoza mbali zazikulu za chisankho.

Momwe mungayambitsire Format Painter

Mutha kuyatsa mode iyi motere:

1. Tsegulani Excel ndikusankha selo lomwe mukufuna kukopera mtunduwo.
2. Pitani ku gawo la "Home" pamwamba pa menyu yayikulu ndikudina batani la "Format Painter". Ili pafupi ndi mawu oti "Ikani".

3. Sankhani mitundu yosiyanasiyana ya ma cell mu tebulo yomwe mukufuna kugwiritsa ntchito masanjidwe amtundu wofanana ndi chinthu choyambirira. Wogwiritsa ntchito akatulutsa batani lakumanzere, ntchitoyo imamalizidwa.

Tcherani khutu! Pambuyo poyambitsa ntchitoyi, chithunzi cha tsache chidzawonekera pafupi ndi cholozera chokhazikika mu Excel.

Mawonekedwe a Format Painter

Kuti mumvetse bwino mutuwo, m'pofunika kuganizira zambiri za mwayi umene masanjidwe oterewa ali nawo. Pali zingapo mwa izo:

1. Kutha kukopera mawonekedwe a cell imodzi. Kuchuluka kwa ma cell omwe mungakopere mawonekedwe ake sikokwanira.
2. Ntchitoyi imagwira ntchito pamizere yonse ndi mizati ya tebulo lililonse. Kuphatikiza apo, mitundu yosankhidwayo imagwirizana kwathunthu ndi choyambirira.
3. Mothandizidwa ndi njirayi, ndizotheka kuchotsa mawonekedwe osafunika kuchokera ku maselo ena a tebulo.
4. Mukadina batani la mtundu kawiri ndi LMB, lamulolo lidzakhazikika, ndipo wogwiritsa ntchitoyo atha kubweretsa ma cell ambiri mumtundu umodzi mpaka akanikizire kiyi ya Esc pa kiyibodi.
5. Kuthekera kwa masanjidwe malinga ndi zitsanzo za zinthu zilizonse: zithunzi, mtundu, ma chart, ma graph, ndi zina.

Ma hotkeys kuti muyambitse Painter ya Format

Mu Excel, lamulo lililonse, ntchito imatha kukhazikitsidwa ndi kuphatikiza kwa mabatani apadera pa kiyibodi yapakompyuta. Kuti mutsegule mawonekedwe a "Format Painter", muyenera kuchita izi:

1. Gwiritsani ntchito batani lakumanzere la mbewa kuti musankhe magulu angapo kapena chinthu chimodzi chomwe mukufuna kukopera.
2. Nthawi yomweyo gwirani mabatani a "Ctrl + C" kuchokera pa kiyibodi ya PC, ndikusinthira ku masanjidwe a Chingerezi.
3. Sunthani cholozera cha mbewa kupita ku selo lina ndikusindikiza makiyi "Ctrl + V". Pambuyo pake, chinthu ichi chidzatenga mawonekedwe a selo yoyambirira pamodzi ndi zomwe zili mkati mwake.

Zofunika! Mutha kugwiritsanso ntchito kuphatikiza kwa "Ctrl + Shift + V" kuti mupange molingana ndi chitsanzo. Komabe, kuti muchite izi, muyenera kulemba kachidindo kakang'ono ndikusunga mu buku lanu lalikulu.

Code ikalembedwa, hotkey iyenera kuwonjezeredwa pamndandanda wamalamulo a Excel. Kuti muthane ndi ntchitoyi, muyenera kuchita zingapo zosavuta malinga ndi algorithm:

1. Lowetsani tabu "Onani" pamwamba pazida za pulogalamuyi.
2. Wonjezerani menyu ya "Macros" podina LMB pamivi yomwe ili pafupi nayo.
3. Muzosankha zamkati, sankhani chinthu chomwe chili ndi dzina lomweli.
4. Pazenera lomwe limatsegulidwa, pansi pa mzere "Macro Name", dzina la code yomwe yawonjezeredwa kale lidzalembedwa. Iyenera kusankhidwa ndi batani lakumanzere la mbewa ndikudina batani la "Parameters" pazida zambali kumanja kwa zenera.

5. Pa tabu yomwe ikuwoneka, m'munda wa "Kiyibodi Yachidule", gwiritsani mabatani "Ctrl + Shift + V" kuti muwonjezere kiyi yotentha, kenako dinani "Chabwino" kuti mugwiritse ntchito zosinthazo.

Momwe mungagwiritsire ntchito lamulo la "Ctrl + Shift + V".

Mukapanga hotkey, muyenera kumvetsetsa momwe mungagwiritsire ntchito lamuloli. Mfundo yogwiritsira ntchito kuphatikiza "Ctrl + Shift + V" ikhoza kudziwika motere:

1. Sankhani mtundu wa zinthu zomwe mukufuna kukopera mtunduwo.
2. Gwirani mabatani a "Ctrl + C" kuti muwonjezere zomwe zili mu cell pa clipboard.
3. Pitani ku tsamba lomwe mukufuna ndikukanikiza kuphatikiza "Ctrl + Shift + V".
4. Onani zotsatira.

Zina Zowonjezera! Mukakanikiza makiyi a "Ctrl + C", selo loyambirira lidzawonetsedwa mumtundu wofananira. Izi zikusonyeza chiyambi cha ntchito ya gulu.

Ntchito ya Format Painter imapangitsa kukhala kosavuta kukopera mawonekedwe ndi zithunzi zosiyanasiyana. Ngati mungofunika kukopera zomwe zili mu cell inayake, mutha kugwiritsa ntchito kuphatikiza "Ctrl + Shift + V"

Momwe mungakopere mwachangu zomwe zili mu cell mu tebulo

Pali njira zingapo zokopera zoterezi. Komabe, njira yosavuta komanso yothandiza kwambiri imagawidwa m'njira zotsatirazi:

1. Sankhani zomwe zili pagulu la tebulo, zomwe zili mkati mwake ziyenera kusamutsidwa ku cell ina.
2. Sankhani cell yomwe mukufuna posankha ndi batani lakumanzere.
3. Sunthani cholozera cha mbewa pamzere kuti mulowetse mafomu pamzere wapamwamba wa menyu yayikulu ya pulogalamuyi.
4. Ikani chizindikiro "=" pamzere ndikulozera ku cell cell.

5. Dinani "Enter" kuchokera pa kiyibodi kuti mumalize ntchitoyi.

6. Onani zotsatira. Zomwe zili muzoyambira ziyenera kupita ku zomwe zasankhidwa.

Tcherani khutu! Momwemonso, mutha kudzaza ma cell omwe mukufuna mu mbale.

Kutsiliza

Chifukwa chake, Microsoft Office Excel ili ndi zinthu zambiri zothandiza zomwe zimakulolani kuti musinthe njira inayake. Mapangidwe a pore ndi njira imodzi yotere. Njira zonse zoyatsira ndikugwiritsa ntchito zafotokozedwa pamwambapa.