Idan kuna amfani da Microsoft Excel akai-akai kuna iya lura cewa sauyawa tsakanin takaddun aiki daban-daban a cikin Excel yana da wahala sosai. Wani lokaci sauyawa tsakanin ƴan takardun aiki yana da sauƙi. Hanyar da ta fi dacewa ta sauya shafuka ita ce danna kowane shafi. Koyaya, idan ana batun sarrafa takaddun aiki da yawa a cikin Excel guda ɗaya, aiki ne mai wahala. Don haka, samun ilimi game da gajerun hanyoyi da gajerun maɓalli zai zama da amfani sosai. Kuma waɗannan gajerun hanyoyin na iya zama masu taimako wajen haɓaka aikin ku. Bari mu tattauna hanyoyin da za ku iya sauƙin canzawa tsakanin takardun aiki daban-daban a cikin Excel ɗaya.
Yin amfani da maɓallan gajerun hanyoyi ba ya sa ku kasala amma yana ƙara haɓaka aikin ku kuma yana ceton ku lokaci mai yawa da za ku iya kashewa a wasu ayyukan. Wani lokaci, touchpad ko linzamin kwamfuta ya daina aiki kuma a wannan yanayin, gajerun hanyoyin keyboard suna zuwa sosai. Don haka, Gajerun hanyoyi na Excel su ne hanyoyin da suka fi dacewa don hanzarta aikin aikinku.
Abubuwan da ke ciki[ boye ]
- Sauya Saurin Canja Tsakanin Aiki a cikin Excel
- Hanyar 1: Gajerun hanyoyi don canzawa tsakanin takaddun aiki a cikin Excel
- Hanyar 2: Je zuwa Umurni don motsawa kusa da takaddun aikin Excel
- Hanyar 3: Matsa zuwa takardan aiki daban-daban ta amfani da maɓallin Ctrl + Hagu
Sauya Saurin Canja Tsakanin Fayilolin Aiki a cikin Excel
Hanyar 1: Gajerun hanyoyi don canzawa tsakanin takaddun aiki a cikin Excel
Ctrl + PgUp (shafi sama) - Matsar da takarda ɗaya zuwa hagu.
Lokacin da kake son matsawa zuwa hagu:
1. Danna kuma ka riƙe maɓallin Ctrl akan maballin.
2. Danna kuma saki maɓallin PgUp akan madannai.
3. Don matsar da wani takarda zuwa hagu latsa kuma saki maɓallin PgUp a karo na biyu.
Ctrl + PgDn (shafi ƙasa) - Matsar da takarda ɗaya zuwa dama.
Lokacin da kake son zuwa dama:
1. Danna kuma ka riƙe maɓallin Ctrl akan maballin.
2. Danna kuma saki maɓallin PgDn akan madannai.
3. Don matsawa zuwa ɗayan takardar zuwa dama danna kuma saki maɓallin PgDn a karo na biyu.
Karanta kuma: Menene fayil XLSX & Yadda ake buɗe Fayil XLSX?
Hanyar 2: Je zuwa Umurni don motsawa kusa da takaddun aikin Excel
Idan kuna da takardar Excel mai tarin bayanai, Tafi don umarni na iya taimaka muku kewayawa zuwa sel daban-daban. Ba shi da amfani ga takaddun aikin da ke ɗauke da ƙananan ƙarar bayanai. Saboda haka, ana ba da shawarar yin amfani da wannan umarni kawai lokacin da kake da fayil na Excel tare da adadi mai yawa.
Mataki 1: Kewaya zuwa Gyara zabin menu.
Mataki 2: Danna kan Nemo & Zaɓi zaɓi sannan zaɓi Tafi Zuwa Zabin.
Mataki na 3: Nan rubuta da reference inda kake son zuwa: Sheet_name + alamar tambaya + bayanin tantanin halitta.
Lura: Misali, idan akwai Sheet 1, Sheet2, da Sheet3 to a cikin ma'anar kuna buƙatar rubuta sunan takardar da kuke son zuwa sannan kuma bayanan cell. Don haka idan kuna buƙatar zuwa takarda 3 sannan ku buga Tafi3!A1 inda A1 shine ma'anar tantanin halitta a cikin Sheet 3.
Mataki 4: Yanzu danna Ko ko danna Shigar da maɓalli a cikin keyboard.
Hanyar 3: Matsa zuwa takardan aiki daban-daban ta amfani da maɓallin Ctrl + Hagu
Tare da wannan hanyar, zaku sami akwatin tattaunawa tare da duk takaddun aikin da ke akwai akan Excel ɗin ku don canzawa tsakanin. Anan zaka iya zabar takardar aiki cikin sauƙi wanda kake son yin aiki akai. Wannan wata hanya ce da za ku iya zaɓar don kunna tsakanin takaddun aiki da ke cikin fayil ɗin Excel na yanzu.
Akwai wasu gajerun hanyoyin Excel da yawa waɗanda zasu iya taimaka muku don yin abubuwanku cikin Excel cikin mafi sauƙi kuma mafi sauri.
CTRL + ; Tare da wannan, zaku iya shigar da kwanan wata a cikin tantanin halitta mai aiki
CTRL + A Zai zaɓi dukan takardar aikin
ALT + F1 Zai ƙirƙiri ginshiƙi na bayanai a cikin kewayon yanzu
SHIFT + F3 Ta danna wannan gajeriyar hanyar, zai tashi akwatin maganganu Saka Aiki
SHIFT + F11 Zai saka sabon takardar aiki
CTRL + GIDA Kuna iya matsawa zuwa farkon takardar aiki
CTRL + SPACEBAR Zai zaɓi dukan ginshiƙi a cikin takardar aiki
SHIFT + SPACEBAR Da wannan, zaku iya zaɓar jeri gaba ɗaya a cikin takardar aiki
Shin yana da daraja don zaɓar maɓallan gajerun hanyoyi don aiki akan Excel?
Hakanan Karanta : Gyara Excel yana jiran wani aikace-aikacen don kammala aikin OLE
Kuna so ku ci gaba da gungurawa da danna kan takaddun aiki a duk rana ko kuna son yin aikinku cikin sauri kuma ku ciyar da ɗan lokaci mai kyau tare da takwarorinku da abokan aiki? Idan kuna son aiwatar da abubuwanku cikin sauri, gajerun hanyoyin Excel sune hanya mafi kyau don yin wannan. Akwai sauran gajerun hanyoyi da yawa don ayyuka daban-daban akan Excel, idan zaku iya tunawa duka, zai sa ku zama gwarzo a cikin Excel. Koyaya, zaku iya tunawa kawai gajerun hanyoyin da kuke yawan amfani da su don aikinku saboda zai taimaka muku samun ayyukanku na yau da kullun cikin sauri.
Elon Decker Elon marubucin fasaha ne a Cyber S. Ya kasance yana rubuta yadda ake jagorori kusan shekaru 6 yanzu kuma ya rufe batutuwa da yawa. Yana son rufe batutuwan da suka shafi Windows, Android, da sabbin dabaru da shawarwari.