Hotkeys a cikin Excel. Mahimmanci hanzarta aiki a cikin Excel

Hotkeys fasali ne na musamman na editan maƙunsar rubutu wanda ke ba ku damar samun damar shiga wasu ayyuka nan take. A cikin labarin, za mu yi magana dalla-dalla tare da abin da mai sarrafa ma'auni yana da maɓalli masu zafi, kuma waɗanne hanyoyin za a iya aiwatar da su tare da su.

Overview

Da farko, lura cewa alamar ƙari "+" tana nufin haɗin maɓalli. Biyu irin waɗannan "++" a jere suna nufin cewa "+" dole ne a danna tare da wani maɓalli akan madannai. Maɓallan sabis maɓallai ne waɗanda dole ne a fara danna su. Sabis ɗin sun haɗa da: Alt, Shift, da kuma Ctrl.

Gajerun hanyoyin da ake amfani da su akai-akai

Da farko, bari mu bincika shahararrun haɗuwa:

SHIFT+TABKoma zuwa filin da ya gabata ko saitin ƙarshe a cikin taga.
ARROW Matsar zuwa saman gefe ta filin 1 na takardar.
ARROW Matsar zuwa gefen ƙasa ta filin 1 na takardar.
ARROW ← Matsar zuwa gefen hagu ta filin 1 na takardar.
ARROW → Matsar zuwa gefen dama ta filin 1 na takardar.
CTRL + maɓallin kibiyaMatsar zuwa ƙarshen wurin bayanin akan takardar.
KARSHE, maɓallin kibiyaMotsawa zuwa aiki mai suna "Ƙare". Kashe aikin.
CTRL+ ENDMotsawa zuwa filin da aka gama akan takardar.
CTRL+ SHIFT+ ENDZuƙowa yankin da aka yiwa alama zuwa tantanin halitta da aka yi amfani da shi na ƙarshe.
KYAUTA GIDA +Matsar zuwa tantanin halitta wanda ke cikin kusurwar hagu na sama na yankin.
SHIGON PAGEMatsar da allo 1 zuwa ƙasan takardar.
CTRL+ PAGE DOWNMatsar zuwa wani takardar.
ALT+ PAGE DOWNMatsar da allo 1 zuwa dama akan takardar.
 

PAGE sama

Matsar da allo 1 sama da takardar.
ALT+ PAGE UPMatsar da allo 1 zuwa hagu akan takardar.
CTRL+ PAGE UPKoma zuwa takardar da ta gabata.
TABMatsar da fili 1 zuwa dama.
ALT+ArrowKunna jerin abubuwan dubawa don filin.
CTRL+ALT+5 da wasu ƴan latsa TABCanje-canje tsakanin siffofi masu motsi (rubutu, hotuna, da sauransu).
CTRL + SHIFTA kwance gungura.

Gajerun hanyoyin Allon madannai don Ribbon

Latsa "ALT" yana nuna haɗakar maɓallai akan mashaya kayan aiki. Wannan alama ce ga masu amfani waɗanda ba su san duk maɓallan zafi ba tukuna.

1

Amfani da Maɓallan shiga don Shafukan Ribbon

DUK, FShiga cikin sashin "Fayil" kuma amfani da Backstage.
ALT, IShiga cikin sashin "Gida", tsara rubutu ko bayanin lamba.
KOMAI, СShiga cikin sashin "Saka" kuma shigar da abubuwa daban-daban.
ALT + P.Shiga cikin sashin "Layout Page".
ALT, LShiga cikin sashin "Formulas".
ALT +Samun dama ga sashin "Data".
ALT+RSamun dama ga sashin "Masu dubawa".
ALT+ОSamun dama ga sashin "Duba".

Yin aiki tare da shafukan ribbon ta amfani da madannai

F10 ya da ALTZaɓi sashin aiki akan mashaya kuma kunna maɓallin shiga.
SHIFT+TABKewaya zuwa umarnin ribbon.
Maballin kibiyaMotsawa a wurare daban-daban tsakanin sassan tef.
SHIGA ko sarariKunna maɓallin da aka zaɓa.
ARROW Bayyana jerin sunayen ƙungiyar da muka zaɓa.
ALT+Arrow Buɗe menu na maɓallin da muka zaɓa.
ARROW Canja zuwa umarni na gaba a cikin fadada taga.
CTRL + F1Ninkewa ko buɗewa.
SHIFT+F10Buɗe menu na mahallin.
ARROW ← Canja zuwa abubuwan menu na ƙasa.

Gajerun hanyoyin allo don tsara tantanin halitta

Ctrl + BKunna nau'in bayani mai ƙarfi.
Ctrl + IKunna nau'in bayanin rubutu.
Ctrl + UKunna layi.
Alt + H + HZaɓin tint na rubutu.
Alt+H+BKunna firam.
Ctrl + Shift + &Kunna sashin kwane-kwane.
Ctrl + Shift + _Kashe firam.
Ctrl + 9Ɓoye zaɓaɓɓun layukan.
Ctrl + 0Ɓoye ginshiƙan da aka zaɓa.
Ctrl + 1Yana buɗe taga Format Cells.
Ctrl + 5Kunna ƙaddamarwa.
Ctrl + Shift + $Amfani da kudin waje.
Ctrl + Shift +%Amfani da kashi.

Gajerun hanyoyin allo a cikin akwatin maganganu na Manna na Musamman a cikin Excel 2013

Wannan sigar editan maƙunsar bayanai tana da fasali na musamman da ake kira Manna Special.

2

Ana amfani da maɓallai masu zuwa a cikin wannan taga:

AƘara duk abun ciki.
FƘara dabara.
VƘara dabi'u.
TƘara tsarin asali kawai.
CƘara bayanin kula da bayanin kula.
NƘara zaɓuɓɓukan dubawa.
HƘara tsari.
XƘara ba tare da iyakoki ba.
WƘara tare da faɗin asali.

Gajerun hanyoyin allo don ayyuka da zaɓuɓɓuka

Shift + KIBI →  / ← Ƙara filin zaɓi zuwa dama ko hagu.
Shift + SpaceZaɓin duka layin.
Ctrl+SpaceZaɓin gaba ɗaya shafi.
Ctrl+Shift+SpaceZaɓin dukan takardar.

Gajerun hanyoyin allo don aiki tare da bayanai, ayyuka, da mashaya dabara

F2Canjin filin.
Canji + F2Ƙara bayanin kula.
Ctrl + XYanke bayanai daga filin.
Ctrl + CKwafi bayanai daga filin.
Ctrl + VƘara bayanai daga filin.
Ctrl + Alt + VBude taga "Haɗe-haɗe na Musamman".
shareCire cika filin.
Alt + ShigaSaka komawa cikin fili.
F3Ƙara sunan filin.
Alt + H + D + CCire shafi.
EscSoke shigowa cikin fili.
ShigarCika shigar da ke cikin filin.

Gajerun hanyoyin allo a cikin Wutar Wuta

PCMBuɗe menu na mahallin.
Ctrl + AZaɓin duka tebur.
CTRL + DCire dukkan allon.
CTRL+MMotsawa farantin.
Ctrl+RSake suna tebur.
CTRL + S.Ajiye.
CTRL+YKwafi tsarin da ya gabata.
CTRL+ZKomawar matsananciyar hanya.
F5Bude taga "Go".

Gajerun hanyoyin allo a cikin add-ins na Office

CTRL + matsawa + F10Buɗe menu.
CTRL+SPACEBayyana fagen ayyuka.
CTRL+SPACE sannan ka danna CloseRufe filin aiki.

Maɓallan ayyuka

F1Kunna taimako.
F2Ana gyara tantanin halitta da aka zaɓa.
F3Matsar zuwa akwatin "Sunan a ƙarshen".
F4Maimaita aikin da ya gabata.
F5Je zuwa taga "Go".
F6Canji tsakanin abubuwa na editan tebur.
F7Bude taga "Haruffa".
F8Kunna zaɓi mai tsawo.
F9Ƙididdigar takarda.
F10Kunna alamu.
F11Ƙara ginshiƙi.
F12Je zuwa taga "Ajiye As".

Sauran gajerun hanyoyin madannai masu amfani

Alt+'Yana buɗe taga gyaran salon salula.
BACKSPACE

 

Share wani hali.
ShigarƘarshen saitin bayanai.
ESCSoke saitin
GIDAKoma zuwa farkon takardar ko layi.

Kammalawa

Tabbas, akwai wasu maɓallai masu zafi a cikin editan rubutu. Mun yi bitar haɗaɗɗen shahararrun da aka fi amfani da su. Yin amfani da waɗannan maɓallan zai taimaka wa masu amfani suyi aiki da sauri a cikin editan maƙunsar rubutu.

Leave a Reply