Izinkinobho ezishisayo ziwumsebenzi osebenzisa isethi kukhibhodi yekhibhodi inhlanganisela ethile yokhiye, unikeza ukufinyelela okusheshayo kwamanye amakhono okusebenza, noma uhlelo oluhlukile. Leli thuluzi liyatholakala nakwi-Microsoft Excel. Ake sibheke ukuthi yini ama-hotkeys atholakala kuhlelo lokusebenza lwe-Excel, nokuthi ungenza nabo.
Jwayelekile
Okokuqala, kufanele kuqashelwe ukuthi ohlwini olungezansi kohlu olusezingeni elishisayo, uphawu olulodwa luzosebenza njengophawu olubonisa inhlanganisela yokhiye. Uma kwenzeka kuchaziwe uphawu lwe- "++" - lokhu kusho ukuthi kwikhibhodi udinga ukucindezela ukhiye we- "+" kanye nolunye ukhiye, olukhonjisiwe. Igama lezikhiye zokusebenza likhonjiswa njengoba zibizwa ngokuthi yikhibhodi: F1, F2, F3, njll.Futhi, kufanele kushiwo ukuthi isidingo sokuqala sokucindezela izinkinobho zensiza. Lokhu kufaka phakathi ukuhamba, i-CTRL ne-ALT. Futhi ngemuva, ukubamba lezi zikhiye, cindezela okhiye bokusebenza, izinkinobho ngezinhlamvu, izinombolo, nezinye izinhlamvu.
Izilungiselelo ezijwayelekile
Izinsimbi ezijwayelekile zeMicrosoft ziyizici eziyisisekelo zohlelo: ukuvula, ukonga, ukudala ifayela, njll. Izinkinobho ezishisayo ezinikeza ukufinyelela kulemisebenzi imi ngalendlela elandelayo:
- I-CTRL + N - Ukudala ifayela;
- I-CTRL + S - Ukulondolozwa kwencwadi;
- I-F12 - Ukukhetha kwefomethi nendawo yencwadi ukusindisa;
- I-CTRL + O - Ukuvula incwadi entsha;
- I-CTRL + F4 - Ukuvalwa kwencwadi;
- I-CTRL + P - Ukubuka kuqala;
- I-CTRL + A ukugqamisa lonke ishidi.
Okhiye be-Navigation
Ukuhamba eshidini noma incwadi, kukhona nezinkinobho ezishisayo.
- I-CTRL + F6 - ukunyakaza phakathi kwezincwadi eziningana ezivulekile;
- Ithebhu - ukunyakaza esitokisini esilandelayo;
- I-Shift + ithebhu - ukunyakaza esitokisini esedlule;
- Ikhasi phezulu - ukunyakaza ngosayizi womqaphi;
- Ikhasi phansi - ukunyakaza phansi kusayizi womqaphi;
- Ikhasi le-CTRL + likhuphuka - ukunyakaza eshidini langaphambili;
- Ikhasi le-CTRL + ekhasini phansi - ukunyakaza eshidini elilandelayo;
- I-CTRL + End - ukunyakaza esitokisini sokugcina;
- I-Ctrl + Ikhaya - ukunyakaza kuseli lokuqala.
Izinkinobho ezishisayo zemisebenzi yekhompyutha
I-Microsoft Excel ayisetshenziselwa ukwakhiwa okulula kwetafula kuphela, kodwa futhi nezenzo ze-computational kuzo, ngokufaka amafomula. Ukufinyelela okusheshayo kulezi zenzo, kukhona ama-hotkeys afanele.
- I-ALT + = - Ukwenza kusebenze kwe-avosumma;
- I-CTRL + ~ - Ibonisa imiphumela yokubalwa kumaseli;
- I-F9 - Ukubuyiselwa kabusha kwawo wonke amafomula kufayela;
- I-Shift + F9 - Ukubuyiselwa kabusha kwamafomula eshidini elisebenzayo;
- I-Shift + F3 - Imisebenzi yeWizard ye-Call.
Ukulungiswa kwephutha
Izinkinobho ezishisayo eziklanyelwe ukuhlela idatha ikuvumela ukuthi ugcwalise itafula ngolwazi ngokushesha.
- I-F2 - Imodi yokuhlela yeseli elimakiwe;
- I-CTRL ++ - Ukungeza amakholomu noma imigqa;
- I-CTRL + - - Susa amakholomu akhethiwe noma imigqa ephepheni le-Microsoft Excel Table;
- I-CTRL + Delete - isusa umbhalo okhethiwe;
- I-CTRL + H - Sesha / Faka esikhundleni iwindi;
- I-CTRL + Z - Khansela isenzo esenziwe ngabokugcina;
- I-Ctrl + Alt + V ingukufaka okukhethekile.
Ukufometha
Enye yezinto ezibalulekile zamatafula namabanga weseli ukufometha. Ngaphezu kwalokho, ukufometha kuthinta nezinqubo zekhompyutha ku-Excel.
- I-Ctrl + Shift +% - ukufakwa kwefomethi yamaphesenti;
- I-Ctrl + Shift + $ - ifomethi yenkulumo yezimali;
- I-Ctrl + Shift + # - Ifomethi yosuku;
- I-Ctrl + Shift +! - Uhlobo lwezinombolo;
- I-Ctrl + Shift + ~ - ifomethi ejwayelekile;
- I-CTRL + 1 - Ukwenza kusebenze ngefasitela lokufometha kweseli.
Amanye ama-hotkeys
Ngaphezu kwezinkinobho ezishisayo ezazibhalwe kumaqembu angenhla, uhlelo lokusebenza lwe-Excel lunezinhlanganisela ezibalulekile zezinkinobho zekhibhodi kukhibhodi ukubiza imisebenzi:
- I-ALT + '- Ukukhetha isitayela sokwakha;
- F11 - Ukwakha umdwebo eshidini elisha;
- I-Shift + F2 - Shintsha amazwana esitokisini;
- F7 - Bheka umbhalo wamaphutha.
Vele, akuzona konke ukusetshenziswa kwezinkinobho ezishisayo ezinhlelweni zeMicrosoft Excel zethulwe ngenhla. Noma kunjalo, saqothula ukunakwa okuthandwa kakhulu, okuwusizo, futhi okufunwa nakho. Vele, ukusetshenziswa kwezinkinobho ezishisayo kuyakwazi ukwenza lula kakhulu futhi kusheshise uhlelo lwe-Microsoft Excel.