Ukwenza lula umsebenzi kuphrojekthi, ama-hotkeys e-Excel azohlala esiza. Uma usebenzisa zona kaningi, kuzoba lula ukuthi uhlele noma imaphi amatafula.
Amashothikhathi ekhibhodi e-Excel
Lapho usebenza ne-Excel, kulula ukusebenzisa izinqamuleli zekhibhodi esikhundleni segundwane. Iprosesa lethebula lo hlelo lifaka imisebenzi eningi namandla okusebenza kwamatafula nezincwadi eziyinkimbinkimbi kakhulu. Enye yezikhiye eziphambili kuzoba yi-Ctrl, yakha inhlanganisela ewusizo nabo bonke abanye.
![](http://img.eifeg.com/img/pcpr-2019/10450/excel.png)
Usebenzisa izinqamuleli zekhibhodi ku-Excel, ungavula, uvale amashidi, uzungeze idokhumenti, wenze izibalo, nokuningi
Uma ungasebenzi ku-Excel ngaso sonke isikhathi, kungcono ukungachithi isikhathi sakho ufunda futhi ukhumbule izinkinobho ezishisayo.
Ithebula: inhlanganisela ewusizo e-Excel
Isinqamuleli sekhibhodi | Yisiphi isenzo esizokwenziwa |
Ctrl + Susa | Umbhalo okhethiwe uyasuswa. |
I-Ctrl + Alt + V | Ukufakwa okukhethekile kwenzeka |
ICtrl + sign + | Amakholomu nezinsimbi ezichaziwe ayengeziwe. |
ICtrl + uphawu - | Amakholomu akhethiwe noma imigqa isusiwe. |
I-Ctrl + D | Ibanga elingaphansi ligcwele imininingwane evela kuseli elikhethiwe |
I-Ctrl + R | Ibanga ngakwesokunene ligcwele imininingwane evela kuseli elikhethiwe. |
I-Ctrl + H | Kuvela iwindi lokusesha-esikhundleni. |
I-Ctrl + Z | Isenzo sokugcina sikhanseliwe. |
I-Ctrl + Y | Isenzo sokugcina siphindwe |
I-Ctrl + 1 | Ingxoxo yomhleli weseli iyavulwa. |
I-Ctrl + B | Umbhalo unesibindi |
I-Ctrl + I | Isethali esetshenzisiwe |
I-Ctrl + U | Umbhalo udwetshiwe. |
I-Ctrl + 5 | Umbhalo ogqanyisiwe ukhishwa. |
I-Ctrl + Faka | Wonke amaseli akhethiwe. |
I-Ctrl +; | Kuboniswa usuku |
I-Ctrl + Shift +; | Isikhathi sigciniwe |
I-Ctrl + Backspace | Isikhombisi sibuyele kwiseli edlule. |
I-Ctrl + Space | Ikholomu ivelele |
I-Ctrl + A | Izinto ezibonakalayo ziyaqokonyiswa. |
I-Ctrl + Ekupheleni | Isikhombisi sibekwe esitokisini sokugcina. |
I-Ctrl + Shift + End | Kuqokonyiswa iseli lokugcina |
I-Ctrl + Arrows | Isikhombisi sihamba emaphethelweni ekholamu maqondana nemicibisholo. |
I-Ctrl + N | Kuvela incwadi entsha engenalutho |
I-Ctrl + S | Idokhumenti igciniwe |
I-Ctrl + O | Ibhokisi lokucinga lefayela elifunekayo liyavula. |
I-Ctrl + L | Imodi yetafula le-Smart iyaqala |
I-Ctrl + F2 | Ukubuka kuqala kufakiwe |
I-Ctrl + K | I-Hyperlink ifakiwe |
I-Ctrl + F3 | Kwethulwa umphathi wegama |
Uhlu lokuhlanganiswa kwamahhala kwe-Ctrl olusebenza e-Excel nalo luyamangaza:
- I-F9 izoqala ukuphinda ibalwe amafomula, futhi ngokuhlangana neShift kuzokwenza lokhu kuphela ephepheni elibonakalayo;
- I-F2 izoshayela umhleli ngeseli ethile, futhi ibhanqwe neShift - amanothi ayo;
- ifomula "F11 + Shift" izodala ishidi elingenalutho;
- I-Alt kanye ne-Shift nomcibisholo ongakwesokudla bazohlanganisa konke okukhethiwe. Uma umcibisholo ukhomba ngakwesobunxele, khona-ke ukungahleleki kuzokwenzeka;
- I-alt ngomcibisholo ophansi izovula uhlu olwehlayo lweseli elicacisiwe;
- ukugoqa umugqa kuzokwenziwa ngokucindezela u-Alt + Enter;
- I-Shift enesikhala izogqamisa umugqa wethebula.
Kungenzeka futhi uzibuze ukuthi yiziphi izinqamuleli zekhibhodi ongazisebenzisa ku-Photoshop: //pcpro100.info/goryachie-klavishi-fotoshop/.
Iminwe, njengoba ifundile ukuthola izinkinobho zemilingo, izokhulula amehlo akho ukuthi asebenze kudokhumenti. Futhi-ke isivinini semisebenzi yekhompyutha yakho sizoshesha impela.