Okuqukethwe
- Uhlolojikelele
- Izinqamuleli zekhibhodi ezisetshenziswa njalo
- Izinqamuleli zekhibhodi zeRibhoni
- Ukusebenzisa Okhiye Bokungena Kumathebhu eRibhoni
- Ukusebenza ngamathebhu weribhoni usebenzisa ikhibhodi
- Izinqamuleli zekhibhodi zokufometha kweseli
- Izinqamuleli zekhibhodi ebhokisini lengxoxo Namathisela Okukhethekile ku-Excel 2013
- Izinqamuleli zekhibhodi zezenzo nezinketho
- Izinqamuleli zekhibhodi zokusebenza ngedatha, imisebenzi, nebha yefomula
- Izinqamuleli zekhibhodi ku-Power Pivot
- Izinqamuleli zekhibhodi kokuthi izengezo ze-Office
- Okhiye bokusebenza
- Ezinye izinqamuleli zekhibhodi eziwusizo
- Isiphetho
Ama-hotkeys ayisici esikhethekile somhleli wespredishithi esikuvumela ukuthi uthole ukufinyelela okusheshayo emisebenzini ethile. Kulesi sihloko, sizobhekana ngokuningiliziwe ngalokho iphrosesa yesipredishithi inamakhi ashisayo, futhi yiziphi izinqubo ezingasetshenziswa nazo.
Uhlolojikelele
Ekuqaleni, phawula ukuthi uphawu lokuhlanganisa "+" lubonisa inhlanganisela yezinkinobho. Okubili okufana no-“++” ngokulandelana kusho ukuthi u-“+” kufanele ucindezelwe kanye nomunye ukhiye kukhibhodi. Okhiye besevisi yizinkinobho okufanele zicindezelwe kuqala. Izinsiza zihlanganisa: Alt, Shift, kanye Ctrl.
Izinqamuleli zekhibhodi ezisetshenziswa njalo
Okokuqala, ake sihlaziye izinhlanganisela ezidumile:
| SHIFT+TAB | Buyela kunkambu yangaphambilini noma isilungiselelo sokugcina efasiteleni. |
| I-ARROW ↑ | Hambisa ohlangothini olungaphezulu ngenkambu engu-1 yeshidi. |
| I-ARROW ↓ | Iya ohlangothini olungezansi ngenkambu engu-1 yeshidi. |
| I-ARROW ← | Hambisa ohlangothini lwesobunxele ngenkambu engu-1 yeshidi. |
| I-ARROW → | Yisa kwesokudla ngenkambu engu-1 yeshidi. |
| CTRL + inkinobho yomcibisholo | Yiya ekugcineni kwendawo yolwazi eshidini. |
| END, inkinobho yomcibisholo | Ihambisa kumsebenzi obizwa ngokuthi "Qeda". Ikhubaza umsebenzi. |
| CTRL+END | Hamba uye endaweni eqediwe eshidini. |
| CTRL+SHIFT+END | Sondeza indawo emakiwe kuseli lokugcina elisetshenzisiwe. |
| IKHAYA+USkrola | Hambisa kuseli etholakala ekhoneni eliphezulu kwesokunxele lendawo. |
| EHLA NGEKHASI | Hambisa isikrini esi-1 phansi kweshidi. |
| CTRL+PAGE PHANSI | Hambisa kwelinye ishidi. |
| ALT+PAGE PHANSI | Hambisa isikrini esingu-1 kwesokudla eshidini. |
| IPHEPHA | Hambisa isikrini esingu-1 phezulu eshidini. |
| ALT+PAGE UP | Hambisa isikrini esingu-1 kwesokunxele eshidini. |
| CTRL+PAGE UP | Buyela eshidini langaphambilini. |
| I-TAB | Hambisa inkambu engu-1 kwesokudla. |
| ALT+ARROW↓ | Nika amandla uhlu lokuhlola inkambu. |
| I-CTRL+ALT+5 ilandelwa ukucindezela okumbalwa kwe-TAB | Ushintsho phakathi kobumo obunyakazayo (umbhalo, izithombe, nokunye). |
| I-CTRL + SHIFT | Ukuskrola ovundlile. |
Izinqamuleli zekhibhodi zeRibhoni
Ukucindezela okuthi “ALT” kubonisa inhlanganisela yezinkinobho kubha yamathuluzi. Lesi iseluleko kubasebenzisi abangakawazi wonke ama-hotkeys.
Ukusebenzisa Okhiye Bokungena Kumathebhu eRibhoni
| KONKE, F | Ukungena esigabeni "Ifayela" nokusebenzisa i-Backstage. |
| ALT, I | Ukungena esigabeni "Ekhaya", ukufometha umbhalo noma ulwazi lwezinombolo. |
| KONKE, С | Ukungena engxenyeni ethi "Faka" bese ufaka izici ezihlukahlukene. |
| I-ALT + P | Ingena esigabeni "Isakhiwo Sekhasi". |
| ALT, L | Ingena esigabeni "Amafomula". |
| I-ALT + | Ukufinyelela esigabeni "Idatha". |
| I-ALT + R | Ukufinyelela esigabeni esithi “Ababuyekezi”. |
| I-ALT+О | Ukufinyelela esigabeni esithi "Buka". |
Ukusebenza ngamathebhu weribhoni usebenzisa ikhibhodi
| I-F10 noma i-ALT | Khetha isigaba esisebenzayo kubha yamathuluzi bese unika amandla izinkinobho zokufinyelela. |
| SHIFT+TAB | Zulazulela kumiyalo yeribhoni. |
| Izinkinobho zomcibisholo | Ukunyakaza ngezindlela ezahlukene phakathi kwezingxenye ze-tape. |
| ENTER noma isikhala | Nika amandla inkinobho ekhethiwe. |
| I-ARROW ↓ | Ukudalulwa kohlu lweqembu esilikhethile. |
| ALT+ARROW ↓ | Ukuvula imenyu yenkinobho esiyikhethile. |
| I-ARROW ↓ | Shintshela emyalweni olandelayo efasiteleni elinwetshiwe. |
| CTRL + F1 | Ukugoqa noma ukuqaqa. |
| SHIFT+F10 | Ivula imenyu yokuqukethwe. |
| I-ARROW ← | Shintshela ezintweni zemenyu engaphansi. |
Izinqamuleli zekhibhodi zokufometha kweseli
| Ctrl + B | Nika amandla uhlobo olugqamile lolwazi. |
| Ctrl + I | Nika amandla uhlobo lolwazi olumalukeke. |
| Ctrl + U | Nika amandla ukudwebela. |
| I-Alt + H + H | Ukukhetha umbala wombhalo. |
| U-Alt+H+B | Ukwenza kusebenze uzimele. |
| U-Ctrl + Shift + & | Ukwenza kusebenze ingxenye yekhonta. |
| Ctrl + Shift + _ | Vala ozimele. |
| Ctrl + 9 | Fihla imigqa ekhethiwe. |
| Ctrl + 0 | Fihla amakholomu akhethiwe. |
| Ctrl + 1 | Ivula ifasitela Lefomethi Yeseli. |
| Ctrl + 5 | Nika amandla i-strikethrough. |
| Ctrl + Shift + $ | Ukusetshenziswa kwemali. |
| Ctrl + Shift +% | Ukusebenzisa iphesenti. |
Izinqamuleli zekhibhodi ebhokisini lengxoxo Namathisela Okukhethekile ku-Excel 2013
Le nguqulo yomhleli wespredishithi inesici esikhethekile esibizwa ngokuthi Namathisela Okukhethekile.
Okhiye abashisayo abalandelayo basetshenziswa kuleli windi:
| A | Yengeza konke okuqukethwe. |
| F | Yengeza amafomula. |
| V | Ukwengeza amanani. |
| T | Yengeza kuphela ukufometha koqobo. |
| C | Ukwengeza amanothi namanothi. |
| N | Yengeza izinketho zokuskena. |
| H | Yengeza amafomethi. |
| X | Ukungeza ngaphandle kwemingcele. |
| W | Ingeza ngobubanzi bangempela. |
Izinqamuleli zekhibhodi zezenzo nezinketho
| Shift + ARROW → / ← | Khulisa inkambu yokukhetha kwesokudla noma kwesokunxele. |
| Shift + Isikhala | Ukukhetha umugqa wonke. |
| Ctrl+Space | Ukukhetha ikholomu yonke. |
| Ctrl+Shift+Space | Ukukhetha ishidi lonke. |
Izinqamuleli zekhibhodi zokusebenza ngedatha, imisebenzi, nebha yefomula
| F2 | Ukushintsha kwenkundla. |
| Shift + F2 | Yengeza inothi. |
| Ctrl + X | Khipha ulwazi endaweni. |
| Ctrl + C | Ikopisha ulwazi kusuka endaweni. |
| Ctrl + V | Ukwengeza ulwazi oluvela ensimini. |
| I-Ctrl + Alt + V | Ivula iwindi elithi "Okunamathiselwe Okukhethekile". |
| Susa | Ukususa ukugcwaliswa kwenkundla. |
| I-Alt + Enter | Ukufaka imbuyiselo ngaphakathi kwenkambu. |
| F3 | Yengeza igama lenkambu. |
| U-Alt + H + D + C | Ikhipha ikholomu. |
| Esc | Khansela okufakiwe enkambini. |
| Faka | Ukugcwalisa okokufaka ensimini. |
Izinqamuleli zekhibhodi ku-Power Pivot
| I-PKM | Ivula imenyu yokuqukethwe. |
| I-CTRL + A | Ukukhetha ithebula lonke. |
| I-CTRL + D | Ukukhipha ibhodi lonke. |
| I-CTRL + M | Ehambisa ipuleti. |
| I-CTRL + R | Ukuqamba kabusha ithebula. |
| I-CTRL + S | Londoloza. |
| I-CTRL + Y | Ukuphindwaphindwa kwenqubo yangaphambilini. |
| I-CTRL + Z | Ukubuya kwenqubo eyedlulele. |
| F5 | Ivula iwindi elithi "Go". |
Izinqamuleli zekhibhodi kokuthi izengezo ze-Office
| CTRL SHIFT + F10 | Ukuvulwa kwemenyu. |
| CTRL+SPACE | Ukudalulwa kwenkambu yemisebenzi. |
| CTRL+SPACE bese uchofoza okuthi Vala | Vala inkambu yomsebenzi. |
Okhiye bokusebenza
| F1 | Nika usizo amandla. |
| F2 | Ukuhlela iseli ekhethiwe. |
| F3 | Hambisa ebhokisini elithi "Igama ekugcineni". |
| F4 | Iphinda isenzo sangaphambilini. |
| F5 | Yiya efasiteleni elithi "Hamba". |
| F6 | Ushintsho phakathi kwezinto zomhleli wethebula. |
| F7 | Ivula iwindi elithi "Spelling". |
| F8 | Yenza kusebenze ukukhetha okunwetshiwe. |
| F9 | Ukubala amashidi. |
| F10 | Yenza amacebo asebenze. |
| F11 | Yengeza ishadi. |
| F12 | Yiya efasiteleni elithi "Londoloza Njenge". |
Ezinye izinqamuleli zekhibhodi eziwusizo
| Alt+' | Ivula iwindi lokuhlela isitayela seseli. |
| IPHUPHO
| Isusa uhlamvu. |
| Faka | Ukuphela kwesethi yedatha. |
| ESC | Khansela isethi. |
| IKHAYA | Buyela ekuqaleni kweshidi noma umugqa. |
Isiphetho
Yebo, kukhona abanye okhiye abashisayo kusihleli sespredishithi. Sibuyekeze izinhlanganisela ezidume kakhulu nezisetshenziswa kakhulu. Ukusetshenziswa kwalaba khiye kuzosiza abasebenzisi ukuthi basebenze ngokushesha kakhulu kusihleli sesipredishithi.