Ngati mumagwiritsa ntchito Microsoft Excel pafupipafupi mwina mwazindikira kuti kusintha pakati pamasamba osiyanasiyana mu Excel ndikovuta. Nthawi zina kusintha pakati pa mapepala ochepa ogwirira ntchito kumakhala kosavuta. Njira yodziwika kwambiri yosinthira ma tabo ndikudina pa tabu iliyonse. Komabe, zikafika pakuwongolera mapepala ambiri mu Excel imodzi, ndi ntchito yotopetsa kwambiri. Chifukwa chake, kukhala ndi chidziwitso chokhudza njira zazifupi ndi makiyi achidule kudzakuthandizani kwambiri. Ndipo njira zazifupizi zitha kukhala zothandiza pakukulitsa zokolola zanu. Tiyeni tikambirane njira zomwe mungathe sinthani mosavuta pakati pamasamba osiyanasiyana mu Excel imodzi.
Kugwiritsa ntchito makiyi a njira yachidule sikumakupangitsani kukhala waulesi koma kumawonjezera zokolola zanu ndikukupulumutsirani nthawi yochuluka yomwe mutha kuthera pa ntchito zina. Nthawi zina, touchpad yanu kapena mbewa inasiya kugwira ntchito ndipo zikatero, njira zazifupi za kiyibodi zimakhala zothandiza kwambiri. Chifukwa chake, Njira zazifupi za Excel ndi njira zothandiza kwambiri zofulumizitsa ntchito yanu.
Zamkatimu[ kubisa ]
- Sinthani Mwamsanga Pakati pa Mapepala Ogwira Ntchito mu Excel
- Njira 1: Mafungulo achidule kuti musinthe pakati pa Mapepala Ogwira Ntchito mu Excel
- Njira 2: Pitani ku Lamulo kuti muyende mozungulira ma sheet a Excel
- Njira 3: Pitani kumasamba osiyanasiyana pogwiritsa ntchito Ctrl + Left Key
Sinthani Mwamsanga Pakati pa Mapepala Ogwira Ntchito mu Excel
Njira 1: Mafungulo achidule kuti musinthe pakati pa Mapepala Ogwira Ntchito mu Excel
Ctrl + PgUp (tsamba mmwamba) - Sunthani pepala limodzi kumanzere.
Mukafuna kusamukira kumanzere:
1. Dinani ndi kugwira Ctrl kiyi pa kiyibodi.
2. Dinani ndi kumasula kiyi ya PgUp pa kiyibodi.
3. Kusuntha pepala lina kumanzere kukanikiza ndikumasula kiyi ya PgUp kachiwiri.
Ctrl + PgDn (tsamba pansi) - Sunthani pepala limodzi kumanja.
Mukafuna kumanja:
1. Dinani ndi kugwira Ctrl kiyi pa kiyibodi.
2. Dinani ndi kumasula kiyi ya PgDn pa kiyibodi.
3. Kusunthira ku pepala lina kukasindikiza kumanja ndikumasula kiyi ya PgDn kachiwiri.
Komanso Werengani: Fayilo ya XLSX ndi chiyani & Momwe mungatsegule Fayilo ya XLSX?
Njira 2: Pitani ku Lamulo kuti muyende mozungulira ma sheet a Excel
Ngati muli ndi pepala la Excel lomwe lili ndi zambiri zambiri, Go To command kungakuthandizeni kupita ku ma cell osiyanasiyana. Ndizosathandiza pamapepala omwe ali ndi data yochepa kwambiri. Chifukwa chake, ndikulangizidwa kugwiritsa ntchito lamuloli pokhapokha mukakhala ndi fayilo ya Excel yokhala ndi data yambiri.
Gawo 1: Pitani ku Sinthani menyu njira.
Gawo 2: Dinani pa Pezani & Sankhani njira ndiye kusankha Pitani Ku Njira.
Gawo 3: Apa lembani zolembazo komwe mukufuna kupita: Sheet_name + chilengezo + chofotokozera cha cell.
Zindikirani: Mwachitsanzo, ngati pali Mapepala 1, Sheet2, ndi Sheet3 ndiye muzofotokozera muyenera kulemba dzina lachipepala lomwe mukufuna kupitako ndiye tsamba la cell. Chifukwa chake ngati mukufuna kupita patsamba 3 ndiye lembani Tsamba3!A1 pomwe A1 ndiye kalozera wa cell mu Tsamba 3.
Gawo 4: Tsopano dinani Chabwino kapena dinani Lowetsani kiyi mu kiyibodi.
Njira 3: Pitani kumasamba osiyanasiyana pogwiritsa ntchito Ctrl + Left Key
Ndi njirayi, mupeza bokosi la zokambirana ndi mapepala onse omwe alipo pa Excel yanu kuti musinthe pakati. Apa mutha kusankha mosavuta tsamba lomwe mukufuna kugwira ntchito. Iyi ndi njira ina yomwe mungasankhire kuti musinthe pakati pa mapepala omwe alipo mu fayilo yanu ya Excel yomwe ilipo.
Pali njira zazifupi zingapo za Excel zomwe zingakuthandizeni kuti zinthu zanu zitheke mu Excel m'njira yosavuta komanso yachangu kwambiri.
CTRL +; Ndi izi, mutha Kulowetsa tsiku lomwe lilipo mu cell yogwira
CTRL + A Idzasankha pepala lonse la ntchito
ALT + F1 Ipanga tchati cha data yomwe ili mumtundu wapano
SHIFT + F3 Mukakanikiza njira yachidule iyi, itulukira bokosi la Insert Function dialog box
SHIFT + F11 Ilowetsa tsamba lantchito latsopano
CTRL + HOME Mukhoza kupita ku chiyambi cha ntchito
CTRL + SPACEBAR Idzasankha ndime yonse mutsamba lantchito
SHIFT + SPACEBAR Ndi izi, mutha kusankha mzere wonse patsamba lantchito
Kodi ndikoyenera kusankha makiyi achidule kuti mugwiritse ntchito pa Excel?
Komanso Werengani : Konzani Excel ikuyembekezera pulogalamu ina kuti imalize OLE
Kodi mukufuna kupitiriza kuyang'ana ndikudina pamasamba tsiku lonse kapena mukufuna kuti ntchito yanu ichitike mwachangu ndikukhala ndi nthawi yabwino ndi anzanu ndi anzanu? Ngati mukufuna kuti zinthu zanu zichitike mwachangu, njira zazifupi za Excel ndiye njira yabwino kwambiri yochitira izi. Pali njira zambiri zazifupi zomwe zimapezeka pantchito zosiyanasiyana pa Excel, ngati mutha kuzikumbukira zonse, zimakupangani kukhala ngwazi ku Excel. Komabe, mutha kukumbukira njira zazifupi zomwe mumagwiritsa ntchito pafupipafupi pantchito yanu chifukwa zingakuthandizeni kuti ntchito zanu zatsiku ndi tsiku zizichitika mwachangu.
Elon Decker Elon ndi mlembi waukadaulo ku Cyber S. Wakhala akulemba zowongolera kwa zaka pafupifupi 6 tsopano ndipo wafotokoza mitu yambiri. Amakonda kuphimba mitu yokhudzana ndi Windows, Android, ndi zidule ndi malangizo aposachedwa.