Yangu Excel kiibhodhi mapfupi - maitiro ekugadzira seti yemapfupi kiibhodhi mapfupi muExcel

Avo vanhu vanogara vachishanda neExcel maspredishiti vanofanirwa kuita zviito zvakafanana kazhinji. Kuti uite otomatiki zviito zvako, unogona kushandisa nzira mbiri. Chekutanga kupihwa kwezvidimburiko zve keyboard pa Quick Access Toolbar. Chechipiri ndiko kusikwa kwemacros. Yechipiri nzira yakanyanya kuoma, nekuti iwe unofanirwa kunzwisisa kodhi yepurogiramu kunyora macros. Nzira yekutanga yakanyanya nyore, asi tinoda kutaura zvakawanda pamusoro pekuisa maturusi anodiwa pane kukurumidza kupinda panhizha.

Yakanyanya Inobatsira Keyboard Shortcuts muExcel

Iwe unogona kugadzira makiyi anopisa iwe pachako, asi izvi hazvirevi kuti achave anobatsira sezvinobvira. Iyo purogiramu yakatovaka-mune akawanda makiyi musanganiswa, mimwe mirairo, iyo iwe yaunogona kuita akasiyana zviito.. Mhando yese yemapfupi anowanikwa anogona kukamurwa kuita mapoka akati wandei zvichienderana nechinangwa chavo. Kurumidza mirairo yekugadzira data:

  1. CTRL + T - uchishandisa iyi kiyi musanganiswa, unogona kugadzira pepa rekushanda rakasiyana kubva kune imwe sero uye yakasarudzwa masero akaipoteredza.
  2. CTRL + 1 - Inomisa iyo Format Masero Kubva Tafura dialog box.

Boka rakasiyana remirairo yekukurumidza yefomati data inogona kusiyaniswa neCTRL + SHIFT musanganiswa ane mamwe mavara. Kana iwe ukawedzera% - shandura iyo fomati kusvika muzana, $ - activate iyo mari fomati, ; - kuseta zuva kubva pakombuta,! -seta fomati yenhamba, ~ -gonesa iyo general fomati. Yakajairwa seti yemapfupi ekhibhodi:

  1. CTRL + W - kuburikidza nemurairo uyu, unogona kuvhara pakarepo bhuku rinoshanda.
  2. CTRL + S - chengetedza gwaro rekushanda.
  3. CTRL+N - gadzira gwaro idzva rekushanda.
  4. CTRL + X - Wedzera zvirimo kubva kumaseru akasarudzwa kune clipboard.
  5. CTRL + O - vhura gwaro rinoshanda.
  6. CTRL + V - uchishandisa iyi musanganiswa, data kubva pa clipboard inowedzerwa kune sero yakanyorwa kumberi.
  7. CTRL+P - inovhura hwindo rine zvigadziriso zvekudhinda.
  8. CTRL+Z murairo wekugadzirisa chiito.
  9. F12 - kiyi iyi inochengetedza gwaro rekushanda pasi pezita rakasiyana.

Mirairo yekushanda nemafomu akasiyana siyana:

  1. CTRL+ ' - kopira fomula iri musero riri pamusoro, namira musero rine maki kana mutsara wemafomula.
  2. CTRL+ `- uchishandisa uyu murairo, unogona kushandura maratidziro emhando dzemafomati nemaseru.
  3. F4 - kiyi iyi inokutendera kuti uchinje pakati pezvisarudzo zvakasiyana zvemareferensi mumafomati.
  4. Tab murairo wekupedzisa otomatiki yezita rebasa.

Mitemo yekupinda data:

  1. CTRL + D - uchishandisa uyu murairo, unogona kukopa zvirimo kubva pasero rekutanga reiyo yakamaka renji, uchiwedzera kune ese masero pazasi.
  2. CTRL + Y - kana zvichibvira, murairo uchadzokorora chiito chekupedzisira chakaitwa.
  3. CTRL+; - kuwedzera zuva razvino.
  4. ALT + pinda Inopinda mutsetse mutsva mukati mesero kana edit mode yakavhurika.
  5. F2 - shandura sero yakanyorwa.
  6. CTRL+SHIFT+V - Inovhura iyo Paste Special docker.

Data View uye Navigation:

  1. Musha - nebhatani iri unogona kudzokera kuchisero chekutanga pane pepa rinoshanda.
  2. CTRL+G - inounza hwindo "Shanduko" - Enda Ku.
  3. CTRL+PgDown - uchishandisa murairo uyu, unogona kuenda kune rinotevera pepa rekushanda.
  4. CTRL + END - Kuenda pakarepo kune yekupedzisira sero yepepa rinoshanda.
  5. CTRL+F - Uyu murairo unounza Tsvaga dialog box.
  6. CTRL + Tab - chinja pakati pemabhuku ebasa.
  7. CTRL+F1 - Viga kana kuratidza ribhoni nemidziyo.

Mirairo yekusarudza data:

  1. SHIFT+Space - nzira yekudimbudzira yekhibhodi kusarudza mutsara wese.
  2. CTRL+Space ipfupi yekhibhodi yekusarudza koramu yese.
  3. CTRL + A - musanganiswa wekusarudza pepa rebasa rose.

Zvinokosha! Imwe yemirairo inobatsira ndeyekusarudza mutsara wemasero ane chero data, mushandisi ari kushingaira kushanda navo. Nekudaro, zvichienzaniswa nemamwe masanganiswa, ine zvikamu zviviri. Kutanga iwe unofanirwa kudzvanya Ctrl + Kumba, wobva wadzvanya musanganiswa Ctrl + Shift + End.

Maitiro ekugovera hotkeys kugadzira yako seti

Iwe haugone kugadzira yako makiyi mapfupi muExcel. Izvi hazvishande kune macros, zvekunyora izvo zvaunoda kuti unzwisise kodhi, zviise nemazvo pane yekukurumidza kuwana panhi. Nekuda kweizvi, chete mirairo yekutanga iyo yakatsanangurwa pamusoro ndiyo inowanikwa kune mushandisi. Kubva pamisanganiswa yakakosha, unofanirwa kusarudza iyo mirairo inoshandiswa kana ichashandiswa kazhinji. Mushure meizvozvo, zvinodikanwa kuti uvawedzere kune kukurumidza kuwana panhi. Iwe unogona kutora chero chishandiso kubva kune akasiyana mabhuroki mairi, kuti usazozvitsvaga mune ramangwana. Maitiro ekugovera hotkeys ane akati wandei matanho:

  1. Vhura iyo yekukurumidza yekupinda toolbar nekudzvanya pasi museve icon, iyo iri pamusoro peiyo hombe toolbar.

Yangu Excel kiibhodhi mapfupi - maitiro ekugadzira seti yemapfupi kiibhodhi mapfupi muExcel

  1. Iwindo rezvigadziriso rinofanira kuoneka pachiratidziro chekugovera, kushandura mapfupi ekhibhodi. Pakati pemirairo yakarongwa, unofanirwa kusarudza "VBA-Excel".

Yangu Excel kiibhodhi mapfupi - maitiro ekugadzira seti yemapfupi kiibhodhi mapfupi muExcel

  1. Mushure meizvozvo, runyoro runofanira kuvhurwa nemirairo yese inowanikwa kumushandisi iyo inogona kuwedzerwa kune yekukurumidza kupinda panhi. Kubva pairi iwe unofanirwa kusarudza izvo zvaunofarira zvakanyanya.

Yangu Excel kiibhodhi mapfupi - maitiro ekugadzira seti yemapfupi kiibhodhi mapfupi muExcel

Mushure meizvozvo, kiyi yekudimbudzira yemurairo wakasarudzwa ichaonekwa pane nzira yekudimbudzira. Kuti uite iyo yakawedzerwa murairo, nzira iri nyore ndeyekudzvanya pairi neLMB. Zvisinei, pane imwe nzira. Iwe unogona kushandisa kiyi musanganiswa, uko yekutanga bhatani ALT, bhatani rinotevera ndiyo nhamba yekuraira, sezvainoverengera mubhara rekudimbudzira.

Zano! Hazvikurudzirwe kupa nzira yekudimbudzira kiibhodhi mune default Kurumidza Kupinda Toolbar. Izvi zvinokonzerwa nekuti munhu mumwe nomumwe anoda mirairo yavo, iyo isingazopiwi nepurogiramu pachayo muhuwandu hwehuwandu.

Kana mapfupi ekhibhodi apihwa, zvinokurudzirwa kuti udzidzire kuamisa kwete negonzo, asi nemusanganiswa wemabhatani anotanga neALT. Izvi zvichakubatsira kuchengetedza nguva pakudzokorora mabasa uye kuita kuti basa riitwe nekukurumidza.

Leave a Reply