Urufunguzo rushyushye ni umurimo ukoresha urutonde rwanditseho clavier yihariye urufunguzo, itanga uburyo bwihuse kuri sisitemu yo gukora, cyangwa gahunda itandukanye. Iki gikoresho nacyo kiraboneka kuri Microsoft Excel. Reka tumenye icyo Hotkeys iraboneka muri porogaramu ya Excel, kandi ko ushobora kubikora.
Rusange
Mbere ya byose, twakagombye kumenya ko murutonde ruri munsi yurutonde rushyushye, "ikimenyetso kimwe" + "kizaba nkikimenyetso cyerekana urufunguzo. Mugihe ikimenyetso cya "++" cyasobanuwe - Ibi bivuze ko kuri clavier ugomba gukanda "+" urufunguzo hamwe nurundi rufunguzo, rwerekanwe. Izina ryimikorere igaragazwa mugihe ivugwa nka clavier: F1, F2, F3, nibindi.Kandi, dukwiye kuvugwa ko abakeneye gukanda urufunguzo rwa serivisi. Harimo Shift, Ctrl na Alt. Na nyuma, gufata izi nkuru, kanda urufunguzo rwibikorwa, buto hamwe ninyuguti, imibare, nizindi nyuguti.
Igenamiterere rusange
Ibikoresho rusange bya Microsoft nibyo bintu byibanze bya gahunda: Gufungura, kuzigama, gukora dosiye, nibindi. Urufunguzo rushyushye rutanga uburyo bwo kubona iyi mirimo ni izi zikurikira:
- Ctrl + n - Gukora dosiye;
- Ctrl + s - Kubungabunga igitabo;
- F12 - Guhitamo imiterere n'aho igitabo cyo kuzigama;
- Ctrl + o - Gufungura igitabo gishya;
- Ctrl + F4 - Gufunga igitabo;
- Ctrl + p - Icapa ryerekana;
- Ctrl + a ni ukugaragaza urupapuro rwose.
Infunguzo zo kugenda
Kuyobora urupapuro cyangwa igitabo, Hariho nurufunguzo rushyushye.
- Ctrl + F6 - kugenda hagati y'ibitabo byinshi bifunguye;
- Tab - kwimuka kugera muri selile ikurikira;
- Shift + tab - kugenda mu kagari kabanje;
- Urupapuro hejuru - kugenda hejuru yubunini bwa monitor;
- Page hepfo - kwimuka kugeza ku bunini bwa monitor;
- Ctrl + page hejuru - kugenda kurupapuro rwabanje;
- Ctrl + page hepfo - kugenda kugera kurupapuro rukurikira;
- Ctrl + iherezo - kugenda ku Kagari kanyuma;
- Ctrl + murugo - kugenda muri selile yambere.
Urufunguzo rushyushye rwo kubara ibikorwa
Microsoft Excel ntabwo ikoreshwa mu kubaka imbonerahamwe yoroshye gusa, ahubwo no mubikorwa byo kubaramo muri bo, winjiza formulaire. Kugirango habeho byihuse ibyo bikorwa, hariho hotkey ikwiye.
- Alt + = - Gukora Avosumma;
- Ctrl + ~ - yerekana ibisubizo byo kubara mu tugari;
- F9 - kwisubiraho kuri formulaire zose muri dosiye;
- Shift + F9 - kwisubiraho formulaire ku rupapuro rukora;
- Shift + F3 - Hamagara imirimo yimyiganye.
Ikosora
Urufunguzo rushyushye rwagenewe guhindura amakuru akwemerera kuzuza imbonerahamwe hamwe namakuru byihuse.
- F2 - Uburyo bwo Guhindura Akagari kagaragaye;
- Ctrl ++ - Ongeraho inkingi cyangwa umurongo;
- Ctrl + - - Gusiba inkingi zatoranijwe cyangwa umurongo ku rupapuro rwa Microsoft Extl Ameza;
- Ctrl + Gusiba - Kuraho inyandiko yatoranijwe;
- Ctrl + h - Shakisha / gusimbuza idirishya;
- Ctrl + z - guhagarika ibikorwa byakozwe nuwanyuma;
- Ctrl + Alt + V ninjiza yihariye.
Imiterere
Kimwe mubintu byingenzi byimbonerahamwe na karuzo ari imiterere. Byongeye kandi, imiterere nayo igira ingaruka kubikorwa byo kubara muri Excel.
- Ctrl + shift +% - gushiramo imiterere yijana;
- Ctrl + shift + $ - imiterere yimvugo y'amafaranga;
- Ctrl + shift + # - Itariki Itariki;
- Ctrl + Shift +! - Imiterere y'imibare;
- Ctrl + shift + ~ - Imiterere rusange;
- Ctrl + 1 - Gukora idirishya ryakagari.
Ibindi Bitkeys
Usibye urufunguzo rushyushye rwashyizwe mu matsinda yavuzwe haruguru, porogaramu ya Excel ifite ibintu nk'ibi byo guhuza utubuto kuri clavier kugirango hahamagare imirimo:
- Alt + '- Guhitamo uburyo bwo gushushanya;
- F11 - gukora igishushanyo kurupapuro rushya;
- Shift + F2 - Hindura ibisobanuro mu Kagari;
- F7 - Reba inyandiko kumakosa.
Nibyo, ntabwo byose gukoresha urufunguzo rushyushye muri gahunda ya Microsoft Excel Excel byatanzwe haruguru. Nubwo bimeze bityo ariko, twerekeje ibitekerezo ku gukundwa cyane, ingirakamaro, kandi tushakisha - nyuma ya bo. Nibyo, gukoresha urufunguzo rushyushye birashobora koroshya cyane no kwihutisha gahunda ya Microsoft Excel.