Njira zazifupi za kiyibodi yanga ya Excel - momwe mungapangire njira zazifupi za kiyibodi mu Excel

Anthu omwe amagwira ntchito pafupipafupi ndi Excel spreadsheets amafunika kuchita zomwezo nthawi zambiri. Kuti musinthe zochita zanu, mutha kugwiritsa ntchito njira ziwiri. Yoyamba ndi yogawa njira zazifupi za kiyibodi pa Quick Access Toolbar. Chachiwiri ndi kulengedwa kwa macros. Njira yachiwiri ndiyovuta kwambiri, chifukwa muyenera kumvetsetsa kachidindo ka pulogalamu kuti mulembe ma macros. Njira yoyamba ndi yophweka, koma tiyenera kulankhula zambiri za momwe tingayikitsire zida zofunikira pa gulu lofikira mwamsanga.

Njira zazifupi za Keyboard mu Excel

Mutha kupanga makiyi otentha nokha, koma izi sizikutanthauza kuti adzakhala othandiza momwe mungathere. Pulogalamuyi yapanga kale zophatikizira zambiri, malamulo ena, omwe mutha kuchita nawo zinthu zosiyanasiyana.. Mitundu yonse ya njira zazifupi zomwe zilipo zitha kugawidwa m'magulu angapo malinga ndi cholinga chawo. Malamulo ofulumira pakukonza deta:

1. CTRL + T - pogwiritsa ntchito kuphatikiza kiyi, mutha kupanga pepala losiyana kuchokera ku selo limodzi ndi maselo osankhidwa ozungulira.
2. CTRL + 1 - Imayendetsa Maselo a Format Kuchokera pa Table dialog box.

Gulu losiyana la malamulo ofulumira a masanjidwe a data limatha kusiyanitsidwa ndi kuphatikiza kwa CTRL + SHIFT ndi zilembo zowonjezera. Ngati muwonjezera% - sinthani mawonekedwe kukhala maperesenti, $ - yambitsani mtundu wandalama, ; - kukhazikitsa tsiku kuchokera pakompyuta, ! - khazikitsani mtundu wa nambala, ~ - yambitsani mtundu wamba. Seti yokhazikika yachidule cha kiyibodi:

1. CTRL + W - kudzera mu lamulo ili, mutha kutseka nthawi yomweyo buku logwira ntchito.
2. CTRL + S - sungani chikalata chogwira ntchito.
3. CTRL+N - pangani chikalata chatsopano chogwira ntchito.
4. CTRL + X - Onjezani zomwe zili m'maselo osankhidwa kupita pa clipboard.
5. CTRL + O - tsegulani chikalata chogwira ntchito.
6. CTRL + V - pogwiritsa ntchito kuphatikiza uku, deta yochokera pa clipboard imawonjezedwa ku selo yolembedwa pasadakhale.
7. CTRL + P - imatsegula zenera ndi zosintha zosindikiza.
8. CTRL+Z ndi lamulo kuti musinthe zochita.
9. F12 - fungulo ili limasunga chikalata chogwira ntchito pansi pa dzina lina.

Malangizo ogwiritsira ntchito mitundu yosiyanasiyana:

1. CTRL+ ' - koperani chilinganizo chomwe chili mu selo pamwamba, muyike mu selo yolembedwa kapena mzere wa mafomu.
2. CTRL + ` - pogwiritsa ntchito lamulo ili, mutha kusintha mawonekedwe amitundu mumitundu ndi ma cell.
3. F4 - funguloli limakupatsani mwayi wosinthana pakati pa zosankha zosiyanasiyana pazolinga.
4. Tab ndi lamulo loti mutsirize zokha dzina la ntchito.

Malamulo olowetsa data:

1. CTRL + D - pogwiritsa ntchito lamulo ili, mukhoza kukopera zomwe zili mu selo yoyamba yamtundu wodziwika, ndikuwonjezera ku maselo onse omwe ali pansipa.
2. CTRL + Y - ngati n'kotheka, lamulo libwereza zomwe zachitika.
3. CTRL +; - kuwonjezera tsiku lapano.
4. ALT+Enter Lowani mzere watsopano mkati mwa selo ngati edit mode ndi yotseguka.
5. F2 - sinthani cell yolembedwa.
6. CTRL+SHIFT+V - Imatsegula Paste Special docker.

Kuwona kwa Data ndi Kuyenda:

1. Kunyumba - ndi batani ili mukhoza kubwerera ku selo yoyamba pa pepala logwira ntchito.
2. CTRL + G - imabweretsa zenera "Transition" - Pitani ku.
3. CTRL+PgDown - pogwiritsa ntchito lamulo ili, mukhoza kupita ku tsamba lotsatira.
4. CTRL + END - Kusuntha pompopompo kupita ku selo lomaliza la pepala logwira ntchito.
5. CTRL + F - Lamulo ili limabweretsa bokosi la Pezani.
6. CTRL + Tab - sinthani pakati pa mabuku ogwirira ntchito.
7. CTRL+F1 - Bisani kapena onetsani riboni ndi zida.

Malamulo posankha deta:

1. SHIFT+Space - njira yachidule ya kiyibodi kuti musankhe mzere wonse.
2. CTRL+Space ndi njira yachidule ya kiyibodi kuti musankhe ndime yonse.
3. CTRL + A - kuphatikiza kusankha pepala lonse.

Zofunika! Mmodzi mwa malamulo othandiza ndikusankha maselo osiyanasiyana omwe ali ndi deta iliyonse, wogwiritsa ntchito akugwira nawo ntchito mwakhama. Komabe, poyerekeza ndi kuphatikiza kwina, imakhala ndi magawo awiri. Choyamba muyenera kukanikiza Ctrl + Kunyumba, kenako dinani kuphatikiza Ctrl + Shift + End.

Momwe mungagawire ma hotkeys kuti mupange seti yanu

Simungathe kupanga makiyi anu achidule mu Excel. Izi sizikugwira ntchito kwa macros, polemba zomwe muyenera kumvetsetsa kachidindo, zikhazikitseni pagulu lofikira mwachangu. Chifukwa cha izi, malamulo oyambira okha omwe afotokozedwa pamwambapa ndi omwe amapezeka kwa wogwiritsa ntchito. Kuchokera pamakina ophatikizika, muyenera kusankha malamulo omwe amagwiritsidwa ntchito kapena omwe adzagwiritsidwe ntchito pafupipafupi. Pambuyo pake, ndi zofunika kuwonjezera iwo mwamsanga kupeza gulu. Mutha kutenga chida chilichonse kuchokera kumagulu osiyanasiyana kulowamo, kuti musachiyang'ane mtsogolo. Njira yogawa ma hotkeys imakhala ndi njira zingapo:

1. Tsegulani chida chofikira mwachangu podina chizindikiro chapansi, chomwe chili pamwamba pazida zazikulu.

2. Zenera la zoikamo liyenera kuwonekera pazenera kuti mugawidwe, kusintha njira zazifupi za kiyibodi. Mwa malamulo akufuna, muyenera kusankha "VBA-Excel".

3. Pambuyo pake, mndandanda uyenera kutsegulidwa ndi malamulo onse omwe akupezeka kwa wogwiritsa ntchito omwe angathe kuwonjezeredwa ku gulu lofikira mwamsanga. Kuchokera pamenepo muyenera kusankha zomwe zimakukondani kwambiri.

Pambuyo pake, fungulo lachidule la lamulo losankhidwa lidzawonekera pa bar yachidule. Kuti mutsegule lamulo lowonjezera, njira yosavuta ndikudina ndi LMB. Komabe, pali njira ina. Mutha kugwiritsa ntchito kuphatikiza kiyi, pomwe batani loyamba ALT, batani lotsatira ndi nambala ya lamulo, monga momwe imawerengera mu bar yachidule.

Upangiri! Sizovomerezeka kupereka njira yachidule ya kiyibodi mu Quick Access Toolbar. Izi ndichifukwa choti munthu aliyense amafunikira malamulo ake, omwe sangapatsidwe pulogalamuyo mu mtundu wamba.

Mukapatsidwa njira zazifupi za kiyibodi, tikulimbikitsidwa kuti tiyese kuziyambitsa osati ndi mbewa, koma ndi mabatani ophatikizana oyambira ndi ALT. Izi zikuthandizani kuti musunge nthawi pazinthu zobwerezabwereza komanso kuti ntchitoyo ichitike mwachangu.