Amashothikhathi ekhibhodi e-Excel

Pin
Send
Share
Send

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.

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 sekhibhodiYisiphi isenzo esizokwenziwa
Ctrl + SusaUmbhalo okhethiwe uyasuswa.
I-Ctrl + Alt + VUkufakwa okukhethekile kwenzeka
ICtrl + sign +Amakholomu nezinsimbi ezichaziwe ayengeziwe.
ICtrl + uphawu -Amakholomu akhethiwe noma imigqa isusiwe.
I-Ctrl + DIbanga elingaphansi ligcwele imininingwane evela kuseli elikhethiwe
I-Ctrl + RIbanga ngakwesokunene ligcwele imininingwane evela kuseli elikhethiwe.
I-Ctrl + HKuvela iwindi lokusesha-esikhundleni.
I-Ctrl + ZIsenzo sokugcina sikhanseliwe.
I-Ctrl + YIsenzo sokugcina siphindwe
I-Ctrl + 1Ingxoxo yomhleli weseli iyavulwa.
I-Ctrl + BUmbhalo unesibindi
I-Ctrl + IIsethali esetshenzisiwe
I-Ctrl + UUmbhalo udwetshiwe.
I-Ctrl + 5Umbhalo ogqanyisiwe ukhishwa.
I-Ctrl + FakaWonke amaseli akhethiwe.
I-Ctrl +;Kuboniswa usuku
I-Ctrl + Shift +;Isikhathi sigciniwe
I-Ctrl + BackspaceIsikhombisi sibuyele kwiseli edlule.
I-Ctrl + SpaceIkholomu ivelele
I-Ctrl + AIzinto ezibonakalayo ziyaqokonyiswa.
I-Ctrl + EkupheleniIsikhombisi sibekwe esitokisini sokugcina.
I-Ctrl + Shift + EndKuqokonyiswa iseli lokugcina
I-Ctrl + ArrowsIsikhombisi sihamba emaphethelweni ekholamu maqondana nemicibisholo.
I-Ctrl + NKuvela incwadi entsha engenalutho
I-Ctrl + SIdokhumenti igciniwe
I-Ctrl + OIbhokisi lokucinga lefayela elifunekayo liyavula.
I-Ctrl + LImodi yetafula le-Smart iyaqala
I-Ctrl + F2Ukubuka kuqala kufakiwe
I-Ctrl + KI-Hyperlink ifakiwe
I-Ctrl + F3Kwethulwa 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.

Pin
Send
Share
Send