I-hotkeys yinto eyenza ukuthi, ngokuthayipha inhlanganisela eyinhloko ekhibhodi, inikeza ukufinyelela okusheshayo kwezinye izici zesistimu yokusebenza, noma uhlelo oluhlukile. Leli thuluzi liyatholakala ku-Microsoft Excel. Ake sithole ukuthi yikuphi ukushisa okuse-Excel, nokuthi ungenzani nabo.
Ulwazi jikelele
Okokuqala, kufanele kuqashelwe ukuthi kuhlu lwamakhi abashisayo aboniswe ngezansi, uphawu olulodwa "+" luyoba uphawu olubonisa ukusho kwekhibhodi. Uma ngabe isibonakaliso "++" sibonisiwe - lokhu kusho ukuthi kwikhibhodi udinga ukucindezela ukhiye "+" kanye nomunye ukhiye obonisiwe. Igama lezinkinobho zomsebenzi liboniswa njengoba zibizwa ngekhibhodi: F1, F2, F3, njll.
Futhi, kufanele kuthiwe isidingo sokuqala sokucindezela izinkinobho zesevisi. Lezi zihlanganisa Shift, Ctrl ne-Alt. Futhi emva kwalokho, ngenkathi ubamba lezi zihluthulelo, cindezela okhiye womsebenzi, izinkinobho ezinamagama, izinombolo, nezinye izimpawu.
Izilungiselelo Ezijwayelekile
Amathuluzi okuphatha jikelele weMicrosoft afaka izici eziyisisekelo zalolu hlelo: ukuvula, ukulondoloza, ukudala ifayela, njll. Izinkinobho ezishisayo ezihlinzeka ukufinyelela kule misebenzi zilandelayo:
- Ctrl + N - dala ifayela;
- Ctrl + S - londoloza le ncwadi;
- F12 - khetha ifomethi nendawo yencwadi ukuze ulondoloze;
- Ctrl + O - ukuvula incwadi entsha;
- Ctrl + F4 - vala incwadi;
- Ctrl + P - ukuphrinta kuqala kokuphrinta;
- Ctrl + A - khetha lonke ishidi.
Izinkinobho zokuhamba
Ukuze ufunde ishidi noma ibhuku, futhi, zinezinkinobho zabo ezishisayo.
- Ctrl + F6 - ukuhamba phakathi kwezincwadi eziningana ezivulekile;
- Ithebhu - thuthela kuseli elilandelayo;
- Shift + ithebhu - thuthela esitokisini sangaphambilini;
- Ikhasi Phezulu - phakamisa ubukhulu bomqapha;
- Ikhasi eliphansi - hamba phansi ukuhlola usayizi;
- Ctrl + Ikhasi Phezulu - thuthela kuhlu oludlule;
- Ctrl + Ikhasi phansi - thuthela eshadini elilandelayo;
- Ctrl + End - thuthela esitokisini sokugcina;
- Ikhaya leCtrl + - hamba esitokisini sokuqala.
Ama-hotkeys okwenza imisebenzi yekhompyutha
I-Microsoft Excel ayisetshenziselwa ukwakhiwa okulula kwamathebula, kodwa futhi nezenzo zekhompyutha, ngokufaka amafomula. Ukuze uthole ukufinyelela okusheshayo kulezi zenzo, kukhona izinkinobho ezishisayo ezihambisanayo.
- I-Alt + = - i-avtosummy yokusebenza;
- Ctrl + ~ - ukubonisa imiphumela yokubala kumaseli;
- F9 - ukulungisa kabusha wonke amafomula efayela;
- Shift + F9 - ukulungiswa kabusha kwamafomula kushidi elisebenzayo;
- Shift + F3 - shayela idijithali yomsebenzi.
Ukuhlela idatha
Ama-hotkeys wokuhlela idatha akuvumela ukuba ugcwalise ngokushesha itafula ngolwazi.
- I-F2 - hlela imodi yeseli ekhethiwe;
- Ctrl ++ - engeza amakholomu noma imigqa;
- I-Ctrl + - - isusa amakholomu akhethiwe noma imigqa kushidi lethebula le-Microsoft Excel;
- Ctrl + Susa - susa umbhalo okhethiwe;
- I-Ctrl + H - Sesha / Shintsha iwindi;
- Ctrl + Z - hlela isenzo esenziwe okokugcina;
- Ctrl + Alt + V - Faka okukhethekile.
Ukufometha
Esinye sezici ezibalulekile zokuklama zamatafula namabanga wamaseli ukufometha. Ukwengeza, ukufometha nakho kuthinta izinqubo zokucubungula ku-Excel.
- Ctrl + Shift +% - kufakwa ifomethi yephesenti;
- I-Ctrl + Shift + $ - ifomethi yezindleko zemali;
- I-Ctrl + Shift + # - ifomethi yosuku;
- Ctrl + Shift +! - ifomethi yezinombolo;
- Ctrl + Shift + ~ - ifomethi evamile;
- I-Ctrl + 1 - isebenza iwindi yokufometha yeseli.
Amanye ama-hotkeys
Ngaphezu kokushisa okubekwe kuhlu kumaqembu angenhla, i-Excel inezinhlanganisela ezilandelayo eziyinhloko ekhibhodi yemisebenzi yokubiza:
- Alt + '- ukukhetha isitayela;
- F11 - ukudala ishadi kushidi elisha;
- Shift + F2 - shintsha amazwana esitokisini;
- F7 - ukuhlola umbhalo ngamaphutha.
Yiqiniso, akuzona zonke izinketho zokusebenzisa okhiye abashisayo ku-Microsoft Excel zinikezwe ngenhla. Noma kunjalo, sasiqaphele okuthandwa kakhulu, okuwusizo, nokufunwa kubo. Yiqiniso, ukusetshenziswa kwezinkinobho ezishisayo kungenza kube lula nokusheshisa umsebenzi ku-Microsoft Excel.
