Don sauƙaƙe aikin akan aikin, Excel hotkeys koyaushe zai taimaka. Duk lokacin da kuka yi amfani da su, zai fi dacewa a gare ku a shirya kowane tebur.
Gajerun hanyoyin Faifan Maɓalli
Lokacin aiki tare da Excel, ya dace mu yi amfani da gajerun hanyoyin keyboard maimakon madubi. Mai tsara tebur na shirin ya ƙunshi ayyuka da yawa da damar aiki tare da ko da mafi rikitattun tebur da takardu. Ofaya daga cikin manyan maɓallan zai zama Ctrl, yana samar da haɗuwa masu amfani tare da duk sauran.
Ta amfani da gajerun hanyoyin keyboard a cikin Excel, zaku iya buɗewa, rufe zanen gado, kewaya wani takarda, yin lissafi, da ƙari mai yawa
Idan ba ku yin aiki a cikin Excel a koyaushe, to zai fi kyau kada ku ɓata lokacin koyo da kuma tuna maɓallan wuta.
Tebur: haɗuwa mai amfani a cikin Excel
| Gajeriyar hanyar faifan maɓalli | Wane irin aiki za a yi |
| Ctrl + Share | An share rubutu da aka zaɓa |
| Ctrl + Alt + V | Sigar musamman tana faruwa |
| Alamar Ctrl + | An ƙidaya layuka da layuka da aka ambata. |
| Alamar Ctrl + - | An zaɓi ginshiƙan layuka ko layuka. |
| Ctrl + D | Rangearancin yana cike da bayanai daga sel da aka zaɓa |
| Ctrl + R | Kewayon da ke hannun dama yana cike da bayanai daga sel da aka zaɓa. |
| Ctrl + H | Wurin Binciko-Sauya yana bayyana. |
| Ctrl + Z | An soke aikin ƙarshe. |
| Ctrl + Y | An maimaita matakin karshe |
| Ctrl + 1 | Magana akan shirya edita akan wayar salula zai bude. |
| Ctrl + B | Rubutun yayi haske |
| Ctrl + I | Italic saitin |
| Ctrl + U | Rubutun ya ja layi a ƙarƙashin. |
| Ctrl + 5 | Nuna rubutu mai zurfi. |
| Ctrl + Shigar | An zaɓi duk ƙwayoyin. |
| Ctrl +; | An nuna kwanan wata |
| Ctrl + Shift +; | Lokaci ya buga |
| Ctrl + Backspace | Maɓallin sigari ya koma cikin sel ɗin da ya gabata. |
| Ctrl + Sarari | Gurbin ya fice |
| Ctrl + A | Abubuwan bayyane suna alamta. |
| Ctrl + .arshe | Ana sanya siginan kwamfuta akan sel na ƙarshe. |
| Ctrl + ftaura + .are | An inganta ƙwayar ƙarshe |
| Ctrl + kibiyoyi | Mawaƙin yana motsawa tare da gefuna na allon a cikin shugabanin kibiyoyi. |
| Ctrl + N | Wani sabon faren littafi ya bayyana |
| Ctrl + S | An adana takarda |
| Ctrl + O | Akwatin bincika fayil ɗin da ake so ya buɗe. |
| Ctrl + L | Yanayin tebur mai Smart yana farawa |
| Ctrl + F2 | Gabatar da kallo |
| Ctrl + K | Hyperlink an saka |
| Ctrl + F3 | Sunan Mai gabatarwa |
Jerin abubuwan haɗin Ctrl-free don aiki a cikin Excel shima ya burge sosai:
- F9 zai fara fara amfani da dabarun farashi, kuma a hade tare da Shift din zai yi wannan ne kawai a takardar da ake gani;
- F2 zai kira edita don takamaiman sel, kuma an haɗa shi da Shift - bayanin kula;
- dabara "F11 + Shift" zai ƙirƙiri sabon takarda mara lahani;
- Alt tare da ftaura da kibiya dama za su tattara duk abin da aka zaɓa. Idan kibiya ta nuna zuwa hagu, to rashin hada taro zai faru;
- Alt tare da kibiya mai saukarwa zata buɗe jerin zaɓin-kwayar sel da aka ƙayyade;
- za a yi layin sakawa ta latsa Alt + Shigar;
- Ftaura tare da sarari zai haskaka jere a kan tebur.
Hakanan kuna iya yin mamakin wane gajerun hanyoyin keyboard zaku iya amfani dasu a Photoshop: //pcpro100.info/goryachie-klavishi-fotoshop/.
Fan yatsu, da zarar sunsan wurin maɓallan sihirin, za su kuɓutar da idanunku don yin aiki a kan takaddar. Sannan saurin ayyukan kwamfutarka zai zama da sauri.
