Gajerun hanyoyin keyboard na Excel - yadda ake ƙirƙirar saitin gajerun hanyoyin madannai na sirri a cikin Excel

Mutanen da ke aiki akai-akai tare da maƙunsar bayanai na Excel suna buƙatar yin ayyuka iri ɗaya sau da yawa. Don sarrafa ayyukanku, zaku iya amfani da hanyoyi biyu. Na farko shine aikin gajerun hanyoyin maballin madannai akan Maɓallin Saurin Samun Sauri. Na biyu shine ƙirƙirar macros. Hanya ta biyu ta fi rikitarwa, tunda kuna buƙatar fahimtar lambar shirin don rubuta macros. Hanya ta farko ta fi sauƙi, amma muna buƙatar ƙarin magana game da yadda za a saka kayan aikin da ake bukata a kan madaidaicin damar shiga cikin sauri.

Gajerun hanyoyin keyboard masu fa'ida a cikin Excel

Kuna iya ƙirƙirar maɓallan zafi da kanku, amma wannan ba yana nufin cewa za su yi amfani sosai ba. Shirin ya riga ya gina-a cikin haɗin haɗin maɓalli da yawa, wasu umarni, waɗanda za ku iya aiwatar da ayyuka daban-daban tare da su.. Dukkanin gajerun hanyoyin da ake da su za a iya raba su zuwa ƙungiyoyi da yawa dangane da manufarsu. Umarni masu sauri don tsara bayanai:

1. CTRL+T - ta amfani da wannan haɗin maɓalli, zaku iya ƙirƙirar takaddar aiki daban daga tantanin halitta ɗaya da kewayon sel da ke kewaye da shi.
2. CTRL + 1 - Yana Kunna Tsarin Kwayoyin Daga Akwatin maganganu.

Ƙungiyar umarni masu sauri don tsara bayanai za a iya bambanta ta hanyar haɗin CTRL + SHIFT tare da ƙarin haruffa. Idan kun ƙara% - canza tsarin zuwa kashi-kashi, $ - kunna tsarin kuɗi,; – saita kwanan wata daga kwamfuta,! – saita tsarin lamba, ~ – kunna tsarin gaba ɗaya. Daidaitaccen saitin gajerun hanyoyin madannai:

1. CTRL + W - ta wannan umarnin, zaku iya rufe littafin aiki nan take.
2. CTRL + S – ajiye daftarin aiki.
3. CTRL+N – ƙirƙirar sabon daftarin aiki.
4. CTRL+X – Ƙara abun ciki daga sel da aka zaɓa zuwa allon allo.
5. CTRL + O – bude daftarin aiki.
6. CTRL + V - ta amfani da wannan haɗin, ana ƙara bayanai daga allon allo zuwa tantanin halitta da aka yiwa alama a gaba.
7. CTRL+P - yana buɗe taga tare da saitunan bugawa.
8. CTRL+Z umarni ne don soke wani aiki.
9. F12 - wannan maɓalli yana adana daftarin aiki a ƙarƙashin wani suna daban.

Umarni don aiki tare da dabaru daban-daban:

1. CTRL+ '- kwafi dabarar da ke cikin tantanin halitta a sama, liƙa ta cikin tantanin halitta mai alama ko layi don ƙira.
2. CTRL + `- ta amfani da wannan umarni, zaku iya canza yanayin nunin ƙima a cikin ƙididdiga da sel.
3. F4 - wannan maɓalli yana ba ku damar canzawa tsakanin zaɓuɓɓuka daban-daban don nassoshi a cikin ƙididdiga.
4. Tab umarni ne don kammala sunan aiki ta atomatik.

Umurnin shigar da bayanai:

1. CTRL+D - ta amfani da wannan umarni, zaku iya kwafin abun ciki daga tantanin halitta na farko na kewayon alama, ƙara shi zuwa duk sel da ke ƙasa.
2. CTRL+Y - idan zai yiwu, umarnin zai maimaita aikin ƙarshe da aka yi.
3. CTRL+; - ƙara kwanan wata na yanzu.
4. Shigar ALT+ Yana shigar da sabon layi a cikin tantanin halitta idan yanayin gyarawa ya buɗe.
5. F2 - canza tantanin halitta mai alama.
6. CTRL+SHIFT+V - Yana buɗe Docker na Musamman na Manna.

Duban Bayanai da Kewayawa:

1. Gida - tare da wannan maɓallin zaka iya komawa zuwa tantanin halitta na farko akan takardar aiki.
2. CTRL + G - yana kawo taga "Transition" - Je zuwa.
3. CTRL + PgDown - ta amfani da wannan umarni, zaku iya zuwa takardan aiki na gaba.
4. CTRL+ KARSHE – Matsa kai tsaye zuwa tantanin halitta na ƙarshe na takardar aiki.
5. CTRL + F - Wannan umarnin yana kawo akwatin Nemo maganganu.
6. CTRL + Tab – canza tsakanin littattafan aiki.
7. CTRL + F1 - Boye ko nuna kintinkiri tare da kayan aiki.

Umarni don zaɓar bayanai:

1. SHIFT+Space – gajeriyar hanyar madannai don zaɓar layin gaba ɗaya.
2. CTRL+Space gajeriyar hanya ce ta maballin madannai don zaɓar kowane shafi.
3. CTRL+A – haɗin don zaɓar duk takardar aikin.

Muhimmin! Ɗaya daga cikin umarni masu amfani shine zaɓar kewayon sel waɗanda suka ƙunshi kowane bayanai, mai amfani yana aiki tare da su. Koyaya, idan aka kwatanta da sauran haɗuwa, ya ƙunshi sassa biyu. Da farko kana bukatar ka danna Ctrl + Home, sannan ka danna hade Ctrl + Shift + End.

Yadda ake sanya hotkeys don ƙirƙirar saitin ku

Ba za ku iya ƙirƙirar maɓallan gajerun hanyoyin ku a cikin Excel ba. Wannan ba ya shafi macros, don rubuta abin da kuke buƙatar fahimtar lambar, saka su daidai a kan rukunin shiga cikin sauri. Saboda wannan, kawai ainihin umarnin da aka bayyana a sama suna samuwa ga mai amfani. Daga mahaɗin maɓalli, kuna buƙatar zaɓar waɗannan umarni waɗanda ake amfani da su ko kuma za a yi amfani da su akai-akai. Bayan haka, yana da kyawawa don ƙara su zuwa panel mai sauri. Kuna iya ɗaukar kowane kayan aiki daga tubalan daban-daban a ciki, don kada ku neme shi a nan gaba. Tsarin sanya hotkeys ya ƙunshi matakai da yawa:

1. Buɗe ma'aunin damar shiga cikin sauri ta danna gunkin kibiya na ƙasa, wanda ke sama da babban ma'aunin kayan aiki.

2. Ya kamata taga saituna ya bayyana akan allon don sanyawa, canza gajerun hanyoyin madannai. Daga cikin umarnin da aka gabatar, kuna buƙatar zaɓar "VBA-Excel".

3. Bayan haka, ya kamata a buɗe jeri tare da duk umarnin da ake samu ga mai amfani waɗanda za a iya ƙarawa zuwa rukunin shiga cikin sauri. Daga ciki kuna buƙatar zaɓar abin da ya fi sha'awar ku.

Bayan haka, maɓallin gajeriyar hanya don umarnin da aka zaɓa zai bayyana akan sandar gajeriyar hanya. Domin kunna umarnin da aka ƙara, hanya mafi sauƙi ita ce danna shi tare da LMB. Duk da haka, akwai wata hanya. Kuna iya amfani da haɗin maɓalli, inda maɓallin farko ALT, maɓalli na gaba shine lambar umarni, kamar yadda yake ƙidaya a mashigin gajeriyar hanya.

Shawara! Ba a ba da shawarar sanya gajeriyar hanyar maballin madannai a cikin tsoffin kayan aikin Saurin Samun Sauri ba. Wannan shi ne saboda gaskiyar cewa kowane mutum yana buƙatar umarnin kansa, wanda shirin ba zai sanya shi a cikin daidaitaccen sigar ba.

Lokacin da aka sanya gajerun hanyoyin keyboard, ana ba da shawarar yin aiki da kunna su ba tare da linzamin kwamfuta ba, amma tare da haɗin maɓallan farawa da ALT. Wannan zai taimaka maka adana lokaci akan ayyuka masu maimaitawa kuma samun aikin da sauri.