Mukati
- tsananguro
- Zvidimburiko zvekiibhodhi zvinowanzo shandiswa
- Keyboard Shortcuts eRibhoni
- Kushandisa Makiyi Ekupinda eRibbon Tabs
- Kushanda nematabo eribhoni uchishandisa kiibhodhi
- Zvidimburiko zveKiyibhodhi zvekugadzirisa masero
- Keyboard mapfupi muNamira Yakakosha dialog box muExcel 2013
- Zvidimburiko zvekibhodhi zvezviito uye sarudzo
- Keyboard mapfupi ekushanda nedata, mabasa, uye fomula bar
- Zvidimburiko zvekibhodhi muPower Pivot
- Keyboard mapfupi muHofisi yekuwedzera-ins
- Basa rekiyi
- Mamwe mapfupi ekibhodhi anobatsira
- mhedziso
Hotkeys chinhu chakakosha chespredishiti edhita iyo inokutendera iwe kuti uwane nekukurumidza kune mamwe mabasa. Muchinyorwa ichi, isu tichabata zvakadzama nezve iyo spreadsheet processor ine makiyi anopisa, uye ndeapi maitiro anogona kuitwa navo.
tsananguro
Pakutanga, cherechedza kuti chiratidzo chekuwedzera "+" chinoreva musanganiswa wemabhatani. Maviri akadai "++" akatevedzana anoreva kuti "+" inofanira kudzvanywa pamwe chete neimwe kiyi pakiibhodhi. Makiyi ebasa mabhatani anofanira kutanga adzvanywa. Iwo masevhisi anosanganisira: Alt, Shift, uye zvakare Ctrl.
Zvidimburiko zvekiibhodhi zvinowanzo shandiswa
Kutanga, ngationgororei misanganiswa yakakurumbira:
SHIFT+TAB | Dzokera kumunda wapfuura kana kugadzika kwekupedzisira pahwindo. |
ARROW ↑ | Enda kudivi repamusoro nemunda 1 webepa. |
ARROW ↓ | Enda kudivi rezasi nemunda 1 webepa. |
ARROW ← | Enda kuruboshwe nemunda 1 wepepa. |
ARROW → | Enda kudivi rekurudyi ne1 munda webepa. |
CTRL + museve bhatani | Enda kumagumo enzvimbo yeruzivo pane pepa. |
END, bhatani remuseve | Kuenda kune basa rinonzi "End". Kudzima basa. |
CTRL+END | Kufambisa kuenda kumunda wakapedzwa papepa. |
CTRL+SHIFT+END | Zoom munzvimbo yamaka kusvika kune yekupedzisira kushandiswa sero. |
IMBA+KUSVIRA KUFUNGWA | Enda kuchitokisi chiri mukona yekumusoro kuruboshwe kwenzvimbo. |
PEJI PASI | Fambisa 1 skrini pasi pepepa. |
CTRL+PEJI PASI | Enda kune rimwe pepa. |
ALT+PEJI PASI | Fambisa skrini 1 kurudyi pane pepa. |
PEJI UP | Fambisa 1 skrini kumusoro kwebepa. |
ALT+PEJI UP | Fambisa 1 skrini kuruboshwe pane pepa. |
CTRL+PEJI UP | Dzokera kune pepa rapfuura. |
TAB | Fambisa ndima 1 kurudyi. |
ALT+ARROW↓ | Gonesa chinyorwa chekutarisa chikamu. |
CTRL+ALT+5 inoteverwa nematehwe mashoma eTAB | Shanduko pakati pezvimiro zvinofamba (zvinyorwa, mifananidzo, zvichingodaro). |
CTRL + SHIFT | Horizontal mupumburu. |
Keyboard Shortcuts eRibhoni
Kudzvanya “ALT” kunoratidza misanganiswa yemabhatani pabhara rekushandisa. Ichi chirevo chevashandisi vasati vaziva ese hotkeys.
Kushandisa Makiyi Ekupinda eRibbon Tabs
ZVESE, F | Kupinda muchikamu che "Faira" uye kushandisa Backstage. |
ALT, I | Kupinda muchikamu che "Kumba", kufomatidza zvinyorwa kana ruzivo rwenhamba. |
ZVOSE, С | Kupinda muchikamu che "Insert" uye kuisa zvinhu zvakasiyana-siyana. |
ALT+P | Kupinda muchikamu che "Peji Layout". |
ALT, L | Kupinda muchikamu che "Formulas". |
Iyo ALT + | Kuwana chikamu che "Data". |
ALT+R | Kuwana chikamu che "Vaongorori". |
ALT+O | Kuwana chikamu che "View". |
Kushanda nematabo eribhoni uchishandisa kiibhodhi
F10 kana ALT | Sarudza chikamu chinoshanda pane toolbar uye shandisa mabhatani ekupinda. |
SHIFT+TAB | Enda kumirairo yeribhoni. |
Museve mabhatani | Movement nenzira dzakasiyana pakati pezvikamu zve tepi. |
PINDA kana nzvimbo | Vhura bhatani rakasarudzwa. |
ARROW ↓ | Kuburitswa kwerondedzero yechikwata chatasarudza. |
ALT+ARROW ↓ | Kuvhura menyu yebhatani ratasarudza. |
ARROW ↓ | Chinja kune rinotevera rairo muhwindo rakawedzerwa. |
CTRL + F1 | Kupeta kana kupeta. |
SHIFT+F10 | Kuvhura menyu yezvinyorwa. |
ARROW ← | Chinja kune submenu zvinhu. |
Zvidimburiko zveKiyibhodhi zvekugadzirisa masero
Ctrl + B | Gonesa mhando yakashinga yeruzivo. |
Ctrl + I | Bvumira rudzi rwemashoko akatsveyama. |
Ctrl + U | Gonesa kutara pasi. |
Alt + H + H | Kusarudza tint yemavara. |
Alt+H+B | Frame activation. |
Ctrl + Shift + & | Kuita kwechikamu che contour. |
Ctrl + Shift + _ | Dzima mafuremu. |
Ctrl + 9 | Viga mitsetse yakasarudzwa. |
Ctrl + 0 | Viga makoramu akasarudzwa. |
Ctrl + 1 | Inovhura hwindo reFormat Cells. |
Ctrl + 5 | Gonesa strikethrough. |
Ctrl + Shift + $ | Kushandisa mari. |
Ctrl + Shift +% | Kushandisa chikamu. |
Keyboard mapfupi muNamira Yakakosha dialog box muExcel 2013
Iyi vhezheni yemupepeti wespredishiti ine chinhu chakakosha chinonzi Paste Special.
Aya mahotkey anotevera anoshandiswa pahwindo iri:
A | Kuwedzera zvese zvirimo. |
F | Kuwedzera mafomula. |
V | Kuwedzera hunhu. |
T | Kuwedzera iyo yekutanga fomati. |
C | Kuwedzera manotsi uye manotsi. |
N | Kuwedzera scan sarudzo. |
H | Kuwedzera mafomu. |
X | Kuwedzera pasina miganhu. |
W | Kuwedzera nehupamhi hwepakutanga. |
Zvidimburiko zvekibhodhi zvezviito uye sarudzo
Shift + ARROW → / ← | Wedzera nzvimbo yekusarudza kurudyi kana kuruboshwe. |
Shift + Space | Kusarudza mutsara wose. |
Ctrl+Space | Kusarudza chikamu chose. |
Ctrl+Shift+Space | Kusarudza pepa rose. |
Keyboard mapfupi ekushanda nedata, mabasa, uye fomula bar
F2 | Shanduko yemunda. |
Shift + F2 | Kuwedzera chinyorwa. |
Ctrl + X | Cheka ruzivo kubva kumunda. |
Ctrl + C | Kukopa ruzivo kubva kumunda. |
Ctrl + V | Kuwedzera ruzivo kubva kumunda. |
Ctrl + Alt + V | Kuvhura iyo "Special Attachment" hwindo. |
Kudzima | Kubvisa kuzadzwa kwemunda. |
Alt + Pinda | Kupinza kudzoka mukati memunda. |
F3 | Kuwedzera zita remunda. |
Alt + H + D + C | Kubvisa chikamu. |
Esc | Kanzura kupinda mumunda. |
pinda | Kuzadza kupinza mumunda. |
Zvidimburiko zvekibhodhi muPower Pivot
PCM | Kuvhura menyu yezvinyorwa. |
CTRL+A | Kusarudza tafura yose. |
CTRL+D | Kubvisa bhodhi rose. |
CTRL+M | Kufambisa ndiro. |
Ctrl+R | Kupa zita retafura. |
CTRL+S | Chengetedza. |
CTRL+Y | Kudzokorora kwemaitiro apfuura. |
CTRL+Z | Kudzoka kwemaitiro akanyanyisa. |
F5 | Kuvhura hwindo re "Go". |
Keyboard mapfupi muHofisi yekuwedzera-ins
CTRL+SHIFT+F10 | Menu kuvhura. |
CTRL+SPACE | Kuburitswa kwendima yemabasa. |
CTRL+SPACE uye wobva wadzvanya paVhara | Vhara nzvimbo yebasa. |
Basa rekiyi
F1 | Bvumira rubatsiro. |
F2 | Kugadzirisa sero rakasarudzwa. |
F3 | Enda kune "Zita pamagumo" bhokisi. |
F4 | Kudzokorora chiito chekare. |
F5 | Enda ku "Go" hwindo. |
F6 | Shanduko pakati pezvinhu zvemupepeti wetafura. |
F7 | Kuvhura hwindo re "Spelling". |
F8 | Shandisa sarudzo yakawedzerwa. |
F9 | Kuverenga mapepa. |
F10 | Activate mazano. |
F11 | Kuwedzera chati. |
F12 | Enda ku "Save As" hwindo. |
Mamwe mapfupi ekibhodhi anobatsira
Alt+' | Inovhura hwindo rekugadzirisa sero. |
BACKSPACE
| Kudzima chimiro. |
pinda | Kupera kwe data set. |
ESC | Cancel set. |
HOME | Dzokera pakutanga kwepepa kana mutsara. |
mhedziso
Ehe, kune mamwe makiyi anopisa mupepeti yespredishiti. Isu takaongorora iyo inonyanya kufarirwa uye inonyanya kushandiswa musanganiswa. Kushandiswa kwemakiyi aya kuchabatsira vashandisi kushanda nekukurumidza mupepeti yespredishiti.