Zamkatimu
- mwachidule
- Njira zazifupi zomwe zimagwiritsidwa ntchito pafupipafupi
- Njira zazifupi za Kiyibodi za Riboni
- Kugwiritsa Ntchito Makiyi Ofikira a Ma Ribbon Tabs
- Kugwira ntchito ndi ma riboni tabu pogwiritsa ntchito kiyibodi
- Njira zazifupi za kiyibodi zamapangidwe amafoni
- Njira zazifupi za kiyibodi mu Paste Special dialog box mu Excel 2013
- Njira zazifupi za kiyibodi pazochita ndi zosankha
- Njira zazifupi za kiyibodi kuti mugwiritse ntchito ndi data, ntchito, ndi formula bar
- Njira zazifupi za kiyibodi mu Power Pivot
- Njira zazifupi za kiyibodi muzowonjezera za Office
- Makiyi a ntchito
- Njira zina zazifupi za kiyibodi
- Kutsiliza
Hotkeys ndi gawo lapadera la mkonzi wa spreadsheet womwe umakupatsani mwayi wopeza ntchito zina. M'nkhaniyi, tidzakambirana mwatsatanetsatane zomwe pulosesa ya spreadsheet ili ndi makiyi otentha, ndi njira zomwe zingagwiritsidwe ntchito nawo.
mwachidule
Poyamba, zindikirani kuti chizindikiro chophatikiza "+" chikutanthauza mabatani ophatikizika. Awiri oterowo "++" motsatana amatanthauza kuti "+" iyenera kukanidwa limodzi ndi kiyi ina pa kiyibodi. Makiyi a mautumiki ndi mabatani omwe ayenera kukanidwa poyamba. Zothandizira zikuphatikizapo: Alt, Shift, komanso Ctrl.
Njira zazifupi zomwe zimagwiritsidwa ntchito pafupipafupi
Choyamba, tiyeni tipende zosakaniza zodziwika bwino:
SHIFT+TAB | Bwererani kumunda wam'mbuyo kapena komaliza pawindo. |
ARROW ↑ | Pitani kumtunda wapamwamba ndi gawo limodzi la pepala. |
ARROW ↓ | Pitani kumunsi kwa gawo limodzi la pepala. |
ARROW ← | Pitani kumanzere ndi gawo limodzi la pepala. |
ARROW → | Pitani kumanja ndi gawo limodzi la pepala. |
CTRL + muvi batani | Pitani kumapeto kwa gawo lachidziwitso papepala. |
END, batani la muvi | Kusunthira ku ntchito yotchedwa "End". Kulepheretsa ntchito. |
CTRL + END | Kusuntha kupita kumunda womalizidwa pa pepala. |
CTRL+SHIFT+END | Onerani pafupi ndi malo olembedwa mpaka selo lomaliza. |
HOME+SCROLL LOCK | Kusamukira ku selo limene lili kumtunda kumanzere ngodya m'deralo. |
TSAMBA | Sunthani chophimba 1 pansi pa pepala. |
CTRL+PAGE PASI | Pitani ku pepala lina. |
ALT+PAGE PASI | Sunthani chophimba 1 kumanja pa pepala. |
TSAMBA UPA | Sunthani chophimba 1 pamwamba pa pepala. |
ALT+PAGE UP | Sunthani chophimba 1 kumanzere pa pepala. |
CTRL+PAGE UP | Bwererani ku pepala lapitalo. |
TAB | Sunthani gawo limodzi kumanja. |
ALT+ARROW↓ | Yambitsani mndandanda wagawo. |
CTRL+ALT+5 ndikutsatiridwa ndi makina ochepa a TAB | Kusintha pakati pa mawonekedwe osuntha (zolemba, zithunzi, ndi zina zotero). |
CTRL+SHIFT | Mpukutu wopingasa. |
Njira zazifupi za Kiyibodi za Riboni
Kukanikiza "ALT" kumawonetsa mabatani ophatikizika pazida. Ichi ndi lingaliro kwa ogwiritsa ntchito omwe sadziwa ma hotkey onse.
Kugwiritsa Ntchito Makiyi Ofikira a Ma Ribbon Tabs
ZONSE, F | Lowani mu gawo la "Fayilo" ndikuyika Backstage. |
ALT, ndi | Kulowa mu gawo la "Home", kupanga zolemba kapena manambala. |
ZONSE, С | Kulowa mu gawo la "Insert" ndikuyika zinthu zosiyanasiyana. |
ALT + P. | Lowani mu gawo la "Mapangidwe a Tsamba". |
ALT, L | Lowani mu gawo la "Formulas". |
Chithunzi cha ALT + | Kufikira ku gawo la "Data". |
ALT+R | Kufikira ku gawo la "Reviewers". |
ALT+O | Kufikira ku gawo la "View". |
Kugwira ntchito ndi ma riboni tabu pogwiritsa ntchito kiyibodi
F10 kapena ALT | Sankhani gawo lomwe likugwira ntchito pazida ndikuthandizira mabatani ofikira. |
SHIFT+TAB | Yendetsani ku malamulo a riboni. |
Mabatani amivi | Kuyenda mosiyanasiyana pakati pa zigawo za tepi. |
ENTER kapena danga | Yambitsani batani losankhidwa. |
ARROW ↓ | Kuwulula mndandanda wa gulu lomwe tasankha. |
ALT+ARROW ↓ | Kutsegula menyu ya batani lomwe tasankha. |
ARROW ↓ | Sinthani ku lamulo lotsatira pawindo lokulitsidwa. |
CTRL + F1 | Kupinda kapena kufutukula. |
YAMBIRANI + F10 | Kutsegula menyu yankhani. |
ARROW ← | Sinthani kuzinthu zazing'ono. |
Njira zazifupi za kiyibodi zamapangidwe amafoni
Ctrl + B | Yambitsani chidziwitso chamtundu wakuda. |
Ctrl + Ine | Yambitsani zambiri zamtundu wa italiki. |
Ctrl + U | Yambitsani kutsindika. |
Alt + H + H | Kusankha mtundu wa mawu. |
Alt+H+B | Kutsegula kwa chimango. |
Ctrl + Shift + & | Kutsegula kwa gawo la contour. |
Ctrl + Shift + _ | Zimitsani mafelemu. |
Ctrl + 9 | Bisani mizere yosankhidwa. |
Ctrl + 0 | Bisani mizati yosankhidwa. |
Ctrl + 1 | Itsegula zenera la Format Cells. |
Ctrl + 5 | Yambitsani kupitilira. |
Ctrl + Shift + $ | Kugwiritsa ntchito ndalama. |
Ctrl + Shift +% | Kugwiritsa ntchito peresenti. |
Njira zazifupi za kiyibodi mu Paste Special dialog box mu Excel 2013
Mtundu uwu wa mkonzi wa spreadsheet uli ndi gawo lapadera lotchedwa Paste Special.
Ma hotkey otsatirawa amagwiritsidwa ntchito pawindo ili:
A | Kuwonjezera zonse. |
F | Kuwonjezera ma formula. |
V | Kuwonjezera makhalidwe. |
T | Kungowonjezera zongoyambira zokha. |
C | Kuwonjezera zolemba ndi zolemba. |
N | Kuwonjezera jambulani options. |
H | Kuwonjezera mafomu. |
X | Kuwonjezera popanda malire. |
W | Kuwonjezera ndi m'lifupi choyambirira. |
Njira zazifupi za kiyibodi pazochita ndi zosankha
Shift + ARROW → / ← | Onjezani gawo losankha kumanja kapena kumanzere. |
Shift + Space | Kusankha mzere wonse. |
Ctrl+Space | Kusankha ndime yonse. |
Ctrl+Shift+Space | Kusankha pepala lonse. |
Njira zazifupi za kiyibodi kuti mugwiritse ntchito ndi data, ntchito, ndi formula bar
F2 | Kusintha kwa malo. |
Shift + F2 | Kuonjezera cholemba. |
Ctrl + X | Dulani zambiri kuchokera m'munda. |
Ctrl + C | Kukopera zambiri kuchokera kumunda. |
Ctrl + V | Kuwonjezera zidziwitso kuchokera kumunda. |
Ctrl + Alt + V | Kutsegula zenera la "Special Attachment". |
Chotsani | Kuchotsa kudzazidwa kwa munda. |
Alt + Lowani | Kulowetsa kubwerera m'munda. |
F3 | Powonjezera dzina lamunda. |
Alt + H + D + C | Kuchotsa gawo. |
Esc | Letsani kulowa m'munda. |
Lowani | Kudzaza zolowetsa m'munda. |
Njira zazifupi za kiyibodi mu Power Pivot
PCM | Kutsegula menyu yankhani. |
CTRL+A | Kusankha tebulo lonse. |
CTRL+D | Kuchotsa gulu lonse. |
CTRL+M | Kusuntha mbale. |
CTRL+R | Kutchulanso tebulo. |
Ctrl + S | Sungani. |
Ctrl + Y | Kubwereza ndondomeko yapitayi. |
CTRL+Z | Kubwerera kwa ndondomeko kwambiri. |
F5 | Kutsegula zenera "Go". |
Njira zazifupi za kiyibodi muzowonjezera za Office
Ctrl + kuloza + F10 | Kutsegula kwa menyu. |
CTRL+SPACE | Kuwulula gawo la ntchito. |
CTRL+SPACE ndiyeno dinani Close | Tsekani gawo la ntchito. |
Makiyi a ntchito
F1 | Thandizani thandizo. |
F2 | Kukonza selo losankhidwa. |
F3 | Pitani ku bokosi la "Dzina kumapeto". |
F4 | Kubwereza zomwe zachitika kale. |
F5 | Pitani kuwindo la "Pitani". |
F6 | Kusintha pakati pa zinthu za mkonzi wa tebulo. |
F7 | Kutsegula zenera "Spelling". |
F8 | Yambitsani kusankha kwakutali. |
F9 | Kuwerengera mapepala. |
F10 | Yambitsani malingaliro. |
F11 | Kuwonjezera tchati. |
F12 | Pitani ku zenera la "Save As". |
Njira zina zazifupi za kiyibodi
Alt+' | Imatsegula zenera losintha ma cell. |
BACKSPACE
| Kuchotsa munthu. |
Lowani | Mapeto a seti ya data. |
ESC | Letsani seti. |
HOME | Bwererani kumayambiriro kwa pepala kapena mzere. |
Kutsiliza
Zachidziwikire, pali makiyi ena otentha mumkonzi wa spreadsheet. Tawunikanso zophatikiza zodziwika bwino komanso zogwiritsidwa ntchito kwambiri. Kugwiritsa ntchito makiyiwa kudzathandiza ogwiritsa ntchito kuti azigwira ntchito mwachangu mumkonzi wa spreadsheet.