Mazano anopisa anoshandisa set on keyboard keyboard imwe kiyi kiyi musanganiswa, inopa nekukurumidza kuwana kune mamwe mashandiro ekushandisa system, kana chirongwa chakasiyana. Ichi chishandiso chinowanikwa zvakare kubva kuMicrosoft Excel. Ngatitsvagei izvo zvinopisa zvinowanikwa muExprel application, uye kuti iwe unogona kuita navo.
General
Chekutanga pane zvese, zvinofanirwa kucherechedzwa kuti mune rondedzero pazasi peiyo inopisa runyorwa, chimwe "+" chiratidzo chinoshanda sechiratidzo chinoreva kusanganisa kiyi. Kana iri iyo "++" chiratidzo inotaurwa - izvi zvinoreva kuti pane kabhodhi iwe yaunoda kudzvanya "+ kiyi pamwe neimwe kiyi, iyo inoratidzwa. Iro zita rebasa rinoonekwa sezvavanotaurwa sekhibhodi: F1, F2, F3, etc.Zvakare, zvinofanirwa kutaurwa kuti yekutanga kuda kudzvanya makiyi ebasa. Izvi zvinosanganisira kuchinja, Ctrl uye ALT. Uye mushure, akabata makiyi aya, tinya kiyi dzebasa, mabhatani ane mavara, nhamba, uye mamwe mavara.
General Zvirongwa
Microsoft's general zviridzwa ndiyo nzira dzechirongwa: Kuvhura, kuchengetedza, kugadzira faira, nezvimwe. Mazano anopisa anopa mukana kune aya mabasa ari seinotevera:
- Ctrl + n - kugadzira faira;
- CTRL + S - kuchengetedzwa kwebhuku;
- F12 - kusarudzwa kwechimiro uye nzvimbo yebhuku kuti aponese;
- CTRL + O - Kuvhura bhuku idzva;
- CTRL + F4 - Kuvharwa kweBhuku;
- CTRL + P - Dhinda fungidziro;
- CTRL + A ndeye kuratidza iyo yakazara pepa.
Navigation Keys
Kuti udzivise pepa kana bhuku, kune zvakare makiyi anopisa.
- CTRL + F6 - Kufamba pakati pemabhuku akati wandei kwakavhurika;
- Tab - kufamba kune chitero chinotevera;
- Shift + Tab - Kufamba kuenda kuCell Cell;
- Peji kumusoro - kufamba kumusoro kwehukuru hweyekutarisa;
- Peji pasi - kufamba pasi kusvika kuhukuru hweyekutarisa;
- CTRL + Peji kumusoro - kufamba kune rakapfuura pepa;
- CTRL + Peji pasi - kufamba kune rinotevera pepa;
- CTRL + ENTER - kufamba pachiteshi chekupedzisira;
- CTRL + Imba - Kufamba kuenda kuchitokisi chekutanga.
Mazano anopisa ezvemakombi mabasa
Microsoft Excel inongoshandiswa kwete chete pakuvaka tafura yekufura, asi zvakare kune zviito zvemakomputa mukati mazvo, nekupinda mafomula. Zvekukurumidza kuwana zviito izvi, pane maHotki akakodzera.
- Alt + = - activation yeavosumma;
- Ctrl + ~ - inoratidza mhedzisiro yekuverenga mumasero;
- F9 - RETALCLACTION YEMADZIMAI maofficilas mune iyo faira;
- Shift + F9 - REFALCLACTION YEMAFANANIDZO PESI ISHURE ISHANDISE;
- Shift + F3 - Fonera wizard mabasa.
Kukanganisa kururamisa
Makiyi anopisa akagadzirirwa kugadzirisa data inobvumira kuti uzadze tafura neruzivo nekukurumidza.
- F2 - Editing maitiro echiteshi chakanyorwa;
- Ctrl ++ - kuwedzera mbiru kana mitsara;
- CTRL + - - Delete yakasarudzwa makoramu kana mitsara pane pepa reMicrosoft Excel tafura;
- CTRL + Delete - kubvisa zvinyorwa zvakasarudzwa;
- Ctrl + H - Tsvaga / Kutsiva hwindo;
- CTRL + Z - Kanzura chiito chakaitwa neyekupedzisira;
- Ctrl + Alt + v iyi inokosha isa.
Kuumbwa
Chimwe chezvinhu zvakakosha zvematafura uye mbozs marara. Uye zvakare, fomati inobata inokanganisa computing maitiro muExcel.
- CTRL + Shift +% - kusanganisa kwezana yemhando;
- Ctrl + Shift + $ - Iyo chimiro chekutaura kwemari;
- CTRL + SHIFT + # - Date chimiro;
- CTRL + Shift +! - chimiro chehuwandu;
- CTRL + Shift + ~ - General Fomati;
- CTRL + 1 - activation yeiyo cell yekugadzira hwindo.
Dzimwe Hotkeys
Kuwedzera kune inopisa kiyi yaive yakanyorwa mumapoka ari pamusoro, iyo Excel application ine yakakoshesa masanganiswa emabhatani pane kabhodhi yekudaidzira mabasa:
- Alt + '- kusarudzwa kwegadziriro yekugadzira;
- F11 - Kugadzira Dhigiri pane Iro Rwonzi Tsamba;
- Shift + F2 - Chinja chirevo muchitokisi;
- F7 - tarisa mameseji ekukanganisa.
Ehezve, kwete zvese kushandiswa kwemakiyi anopisa muMicrosoft Elcel zvirongwa zvakaratidzwa pamusoro apa. Zvakangodaro, takatarisisa kune yakakurumbira, inobatsira, uye yakatsvakwa kubva kwavari. Ehezve, kushandiswa kwemakiyi anopisa kunokwanisa kurerutsa zvakanyanya uye nekumhanyisa iyo Microsoft Excel chirongwa.