Izinqamuleli zami zekhibhodi ye-Excel - ungenza kanjani isethi yezinqamuleli zekhibhodi yomuntu siqu ku-Excel

Labo bantu abasebenza njalo ngamaspredishithi e-Excel badinga ukwenza izenzo ezifanayo njalo. Ukwenza izenzo zakho ngokuzenzakalelayo, ungasebenzisa izindlela ezimbili. Esokuqala isabelo sezinqamuleli zekhibhodi kubha yamathuluzi yokufinyelela Ngokushesha. Okwesibili ukudalwa kwama-macros. Indlela yesibili iyinkimbinkimbi kakhulu, ngoba udinga ukuqonda ikhodi yohlelo ukuze ubhale ama-macros. Indlela yokuqala ilula kakhulu, kodwa sidinga ukukhuluma kabanzi mayelana nendlela yokubeka amathuluzi adingekayo kuphaneli yokufinyelela okusheshayo.

Izinqamuleli Zekhibhodi Eziwusizo Kakhulu ku-Excel

Ungakha okhiye abashisayo ngokwakho, kodwa lokhu akusho ukuthi bazoba usizo ngangokunokwenzeka. Uhlelo seluvele lwakhiwe izinhlanganisela eziningi ezibalulekile, imiyalo ethile, ongenza ngayo izenzo ezahlukahlukene.. Izinhlobonhlobo zezinqamuleli ezitholakalayo zingahlukaniswa ngamaqembu amaningana kuye ngenjongo yazo. Imiyalo esheshayo yokufometha idatha:

1. I-CTRL+T – usebenzisa le nhlanganisela yokhiye, ungakha ishidi lokusebenza elihlukile kuseli eyodwa kanye nohlu olukhethiwe lwamaseli alizungezile.
2. I-CTRL+1 - Ivula ibhokisi lengxoxo leFomethi Yefomethi esuka kuThebula.

Iqembu elihlukile lemiyalo esheshayo yokufometha idatha lingahlukaniswa ngenhlanganisela ye-CTRL + SHIFT enezinhlamvu ezengeziwe. Uma wengeza% - shintsha ifomethi ibe amaphesenti, $ - yenza kusebenze ifomethi yemali, ; – ukusetha usuku oluvela kukhompyutha, ! – setha ifomethi yenombolo, ~ – vula ifomethi evamile. Isethi evamile yezinqamuleli zekhibhodi:

1. I-CTRL + W – ngalo myalo, ungakwazi ukuvala ngaso leso sikhathi incwadi yokusebenza esebenzayo.
2. I-CTRL+S - gcina idokhumenti esebenzayo.
3. I-CTRL+N - dala idokhumenti entsha yokusebenza.
4. I-CTRL+X - Engeza okuqukethwe okuvela kumaseli akhethiwe ebhodini lokunamathisela.
5. I-CTRL+O - vula idokhumenti esebenzayo.
6. I-CTRL + V - usebenzisa le nhlanganisela, idatha evela ebhodini lokunamathisela yengezwa esitokisini esimakwe kusengaphambili.
7. I-CTRL+P - ivula iwindi elinezilungiselelo zokuphrinta.
8. I-CTRL+Z iwumyalo wokuhlehlisa isenzo.
9. F12 – lo khiye ugcina idokhumenti yokusebenza ngaphansi kwegama elihlukile.

Imiyalo yokusebenza namafomula ahlukahlukene:

1. CTRL+ ' – kopisha ifomula ekuseli ngenhla, uyinamathisele kuseli ephawuliwe noma umugqa wamafomula.
2. I-CTRL+ ` - usebenzisa lo myalo, ungashintsha izindlela zokubonisa amanani kumafomula namaseli.
3. F4 - lo khiye ikuvumela ukuthi ushintshe phakathi kwezinketho ezahlukene zezinkomba kumafomula.
4. Ithebhu iwumyalo wokuqedela ngokuzenzakalelayo igama lomsebenzi.

Imiyalo yokufaka idatha:

1. I-CTRL+D – usebenzisa lo myalo, ungakwazi ukukopisha okuqukethwe kuseli lokuqala lohlu olumakiwe, wengeze kuwo wonke amaseli angezansi.
2. I-CTRL+Y - uma kungenzeka, umyalo uzophinda isenzo sokugcina esenziwe.
3. I-CTRL+; — Kwengeza idethi yamanje.
4. I-ALT+enter Ifaka umugqa omusha ngaphakathi kweseli uma imodi yokuhlela ivuliwe.
5. F2 – shintsha iseli ephawuliwe.
6. I-CTRL+SHIFT+V - Ivula i-Namathisela idokodo elikhethekile.

Ukubuka Kwedatha Nokuzulazula:

1. Ikhaya - ngale nkinobho ungabuyela kuseli lokuqala eshidini elisebenzayo.
2. I-CTRL+G - iletha iwindi elithi "Transition" - Iya ku.
3. CTRL+PgDown – usebenzisa lo myalo, ungaya ekhasini lokusebenza elilandelayo.
4. I-CTRL+END - Ukuthuthela ngokushesha kuseli lokugcina leshidi elisebenzayo.
5. I-CTRL+F - Lo myalo uletha ibhokisi lengxoxo elithi Thola.
6. I-CTRL+Tab - shintsha phakathi kwezincwadi zokusebenza.
7. I-CTRL+F1 - Fihla noma ubonise iribhoni ngamathuluzi.

Imiyalo yokukhetha idatha:

1. SHIFT+Space – isinqamuleli sekhibhodi ukuze ukhethe umugqa wonke.
2. I-CTRL+Space iyisinqamuleli sekhibhodi sokukhetha ikholomu yonke.
3. I-CTRL+A – inhlanganisela yokukhetha ishidi lokusebenzela lonke.

Kubalulekile! Omunye wemiyalo ewusizo ukukhetha uhla lwamaseli aqukethe noma iyiphi idatha, umsebenzisi asebenza nawo ngenkuthalo. Nokho, uma kuqhathaniswa nezinye izinhlanganisela, iqukethe izingxenye ezimbili. Okokuqala udinga ukucindezela u-Ctrl + Ekhaya, bese ucindezela inhlanganisela Ctrl + Shift + End.

Ungawabela kanjani ama-hotkeys ukuze udale isethi yakho

Awukwazi ukuzenzela okhiye bakho bezinqamuleli ku-Excel. Lokhu akusebenzi kuma-macros, ngokubhala okudingeka uqonde ikhodi, uwabeke kahle kuphaneli yokufinyelela okusheshayo. Ngenxa yalokhu, imiyalo eyisisekelo kuphela echazwe ngenhla etholakala kumsebenzisi. Kusuka kuzinhlanganisela zokhiye, udinga ukukhetha leyo miyalo esetshenziswayo noma ezosetshenziswa kaningi. Ngemva kwalokho, kuyinto efiselekayo ukuwengeza kuphaneli yokufinyelela okusheshayo. Ungathatha noma yiliphi ithuluzi kumabhulokhi ahlukahlukene ungene kulo, ukuze ungalibheki esikhathini esizayo. Inqubo yokwabela ama-hotkeys inezinyathelo ezimbalwa:

1. Vula ibha yamathuluzi yokufinyelela ngokushesha ngokuchofoza isithonjana somcibisholo oya phansi, esitholakala ngenhla kwebha yamathuluzi eyinhloko.

2. Iwindi lezilungiselelo kufanele livele esikrinini ukuze linikezwe, lishintshe izinqamuleli zekhibhodi. Phakathi kwemiyalo ehlongozwayo, udinga ukukhetha "VBA-Excel".

3. Ngemva kwalokho, uhlu kufanele luvuleke nayo yonke imiyalo etholakalayo kumsebenzisi engangezwa kuphaneli yokufinyelela okusheshayo. Kuyo udinga ukukhetha lokho okuthanda kakhulu.

Ngemva kwalokho, ukhiye wesinqamuleli somyalo okhethiwe uzovela kubha yesinqamuleli. Ukuze wenze kusebenze umyalo owengeziwe, indlela elula ukuchofoza kuwo nge-LMB. Nokho, kukhona enye indlela. Ungasebenzisa inhlanganisela yokhiye, lapho inkinobho yokuqala I-ALT, inkinobho elandelayo inombolo yomyalo, njengoba ibala kubha yesinqamuleli.

Iseluleko! Akunconywa ukwabela isinqamuleli sekhibhodi kubha yamathuluzi ezenzakalelayo yokufinyelela Ngokushesha. Lokhu kungenxa yokuthi umuntu ngamunye udinga imiyalo yakhe, engeke inikezwe uhlelo ngokwalo kunguqulo evamile.

Uma izinqamuleli zekhibhodi zabelwe, kutuswa ukuzijwayeza ukuzisebenzisa hhayi ngegundane, kodwa ngenhlanganisela yezinkinobho eziqala ngo-ALT. Lokhu kuzokusiza ukuthi wonge isikhathi emisebenzini ephindaphindwayo futhi wenze umsebenzi wenziwe ngokushesha.