Kana ukashandisa Microsoft Excel kazhinji unogona kunge waona kuti kuchinja pakati pemapepa ekushanda akasiyana muexcel kwakaoma. Dzimwe nguva kuchinja pakati pemapepa ekushanda mashoma kunoratidzika kunge kuri nyore. Nzira yakajairika yekuchinja ma tabo kudzvanya pane yega yega tab. Nekudaro, kana zvasvika pakubata akawanda mapepa ekushanda mune imwe excel, ibasa rinonetesa. Naizvozvo, kuve neruzivo nezve mapfupi uye makiyi mapfupi anozobatsira zvakanyanya. Uye aya mapfupi anogona kubatsira mukuwedzera chigadzirwa chako. Ngatikurukurei nzira dzaunokwanisa nadzo chinja nyore pakati pemapepa ekushanda akasiyana mune imwe excel.
Kushandisa makiyi ekudimbudzira hakuite kuti uve nehusimbe asi kunowedzera kugadzirwa kwako uye kunokuchengetera nguva yakawanda yaunogona kupedza uri mune rimwe basa. Dzimwe nguva, yako touchpad kana mbeva yakamira kushanda uye mumamiriro ezvinhu akadaro, mapfupi ekhibhodi anouya zvakanyanya. Naizvozvo, Excel mapfupi ndidzo nzira dzinobatsira dzekumhanyisa basa rako.
Zviri mukati[ hide ]
- Kurumidza Chinja Pakati Pemashiti Ekushanda muExcel
- Method 1: Shortcut Keys kuchinja pakati peMashizha ekushanda muExcel
- Method 2: Enda Kurairo kuti ufambe uchitenderedza excel worksheets
- Method 3: Famba kune rakasiyana pepa rekushanda uchishandisa Ctrl + Kuruboshwe Key
Kurumidza Chinja Pakati Pemashiti Ekushanda muExcel
Method 1: Shortcut Keys kuchinja pakati peMashizha ekushanda muExcel
Ctrl + PgUp (peji kumusoro) - Fambisa pepa rimwe kuruboshwe.
Paunoda kutamira kuruboshwe:
1. Dzvanya uye bata Ctrl kiyi pakiibhodhi.
2. Dzvanya uye sunungura kiyi yePgUp pane keyboard.
3. Kufambisa rimwe pepa kuruboshwe wobva wasunungura kiyi yePgUp kechipiri.
Ctrl + PgDn (peji pasi) - Fambisa pepa rimwe kurudyi.
Paunoda kurudyi:
1. Dzvanya uye bata Ctrl kiyi pakiibhodhi.
2. Dzvanya uye sunungura kiyi yePgDn pane keyboard.
3. Kuenda kune rimwe pepa kune kurudyi wobva wasunungura kiyi yePgDn kechipiri.
Zvakare Verenga: Chii chinonzi XLSX faira & Maitiro ekuvhura XLSX Faira?
Method 2: Enda Kurairo kuti ufambe uchitenderedza excel worksheets
Kana iwe uine pepa reExcel rine data rakawanda, Go To command inogona kukubatsira kuenda kumaseru akasiyana. Izvo hazvibatsiri kune mapepa ekushanda ane yakaderera vhoriyamu yedata. Naizvozvo, zvinorairwa kushandisa uyu murairo chete kana iwe uine excel faira ine yakawanda yakawanda data.
Danho 1: Enda kune iyo Edit menyu sarudzo.
Danho 2: Dzvanya pane Tsvaga & Sarudza sarudzo wobva wasarudza iyo Enda ku Option.
Danho rechitatu: Heino nyora referensi kwaunoda kuenda: Sheet_name + exclamation mark + iyo cell reference.
Ongorora: Semuyenzaniso, kana paine Sheet 1, Sheet2, uye Sheet3 ipapo mureferensi unofanirwa kunyora zita reshizha raunoda kuenda kwariri ipapo referensi yesero. Saka kana iwe uchida kuenda kune sheet 3 wobva wanyora Sheet3!A1 uko A1 ndiyo inotaridza sero muSheet 3.
Danho 4: Zvino dzvanya Ok kana kudzvanya Enter kiyi mu keyboard.
Method 3: Famba kune rakasiyana pepa rekushanda uchishandisa Ctrl + Kuruboshwe Key
Neiyi nzira, iwe unowana bhokisi renhaurirano rine ese anowanikwa mapepa ebasa pane yako excel kuti ushandure pakati. Pano unogona kusarudza nyore pepa rekushanda raunoda kushanda naro. Iyi ndiyo imwe nzira yaungasarudze kuti uchinje pakati pemapepa ebasa anowanikwa mune yako yazvino excel faira.
Kune akati wandei mamwe mapfupi eExcel anogona kukubatsira kuti zvinhu zvako zviitwe mukunaka nenzira iri nyore uye nekukurumidza.
CTRL +; Neizvi, unogona Kuisa iyo yazvino zuva musero rinoshanda
CTRL + A Ichasarudza pepa rebasa rose
ALT + F1 Ichagadzira chati yedata muhuwandu hwazvino
SHIFT + F3 Nekudzvanya iyi nzira yekudimbudzira, ichaburitsa iyo Insert Function dialog box
SHIFT + F11 Ichaisa pepa rebasa idzva
CTRL + HOME Iwe unogona kuenda kune kutanga kwepepa rekushanda
CTRL + SPACEBAR Ichasarudza koramu yose mupepa rekushanda
SHIFT + SPACEBAR Neizvi, unogona kusarudza mutsara wose mupepa rekushanda
Zvakakosha here kusarudza makiyi ekudimbudzira ekushanda paExcel?
Zvakare Verenga : Gadzirisa Excel yakamirira imwe application kuti ipedze OLE chiito
Iwe unoda kuramba uchipuruzira nekudzvanya pamapepa ebasa zuva rese kana kuti unoda kuti basa rako riitwe nekukurumidza uye kupedza imwe nguva yakanaka nevezera rako uye vaunoshanda navo? Kana iwe uchida kuti zvinhu zvako zviitwe nekukurumidza, excel mapfupi ndiyo nzira yakanakisa yekuita izvi. Kune akawanda mamwe mapfupi anowanikwa emabasa akasiyana paExcel, kana uchikwanisa kurangarira ese, zvinokuita iwe superhero muExcel. Nekudaro, iwe unogona chete kurangarira mapfupi aunowanzo shandisa kubasa rako sezvo achizokubatsira kuti mabasa ako ezuva nezuva aitwe nekukurumidza.
Elon Decker Elon munyori wehunyanzvi paCyber S. Anga achinyora maitirwo-magwara kweanenge makore matanhatu zvino uye akafukidza akawanda misoro. Anoda kuvhara misoro ine chekuita neWindows, Android, uye azvino matipi uye matipi.