Contents
- Guudmarka
- Jidadka gaagaaban ee inta badan la isticmaalo kiiboodhka
- Jid-gaabyada kiiboodhka ee Ribbon-ka
- Isticmaalka Furayaasha Helitaanka ee Tabaha Ribbon
- Ku shaqaynta ribbon tabs iyadoo la isticmaalayo kiiboodhka
- Hababka gaagaaban ee kiiboodhka qaabaynta unugga
- Hababka gaagaaban ee kiiboodhka ee ku dheji sanduuqa wada hadalka gaarka ah ee Excel 2013
- Hababka gaagaaban ee kiiboodhka ee ficilada iyo xulashada
- Hababka gaagaaban ee kiiboodhka ee ku shaqaynta xogta, hawlaha, iyo bar qaacidada
- Jidadka kiiboodhka ee Power Pivot
- Jid-gaabyada kiiboodhka ee ku-darka Xafiiska
- Furayaasha Waxqabadka
- Jid-gaabyada kiiboodhka kale ee waxtarka leh
- Ugu Dambeyn
Hotkeys waa muuqaal gaar ah oo tafatiraha xaashida faafinta ah kaas oo kuu ogolaanaya inaad si degdeg ah u gasho hawlaha qaarkood. Maqaalka, waxaan si faahfaahsan uga hadli doonaa waxa processor-ka faafinta uu leeyahay furayaal kulul, iyo hababka lagu fulin karo iyaga.
Guudmarka
Marka hore, ogow in calaamadda lagu daray "+" ay tilmaamayso badhamada la isku daray. Laba "++" oo isku xigta waxay ka dhigan tahay "+" waa in la wada riixaa iyada oo fure kale uu ku jiro kiiboodhka. Furayaasha adeegu waa badhamada ay tahay in marka hore la riixo. Adeegyada waxaa ka mid ah: Alt, Shift, iyo sidoo kale Ctrl.
Jidadka gaagaaban ee inta badan la isticmaalo kiiboodhka
Marka hore, aan falanqeyno isku-dhafka caanka ah:
SHIFT+TAB | Ku laabo goobtii hore ama goobta ugu danbeysa ee daaqada. |
ARROW ↑ | U dhaqaaq dhinaca sare ee 1 beer ee xaashida. |
ARROW ↓ | U dhaqaaq dhinaca hoose 1 beer ee xaashida. |
ARROW ← | U dhaqaaq dhanka bidix 1 beer ee xaashida. |
ARROW → | U dhaqaaq dhanka midig 1 beer ee xaashida. |
CTRL + badhanka fallaadha | U gudub dhamaadka aagga macluumaadka xaashida. |
DHAMMAAD, badhanka fallaadha | U guurista hawl la yiraahdo "End". Joojinta shaqada |
CTRL+ DHAMMAAD | U guuri garoonka la dhammeeyay ee xaashida. |
CTRL+SHIFT+DHAMMAAD | Ku soo dhawee aagga la calaamadeeyay unugii ugu dambeeyay ee la codsado. |
GURIGA+GURI QOFKA | U dhaqaaq qolka ku yaal geeska bidix ee sare ee aagga. |
KII PAGE | 1 shaashad ka soo deji xaashida. |
CTRL+BOGGA HOOSE | U guuro xaashi kale. |
ALT+BOGGA HOOSE | U dhaqaaq 1 shaashad dhanka midig ee xaashida. |
PAGE UP | Kor u qaad 1 shaashad xaashida. |
ALT+BOGGA KOR | U dhaqaaq 1 shaashad dhanka bidix ee xaashida. |
CTRL+BOGGA KOR | Ku noqo xaashidii hore. |
TAB | U dhaqaaq 1 garoon dhanka midig |
ALT+Arrow↓ | U oggolow liiska hubinta ee goobta. |
CTRL+ALT+5 oo ay ku xigto dhawr taab oo TAB ah | Kala-guurka u dhexeeya qaababka dhaqaaqa (qoraal, sawiro, iyo wixii la mid ah). |
CTRL + SHIFT | rogrogid toosan. |
Jid-gaabyada kiiboodhka ee Ribbon-ka
Marka la riixo "ALT" waxa ay soo bandhigaysaa isku-darka badhamada ku yaala aaladda. Tani waxay tilmaam u tahay isticmaalayaasha aan weli aqoon dhammaan furayaasha kulul.
Isticmaalka Furayaasha Helitaanka ee Tabaha Ribbon
DHAMAAN, F | Gelida qaybta "File" oo aad dabaqa Backstage. |
ALT, I | Gelitaanka qaybta "Guriga", qaabaynta qoraalka ama macluumaadka tirada. |
WAX KASTA, С | Gelida qaybta " Gelida " oo gelisa walxo kala duwan. |
ALT+P | Gelida qaybta "Layout Page" |
ALT, L | Ku dhaji qaybta "Formulas". |
ALT + | Gelitaanka qaybta "Data". |
ALT+R | Gelitaanka qaybta "Reviewers" |
ALT+О | Gelida qaybta "View" |
Ku shaqaynta ribbon tabs iyadoo la isticmaalayo kiiboodhka
F10 ama ALT | Dooro qaybta firfircoon ee aaladda oo awood badhamada gelitaanka |
SHIFT+TAB | U gudub amarrada ribbon |
Badhanka fallaaraha | Dhaqdhaqaaqa jihooyin kala duwan oo u dhexeeya qaybaha cajaladda. |
Geli ama meel bannaan | Daar badhanka la doortay. |
ARROW ↓ | Shaacinta liiska kooxda aan dooranay. |
ALT+Arrow ↓ | Furitaanka menu ee badhanka aan doorannay. |
ARROW ↓ | U beddel amarka xiga ee daaqada la fidiyey. |
CTRL + F1 | Laabi ama kala bixid. |
SHIFT+F10 | Furitaanka macnaha guud |
ARROW ← | U beddel shayada liiska-hoosaadka. |
Hababka gaagaaban ee kiiboodhka qaabaynta unugga
Ctrl + B | Daree nooca macluumaadka geesinimada leh. |
Ctrl + I | Daar xogta farta fargeetada ah |
Ctrl + U | Daree hoosta ka xarriiqda |
Alt + H + H | Doorashada midabka qoraalka. |
Alt+H+B | Dhaqdhaqaaqa qaab-dhismeedka |
Ctrl + Shift + & | Firfircoonida qaybta contour. |
Ctrl + Shift + _ | Dami xargaha. |
CTRL+9 | Qari khadadka la doortay. |
CTRL+0 | Qari tiirarka la doortay |
CTRL+1 | Wuxuu furaa daaqada Qaabka Unugyada |
CTRL+5 | Daar ku dhufashada |
Ctrl + Shift + $ | Isticmaalka lacagta. |
Ctrl + Shift +% | Isticmaalka boqolleyda |
Hababka gaagaaban ee kiiboodhka ee ku dheji sanduuqa wada hadalka gaarka ah ee Excel 2013
Noocan tifaftiraha xaashida xaashida ayaa leh sifo gaar ah oo la yiraahdo Paste Special.
Furayaasha soo socda ayaa lagu isticmaalaa daaqadan:
A | Ku darida dhammaan nuxurka |
F | Ku darida qaacidooyinka. |
V | Ku darida qiyamka. |
T | Ku darida qaabaynta asalka ah kaliya. |
C | Ku darida qoraalo iyo qoraalo. |
N | Ku darida ikhtiyaarada iskaanka |
H | Ku darista qaabab |
X | Ku darida bilaa xuduud. |
W | Ku darida ballac asalka ah. |
Hababka gaagaaban ee kiiboodhka ee ficilada iyo xulashada
Shift + Arrow → / ← | Kordhi goobta xulashada midig ama bidix. |
Shift + Space | Doorashada khadka oo dhan. |
Ctrl+Space | Doorashada tiirka oo dhan. |
Ctrl+Shift+Space | Doorashada xaashida oo dhan. |
Hababka gaagaaban ee kiiboodhka ee ku shaqaynta xogta, hawlaha, iyo bar qaacidada
F2 | Isbeddelka goobta. |
Wareejinta + F2 | Ku darida qoraal. |
Ctrl + X | Ka jar macluumaadka goobta. |
Ctrl + C | Ka koobiyaynta macluumaadka goobta |
Ctrl + V | Ku darida macluumaadka goobta. |
Ctrl + Alt + V | Furitaanka daaqadda "Lifaaqa Gaarka ah". |
delete | Ka saarida buuxinta goobta. |
Alt + Gal | Gelida soo celinta gudaha garoonka. |
F3 | Ku darida magac goob |
Alt + H + D + C | Ka saarida tiir. |
Esc | Jooji gelida garoonka |
Ku qor | Buuxinta gelinta goobta. |
Jidadka kiiboodhka ee Power Pivot
PKM | Furitaanka macnaha guud |
CTRL + A. | Doorashada miiska oo dhan. |
CTRL + D | Ka saarida looxa oo dhan. |
CTRL+M | Dhaqdhaqaaqa saxanka. |
Ctrl+R | Magacaabida miiska |
CTRL+S | Badbaadi. |
CTRL+Y | Isku dhufashada habraacii hore. |
CTRL+Z | Soo celinta nidaamka xad dhaafka ah. |
F5 | Furitaanka daaqadda "Go". |
Jid-gaabyada kiiboodhka ee ku-darka Xafiiska
Ctrl + wareejin + F10 | Furitaanka menu |
CTRL+SPACE | Shaacinta goobta hawlaha. |
CTRL+SPACE ka dibna dhagsii Close | Xidh goobta hawsha |
Furayaasha Waxqabadka
F1 | Daar caawimada |
F2 | Tafatirka unugga la doortay. |
F3 | U dhaqaaq sanduuqa "Magaca dhamaadka". |
F4 | Ku celcelinta falkii hore |
F5 | Tag daaqada "Go". |
F6 | Kala-guurka u dhexeeya walxaha tafatiraha miiska. |
F7 | Furitaanka daaqadda "Higgaadda". |
F8 | Daar doorashada la dheereeyey |
F9 | Tirinta xaashida |
F10 | Daar tilmaamaha |
F11 | Ku darida jaantus |
F12 | Tag daaqada "Save As" |
Jid-gaabyada kiiboodhka kale ee waxtarka leh
Alt+' | Wuxuu furaa daaqada habaynta unugga |
BACKSPACE
| Tirtirka jilaa |
Ku qor | Dhamaadka xogta. |
ESC | Dejinta jooji |
HOME | Ku laabo bilawga xaashida ama laynka. |
Ugu Dambeyn
Dabcan, waxaa jira furayaal kale oo kulul oo ku jira tifaftiraha xaashida. Waxaan dib u eegnay isku darka ugu caansan uguna isticmaalka badan. Isticmaalka furayaashan ayaa ka caawin doona isticmaalayaasha inay si degdeg ah ugu shaqeeyaan tifaftiraha xaashida.