Hotkeys suna aiki ne, ta hanyar rubuta wani maɓalli na haɗin kai a kan keyboard, yana ba da dama ga wasu siffofin tsarin aiki, ko kuma shirin raba. Wannan kayan aiki yana samuwa ga Microsoft Excel. Bari mu ga abin da hotkeys suke a cikin Excel, da kuma abin da za ku iya yi tare da su.
Janar bayani
Da farko, ya kamata a lura cewa a cikin jerin hotuna mai mahimmanci da ke ƙasa, alamar "+" guda ɗaya zata kasance alama ce ta nuna alamar haɗakarwa. Idan aka nuna alamar "++" - wannan yana nufin cewa a kan keyboard kana buƙatar danna maballin "+" tare da wani maɓalli da aka nuna. Sunan maɓallin ayyuka suna nuna kamar yadda ake kira su a kan keyboard: F1, F2, F3, da dai sauransu.
Har ila yau, ya kamata a ce cewa na farko yana buƙatar danna maɓallin sabis. Wadannan sun haɗa da Shift, Ctrl da Alt. Bayan haka, yayin riƙe da waɗannan makullin, danna kan maɓallin ayyuka, maɓalli da haruffa, lambobi, da wasu alamomi.
Janar Saituna
Gudanar da kayan aiki na Microsoft sun haɗa da fasali na shirin: buɗewa, ajiyewa, samar da fayil, da dai sauransu. Maballin hotuna da ke samar da damar yin amfani da waɗannan ayyuka sune kamar haka:
- Ctrl + N - ƙirƙira fayil;
- Ctrl + S - ajiye littafin;
- F12 - zaɓi tsarin da wuri na littafin don ajiyewa;
- Ctrl + O - buɗe sabon littafi;
- Ctrl + F4 - rufe littafin;
- Ctrl + P - buga samfurin;
- Ctrl + A - zaɓi dukan takardar.
Maɓallin kewayawa
Don kewaya takardar ko littafi, ma, suna da maɓallan maɓallin kansu.
- Ctrl + F6 - motsawa tsakanin dama littattafan da suke bude;
- Tab - matsa zuwa na gaba cell;
- Shift + Tab - matsa zuwa cell da ta gabata;
- Page Up - motsa girman girman mai saka idanu;
- Page Ƙasa - matsa ƙasa don saka idanu girman;
- Ctrl + Page Up - matsa zuwa jerin da aka rigaya;
- Ctrl + Page Down - matsa zuwa takardar na gaba;
- Ctrl - Ƙarshe - matsa zuwa na karshe cell;
- Ctrl + Gida - matsa zuwa farkon salula.
Hotkeys don sarrafawa ayyuka
An yi amfani da Microsoft Excel ba kawai don gina matakan ba, amma har ma don aiwatar da ayyuka a cikin su, ta shigar da matakai. Don samun damar yin amfani da waɗannan ayyuka, akwai maɓallan hotuna masu dacewa.
- Alt + = - kunnawa avtosummy;
- Ctrl + ~ - sakamakon sakamakon lissafi a cikin sel;
- F9 - Maimaita dukkanin matakai a cikin fayil;
- Shift + F9 - Magana akan ƙididdiga akan takardar aiki;
- Shift + F3 - kira aikin maye.
Shirya bayanai
Hotuna don gyara bayanai suna baka dama ka cika cikin tebur da bayanai.
- F2 - yanayin daidaitawa na cell da aka zaɓa;
- Ctrl ++ - ƙara ginshikan ko layuka;
- Ctrl + - - ya kayyade ginshiƙai da aka zaɓa ko layuka a takarda na tebur na Microsoft Excel;
- Ctrl + Share - share rubutun da aka zaɓa;
- Ctrl + H - Binciken / Sauya taga;
- Ctrl + Z - gyara aikin da aka yi karshe;
- Ctrl + Alt V - Musamman sa.
Tsarin
Ɗaya daga cikin muhimman abubuwa masu mahimmanci na tebur da jeri na kwayoyin suna tsarawa. Bugu da ƙari, tsarawa yana rinjayar tafiyar matakai na Excel.
- Ctrl + Shift +% - hada da kashi dari;
- Ctrl + Shift + $ - tsari na darajar kuɗi;
- Ctrl + Shift + # - kwanan wata;
- Ctrl + Shift +! - Tsarin lambobi;
- Ctrl + Shift + ~ - daidaitaccen tsarin;
- Ctrl + 1 - yana kunna maɓallin tsari na tantanin halitta.
Sauran hotkeys
Bugu da ƙari ga hotkeys da aka jera a cikin rukuni na sama, Excel yana da ƙunshe masu mahimmanci masu zuwa a kan keyboard domin kira ayyuka:
- Alt '' - zabi na style;
- F11 - ƙirƙirar ginshiƙi akan sabon takarda;
- Shift + F2 - canza sharhin a cikin tantanin halitta;
- F7 - duba rubutu don kurakurai.
Hakika, ba dukkan zaɓuɓɓuka don amfani da maɓallan hotuna a cikin Microsoft Excel aka gabatar a sama ba. Duk da haka, mun ba da hankali ga mafi yawan mashahuri, da amfani, da kuma buƙatar su. Hakika, yin amfani da makullin maɓalli zai iya sauƙaƙewa da saurin aiki a cikin Microsoft Excel.
